Here is the code:   data ABC.Entire_database_second; infile "/v_share/Xiaomin/SCOPES/sas_dataset/Oct-08-2015/ScopesCalculations_SecondaryConstruction_*" linesize = 300 firstobs = 2 DSD ;     Informat C_ST $3.0 C_DSTRB_AREA $5.0 N_RSK $7.0   input C_ST $ C_DSTRB_AREA $ N_RSK $   run;   and attached is the csv file. Thank you ... View more

Cultural things are contagious 😉 ... View more

So you try to teach grammar besides SAS? haha 🙂   I think its a good article: http://popchassid.com/americas-obsession-grammar-means     Thanks for your comment though 🙂 ... View more

I see. Trying to find the cause of warning .. thank you for your time and help.   The exclamation marks are for clarity of my writing and points I would like to mention. ... View more

What do you mean exactly by "mismatch"?, in terms of what? Also, the output for that specific line(s) does not show any irregularity ! and its pretty the same as the other output lines. By any chance, could data format (two of the variables are "date" but entered as "numeric" but they look ok) cause this warning? ... View more

I understand. All I see in the log is a series of "Invalid data for variable .. in line ....." for different variables and different lines.   But when I check my raw data (csv file), I don't see anything specical or wrong with the input data!!   ... View more

Could you please give some hint regarding this warning and the possible error(s)? ... View more

The code is working now for all variables and the whole files! thank you so much 🙂   The only warning is this : WARNING: Limit set by ERRORS= option reached.  Further errors of this type will not be printed. ... View more

I got the result for one file using the code below (a minor change for the last variable):       data details_FEB; infile "/v_share/Xiaomin/SCOPES/sas_dataset/Oct-08-2015/ScopesCalculations_SecondaryConstruction_ 64_10122015_2339.csv" linesize = 300 firstobs = 2 DSD Truncover ;   Informat C_ST $2.0 C_DSTRB_AREA $4.0 N_RSK $6.0 COT00503D_SRVY $10.0; input C_ST $ C_DSTRB_AREA $ N_RSK $ COT00503D_SRVY $; run;     I got the result and looks good. But the last variable needs to be "date". I tried "MMDDYY10." for Informat but it did not work. please advise what to use for both informat and input. ... View more

Here is the code (considering the first four variables, knowing that they are all character and having those numbers of byets):   data details_FEB;   infile "/v_share/Xiaomin/SCOPES/sas_dataset/Oct-08-2015/ScopesCalculations_SecondaryConstruction_*" linesize = 300 firstobs = 2;   input @1 C_ST $2.0 @2 C_DSTRB_AREA $4.0 @3 N_RSK $6.0 @4 COT00503D_SRVY $6.0; run; ... View more

I think there is a bigger issue here:   I considered only couple of first variables with the correct format/type. Then I ran the program but as you see in the picture below, the vaules in the columns are mis-placed!!      forexample, the last column does not include any "date" !!   why? ... View more

Example: C_ST CHAR(2) C_DSTRB_AREA CHAR(4) N_RSK DECIMAL(6,0) COT00503D_SRVY CHAR(6) ... View more

Fortunately, I do have a data dictionary indicating the type and bytes for each variable. Fixing this for all the variables is going to fix the issue?, ... View more