Description of 1987 National Survey of Small Business Finance ASCII FILE (for Non-SAS Users) September 29, 1997 1. GENERAL INFORMATION The ASCII version of the 1987 National Survey of Small Business Finances is a comma delimited ASCII flat (rectangular) file. The maximum record length in the ASCII flat file is 3,838 characters. There are two samples for the survey, and hence two data sets (see 1987 Codebook for more information on sampling methodology). The main sample is named DMI.DAT. There is only one logical record for each observation for a total of 3,224 records in the data set. The second sample is named SBA.DAT. There is only one logical record for each observation for a total of 369 records in the data set. For UNIX users: the ASCII version of the samples are contained in UNIX compressed files, dmi.dat.Z and sba.dat.Z. For PC users: the ASCII version of the samples are contained in PKZIP files, dmi.dat.zip and sba.dat.zip. There is an additional file, nssbf87.txt, which lists the names of the 1,274 variables, in order of appearance in the ASCII flat files. The nssbf87.txt file should be used to generate an input list for both samples. 2. VARIABLE TYPES There are only two types of variables: character and numeric. All but 6 of the 1,274 variables in the data sets are numeric. Most of the numeric variables take on only integer values. Those numeric variables that DO NOT take on integer values are listed below. Table A1: Names of Non-integer Numeric Variables WTANAL3 R1001 R1002 R3126 R3128 The following 6 variables are character type: Table A2: Names of Character Variables I_E2 (LENGTH 9) I_E3 (LENGTH 9) I_E5 (LENGTH 9) ENDDATA (LENGTH 9) DATE (LENGTH 15) YEAR (LENGTH 60) 3. MISSING VALUES The missing values for the ASCII data sets differ from those described in the CODEBOOK. For the ASCII data, there are two sets of missing value codes. The first set of missing value codes are for variables where there are no negative values allowed. These are given below: Table A3: Missing Value Codes for Variables with Non-negative Values CODEBOOK ASCII Explanation dataset .D = -1 Don't Know .R = -2 Refused .E = -3 Exception . = -4 Missing, Other .N = -5 No Service For the following 57 variables, negative values were allowed: Table A4: Names of Variables with Negative Values Allowed R3004_1 R6505 R3004_2 R6506 R3004_3 R6507 R3004_4 R6508 R4008 R6509 R4101 R6510 R6481 R6511 R6482 R6512 R6483 R6513 R6484 R6514 R6485 R6515 R6486 R6516 R6487 R6517 R6488 R6518 R6489 R6519 R6490 R6520 R6491 R6521 R6492 R6522 R6493 R6523 R6494 R6524 R6495 R6525 R6496 R6526 R6497 R6527 R6498 R6528 R6499 RIV_A1 R6500 RIV_B7 R6501 RIV_B23 R6502 R6503 R6504 The missing value codes for these 57 variables are: Table A5: Missing Value Codes for Variables with Negative Values CODEBOOK ASCII Explanation dataset .D = -9999999991 Don't Know .R = -9999999992 Refused .E = -9999999993 Exception . = -9999999994 Missing, Other .N = -9999999995 No Service 4. EXAMPLE: READING ASCII FLAT FILE INTO SAS The following is an example of how SAS code would be written to: import the ASCII flat file into SAS, change the missing codes in the ASCII file to appropriate missing codes for SAS data sets, and output the data as a permanent SAS data set. LIBNAME mydata '/your/data/directory'; FILENAME flat '/ASCII/dataset/directory/dmi.dat'; DATA temp; LENGTH I_E2 I_E3 I_E5 ENDDATE $9 DATE $15 YEAR $60; INFILE flat DELIMITER=',' LRECL=3838; *The input list below can be generated using the file nssbf87.txt; INPUT FIRM I_D4 I_D5 I_E1 I_E2 I_E3 I_E4 I_E5 ENDDATE DATE YEAR MONTHS D_01 D_02 D_03 D_04 D_05 D_06 E_01 E_02 E_03 E_04 E_05 E_06 CENREG REM_CP SAMPLE WTANAL3 RSIC_2 R1001 R1002 R1003 R1004 R1005 R1006 R1009 R1010 R1008 R1007 R6481 R6490 R6491 R6492 R6493 R6495 R6496 R6497 R6498 R6499 R6500 R6501 R6502 R6503 R6504 R6505 R6506 R6509 R6510 R6511 R6512 R6513 R6514 R6515 R6516 R6517 R6518 R6519 R6520 R6521 R6522 R6523 R6524 R6525 R6526 R6527 R6528 R6001 R6002 R6003 R6004 R6005 R6006 R6007 R6008 R6009 R6010 R6011 R6012 R6013 R6014 R6015 R6016 R6017 R6018 R6019 R6020 R6021 R6022 R6023 R6024 R6025 R6026 R6027 R6028 R6029 R6030 R6031 R6032 R6033 R6034 R6035 R6036 R6037 R6038 R6039 R6040 R6041 R6042 R6043 R6044 R6045 R6046 R6047 R6048 R6241 R6242 R6243 R6244 R6245 R6246 R6247 R6248 R6249 R6250 R6251 R6252 R6253 R6254 R6255 R6256 R6257 R6258 R6259 R6260 R6261 R6262 R6263 R6264 R6433 R6434 R6435 R6436 R6437 R6438 R6439 R6440 R6441 R6442 R6443 R6444 R6445 R6446 R6447 R6448 R6449 R6450 R6451 R6452 R6453 R6454 R6455 R6456 R6457 R6458 R6459 R6460 R6461 R6462 R6463 R6464 R6465 R6466 R6467 R6468 R6469 R6470 R6471 R6472 R6473 R6474 R6475 R6476 R6477 R6478 R6479 R6480 RIV_A3 RIV_A5 RIV_A7 RIV_A9 RIV_A11 RIV_A13 RIV_A15A RIV_A15B RIV_A15C RIV_A16 RIV_B2 RIV_B3 RIV_B5 RIV_B9 RIV_B11A RIV_B11B RIV_B11C RIV_B12 RIV_B16 RIV_B22 BSRESULT RII_F81 RII_F82 RII_F83 RII_G121 RII_G122 RII_G123 RII_H111 RII_H112 RII_H113 R1030 R1031 R1032 R1033 R1020 R1021 R1022 R1023 R1024 R1025 R1012 R1011 R3001_1 R3001_2 R3001_3 R3001_4 R3011_1 R3011_2 R3011_3 R3011_4 R3014_1 R3014_2 R3014_3 R3014_4 R3021_1 R3021_2 R3021_3 R3021_4 R3022_1 R3022_2 R3022_3 R3022_4 R3024_1 R3024_2 R3024_3 R3024_4 R3031_1 R3031_2 R3031_3 R3031_4 R3032_1 R3032_2 R3032_3 R3032_4 R3033_1 R3033_2 R3033_3 R3033_4 R3034_1 R3034_2 R3034_3 R3034_4 R3041_1 R3041_2 R3041_3 R3041_4 R3042_1 R3042_2 R3042_3 R3042_4 R3044_1 R3044_2 R3044_3 R3044_4 R3051_1 R3051_2 R3051_3 R3051_4 R3052_1 R3052_2 R3052_3 R3052_4 R3054_1 R3054_2 R3054_3 R3054_4 R3061_1 R3061_2 R3061_3 R3061_4 R3062_1 R3062_2 R3062_3 R3062_4 R3064_1 R3064_2 R3064_3 R3064_4 R3072_1 R3074_1 R3081_1 R3082_1 R3084_1 R3084_2 R3084_3 R3084_4 R3091_1 R3092_1 R3094_1 R3094_2 R3094_3 R3094_4 R3101_1 R3102_1 R3104_1 R3104_2 R3104_3 R3104_4 R3111_1 R3112_1 R3114_1 R3114_2 R3088_1 R3088_2 R3088_3 R3088_4 R3098_1 R3098_2 R3098_3 R3098_4 R3108_1 R3108_2 R3108_3 R3108_4 R3118_1 R3118_2 R3120 R3122 R3123 R3126 R3128 R3129 R3121 R3130 R3000 R3010 R3020 R3030 R3036_1 R3036_2 R3036_3 R3036_4 R3036_1A R3036_2A R3036_3A R3036_4A R3036_1B R3036_2B R3036_3B R3036_4B R3036_1C R3036_2C R3036_3C R3036_4C R3036_1D R3036_2D R3036_3D R3036_4D R3036_1E R3036_2E R3036_3E R3036_4E R3036_1F R3036_2F R3036_3F R3036_4F R3035_1 R3035_2 R3035_3 R3035_4 R3037_1 R3037_2 R3037_3 R3037_4 R3037_1A R3037_2A R3037_3A R3037_4A R3037_1B R3037_2B R3037_3B R3037_4B R3037_1C R3037_2C R3037_3C R3037_4C R3037_1D R3037_2D R3037_3D R3037_4D R3037_1E R3037_2E R3037_3E R3037_4E R3040 R3045_1 R3045_2 R3045_3 R3045_4 R3047_1 R3047_2 R3047_3 R3047_4 R3047_1A R3047_2A R3047_3A R3047_4A R3047_1B R3047_2B R3047_3B R3047_4B R3047_1C R3047_2C R3047_3C R3047_4C R3047_1D R3047_2D R3047_3D R3047_4D R3047_1E R3047_2E R3047_3E R3047_4E R3050 R3055_1 R3055_2 R3055_3 R3055_4 R3057_1 R3057_2 R3057_3 R3057_4 R3057_1A R3057_2A R3057_3A R3057_4A R3057_1B R3057_2B R3057_3B R3057_4B R3057_1C R3057_2C R3057_3C R3057_4C R3057_1D R3057_2D R3057_3D R3057_4D R3057_1E R3057_2E R3057_3E R3057_4E R3060 R3065_1 R3065_2 R3065_3 R3065_4 R3067_1 R3067_2 R3067_3 R3067_4 R3067_1A R3067_2A R3067_3A R3067_4A R3067_1B R3067_2B R3067_3B R3067_4B R3067_1C R3067_2C R3067_3C R3067_4C R3067_1D R3067_2D R3067_3D R3067_4D R3067_1E R3067_2E R3067_3E R3067_4E R3070 R3076_1 R3076_1A R3076_1B R3076_1C R3076_1D R3076_1E R3076_1F R3077_1 R3077_1A R3077_1B R3077_1E R3080 R3086_1 R3086_2 R3086_3 R3086_4 R3086_1A R3086_2A R3086_3A R3086_4A R3086_1B R3086_2B R3086_3B R3086_4B R3086_1G R3086_2G R3086_3G R3086_4G R3086_1C R3086_2C R3086_3C R3086_4C R3086_1D R3086_2D R3086_3D R3086_4D R3086_1E R3086_2E R3086_3E R3086_4E R3086_1F R3086_2F R3086_3F R3086_4F R3085_1 R3085_2 R3085_3 R3085_4 R3087_1 R3087_2 R3087_3 R3087_4 R3087_1A R3087_2A R3087_3A R3087_4A R3087_1B R3087_2B R3087_3B R3087_4B R3087_1C R3087_2C R3087_3C R3087_4C R3087_1D R3087_2D R3087_3D R3087_4D R3087_1E R3087_2E R3087_3E R3087_4E R3096_1 R3096_2 R3096_3 R3096_4 R3096_1A R3096_2A R3096_3A R3096_4A R3096_1B R3096_2B R3096_3B R3096_4B R3096_1G R3096_2G R3096_3G R3096_4G R3096_1C R3096_2C R3096_3C R3096_4C R3096_1D R3096_2D R3096_3D R3096_4D R3096_1E R3096_2E R3096_3E R3096_4E R3096_1F R3096_2F R3096_3F R3096_4F R3095_1 R3095_2 R3095_3 R3095_4 R3097_1 R3097_2 R3097_3 R3097_4 R3097_1A R3097_2A R3097_3A R3097_4A R3097_1B R3097_2B R3097_3B R3097_4B R3097_1C R3097_2C R3097_3C R3097_4C R3097_1D R3097_2D R3097_3D R3097_4D R3097_1E R3097_2E R3097_3E R3097_4E R3106_1 R3106_2 R3106_3 R3106_4 R3106_1A R3106_2A R3106_3A R3106_4A R3106_1B R3106_2B R3106_3B R3106_4B R3106_1G R3106_2G R3106_3G R3106_4G R3106_1C R3106_2C R3106_3C R3106_4C R3106_1D R3106_2D R3106_3D R3106_4D R3106_1E R3106_2E R3106_3E R3106_4E R3106_1F R3106_2F R3106_3F R3106_4F R3105_1 R3105_2 R3105_3 R3105_4 R3107_1 R3107_2 R3107_3 R3107_4 R3107_1A R3107_1B R3107_1C R3107_1D R3107_1E R3116_1 R3116_2 R3116_1A R3116_2A R3116_1B R3116_2B R3116_1G R3116_2G R3116_1C R3116_2C R3116_1D R3116_2D R3116_1E R3116_2E R3116_1F R3116_2F R3115_1 R3115_2 R3117_1 R3117_2 R3124 R3125 R3127 R3131 R3132 R3133 R3134 R3135 R3136 R3137 R3138 R3139 R3310 R3311 R3312 R3313_B R3317_B R3320 R3321 R3322 R3323_B R3327_B R3330 R3331 R3332 R3333_B R3337_B R3340 R3341 R3342 R3343_B R3347_B R3350 R3351 R3352 R3353_B R3357_B R3360 R3361 R3362 R3363_B R3367_B R3370 R3373_B R3380 R3383_B R3390 R3393_B R3400 R3403_B R3410 R3420 R3423_B R4001 R4002 R4003 R4004 R4005 R4006 R3313_A R3314 R3315 R3316 R3317_A R3318 R3323_A R3324 R3325 R3326 R3327_A R3328 R3333_A R3334 R3335 R3336 R3337_A R3338 R3343_A R3344 R3345 R3346 R3347_A R3348 R3353_A R3354 R3355 R3356 R3357_A R3358 R3363_A R3364 R3365 R3366 R3367_A R3368 R3373_A R3383_A R3393_A R3403_A R3413_A R3423_A R4000 R4007 RIV_B10A RIV_B10B RIV_B10C RIV_A14A RIV_A14B RIV_A14C R3119 R3700 R3701 R3702 R3703 R3704 R3705 R3706 R3450 R3451 R3600 R3601 R3602 R3603 R3604 R3605 R3606 R3607 R3608 R3610 R3611 R3612 R3613 R3650 R3651 R3652 R3653 R3654 R3655 R3656 R3657 R3658 R3659 R3660 R3661 R3662 R3663 R3664 R3665 R3666 R3667 R3670 R3671 R3672 R3680 R3681 R3682 R3683 R3684 R3685 R3686 R3687 R3688 R3689 R3690 R3691 R3692 R3693 R3694 R3750 R3751 R3752 R3753 R3754 R3755 R3756 R3757 R3758 R3759 R3760 R3761 R3762 R4102 R4103 R4104 R4105 R4106 R4107 R5001 R5002 R5003 R5004 R5005 R5006 R5007 R5008 R5009 R5010 R3140 R3142 R3144 R3146 R3148 R3150 R3152 R3141_1 R3141_2 R3141_3 R3141_4 R3143_1 R3143_2 R3143_3 R3143_4 R3145_1 R3145_2 R3145_3 R3145_4 R3147_1 R3147_2 R3147_3 R3147_4 R3149_1 R3149_2 R3149_3 R3149_4 R3151_1 R3151_2 R3151_3 R3151_4 R3153_1 R3153_2 R3153_3 R3153_4 R3154_1 R3154_2 R3154_3 R3154_4 R3155_1 R3155_2 R3155_3 R3155_4 R3156_1 R3156_2 R3156_3 R3156_4 R3157_1 R3157_2 R3157_3 R3157_4 R3158_1 R3158_2 R3158_3 R3158_4 R3159_1 R3159_2 R3159_3 R3159_4 R3160_1 R3160_2 R3160_3 R3160_4 R3161_1 R3161_2 R3161_3 R3161_4 R3107_2A R3107_2B R3107_2C R3107_2D R3107_2E R3107_3A R3107_3B R3107_3C R3107_3D R3107_3E R3107_4A R3107_4B R3107_4C R3107_4D R3107_4E R3117_1A R3117_1B R3117_1C R3117_1D R3117_1E R3117_2A R3117_2B R3117_2C R3117_2D R3117_2E R6901 R6902 R6903 R6904 R6905 R6906 R6907 R6908 R6909 R6910 R6911 R6912 R6913 R6914 R6915 R6916 R6917 R6918 R6919 R6920 R6921 R6922 R6923 R6924 R6925 R6926 R6927 R6928 R6929 R6930 R6931 R6932 R6933 R6934 R6935 R6936 R6937 R6938 R6939 R6940 R6941 R6942 R6943 R6944 R6945 R6946 R6947 R6948 R6949 R6950 R6951 R6952 R6953 R6954 R6955 R6956 R6957 R6958 R6959 R6960 R6961 R6962 R6963 R6964 R6965 R6966 R6967 R6968 R6969 R6970 R6971 R6972 R6973 R6974 R6975 R6976 R6977 R6978 R6979 R6980 R6981 R6982 R6983 R6984 R6985 R6986 R6987 R6988 R6989 R6990 R6991 R6992 R6993 R6994 R6995 R6996 R6697 R6698 R6699 R6700 R6701 R6702 R6703 R6704 R6705 R6706 R6707 R6708 R6709 R6710 R6711 R6712 R6713 R6714 R6715 R6716 R6717 R6718 R6719 R6720 R6721 R6722 R6723 R6724 R6725 R6726 R6727 R6728 R6729 R6730 R6731 R6732 R6733 R6734 R6735 R6736 R6737 R6738 R6739 R6740 R6741 R6742 R6743 R6744 R6745 R6746 R6747 R6748 R6749 R6750 R6751 R6752 R6753 R6754 R6755 R6756 R6757 R6758 R6759 R6760 R6761 R6762 R6763 R6764 R6765 R6766 R6767 R6768 R6769 R6770 R6771 R6772 R6773 R6774 R6775 R6776 R6777 R6778 R6779 R6780 R6781 R6782 R6783 R6784 R6785 R6786 R6787 R6788 R6789 R6790 R6791 R6792 R6801 R6802 R6803 R6804 R6805 R6806 R6807 R6808 R6809 R6810 R6811 R6812 R6813 R6814 R6815 R6816 R6817 R6818 R6819 R6820 R6821 R6822 R6823 R6824 R1206 R1210 URBAN RII_D3A1 RII_D3A2 RII_D3A3 RII_D3B1 RII_D3B2 RII_D3B3 RII_D3C1 RII_D3C2 RII_D3C3 RII_D3D1 RII_D3D2 RII_D3D3 RII_D3E1 RII_D3E2 RII_D3E3 RII_D3F1 RII_D3F2 RII_D3F3 RII_D4A1 RII_D4A2 RII_D4A3 RII_D4B1 RII_D4B2 RII_D4B3 RII_D4C1 RII_D4C2 RII_D4C3 RII_D4D1 RII_D4D2 RII_D4D3 RII_D4E1 RII_D4E2 RII_D4E3 RII_D4F1 RII_D4F2 RII_D4F3 FIRM_BR R3413_B R1004REV R1005REV STRATUM R6482 R6483 R6484 R6485 R6486 R6487 R6488 R6489 R6494 R6507 R6508 RIV_A1 RIV_B7 R3004_1 R3004_2 R3004_3 R3004_4 R4008 RIV_B23 R4101; RUN; DATA temp2; SET temp(DROP=r3004_1-r3004_4 r4008 r4101 r6482-r6489 r6494 r6507 r6508 riv_a1 riv_b23 riv_b7); ARRAY _num(*) _NUMERIC_; DO i=1 to DIM(_num); IF _num(i)=-5 THEN _num(i)=.N; IF _num(i)=-4 THEN _num(i)=.; IF _num(i)=-3 THEN _num(i)=.E; IF _num(i)=-2 THEN _num(i)=.R; IF _num(i)=-1 THEN _num(i)=.D; END; DROP i; RUN; DATA temp3; SET temp(KEEP=firm r3004_1-r3004_4 r4008 r4101 r6482-r6489 r6494 r6507 r6508 riv_a1 riv_b23 riv_b7); ARRAY _numbr(*) _NUMERIC_; DO i=1 to DIM(_numbr); IF _numbr(i)=-9999999991 THEN _numbr(i)=.D; IF _numbr(i)=-9999999992 THEN _numbr(i)=.R; IF _numbr(i)=-9999999993 THEN _numbr(i)=.E; IF _numbr(i)=-9999999994 THEN _numbr(i)=.; IF _numbr(i)=-9999999995 THEN _numbr(i)=.N; END; DROP i; RUN; DATA mydata.flatfile; MERGE temp2 temp3; BY pwcode; RUN;