Hello;   I currently have the following variables in my dataset. c3r1 c3r2 c3r3 c3r4 c3r5 c3r6 c3r52 c3r56 c3ar1 c3ar2    I want to compute a new variable using the following rule: 1. If C3r1 or c3r2 or c3r3 ... c3r56 = 8 or 9 and c3ar1 = missing, then new variable = 99.   data temp; set temp; C3a_RB_r1= c3ar1; if (c3r: = 8 or c3r: = 9) AND (c3ar1) = . then C3a_RB_r1= 99; C3a_RB_r2= c3ar2; if (c3r: = 8 or c3r: = 9) AND (c3ar2) = . then C3a_RB_r2= 99; run;   For the sake of demonstration, I have included few variables here. I'm trying to get a succinct code. Please note that I want to rebase c3ar1 and c3ar2 in the example above. In my original dataset, I have c3ar1 to c3ar15, and so I would want to create 15 new variables c3a_RB_r1 to c3a_RB_r15. c3r: = 8 or 9 will be constant.   It would be great if I could get some help.   Tanks, Neel   ... View more

Hello All,   I am a noob sas user. I'm more proficient in R, but SAS is totally new to me. I'm facing multiple issues reading a large file too.   proc import datafile = ".\my_data.csv" out = work.imported_data dbms = csv replace; guessingrows = 1000; run; The csv file that I'm trying to import does not read in the correct variable names. My csv has 3055 variables.   Currently, proc export is reading the variables names up to 2933 variables correctly and then renaming the remaining variables as VAR2934, VAR2935, VAR2936... VAR3055.    I have tried getnames = no and obs = 1 option as well. The first row does not read in correctly. I've found the issue on google. It seems that the LRECL of the first row is greater than 32767 bytes/characters.    Do you know how I can change the LRECL to read in the data correctly?    I have attached the data and code for your reference.    Currently I have to manually rename the variables.    Please suggest. Your help is much appreciated.   Regards, Neel ... View more