oh yes, It worked.   Guessingrows= max;   thank you so much and sorry for the mess up. ... View more

Hi , thanks for the suggestion.   I tried this but error comes at line:  rename &renames;  I have attached the log here, can you please look in to this? sorry for late reply. ... View more

Hi, Yeah I know its needed more data for you. I have attached sas codes, sas log and two data sets here. I hope it helps. ... View more

I am still working on solution, no success yet. My major concern is the error comes when there is extra variables in data2 file which are not in data1 file.   Is there any other solution? ... View more

I have changed the dataset name for "data1.csv" to work.import3 ... View more

I have tried this still same error comes, see the attached log ... View more

Hi, thanks for the help.  I notice that there is still some weird errors, when we have variables like AENF1 AENF2 . AENF10 AENF11   then these codes not read AENF10 and AENF11, Its only read upto 5 character only and the error throws for more than 5 char variables.   I have attached the sas log here. ... View more

I got this , we have to use "rename" instead of "Change".    this code is working:   proc sql noprint; select cats(oldname,'=',newname) into :renames separated by ' ' from import1; quit; proc datasets library= work nolist; modify import; rename &renames; run; quit;   there is one more issue. If there is extra variables in data2 which is not in data 1 then it throws error. like,     ERROR: Variable AENF7 is not on file WORK.IMPORT. ERROR: Variable BENF2 is not on file WORK.IMPORT.   the variables AENF7 BENF2 are not in data1 but available in data2   Is there any way to solve this? ... View more

Hi,   I also tried this but there are multiple errors, I have attached the log here. ... View more

Hi, thank you from quick response.   There is still one error, I have attached the log here. I am using sas university edition, do this make difference? ... View more

sas log attached here ... View more

proc sql print; 8186 select cats(evntkey,'=',code) separated by ' ' into:renames from conc; _________ 22 202 ERROR 22-322: Syntax error, expecting one of the following: a quoted string, !, !!, &, *, **, +, ',', -, /, <, <=, <>, =, >, >=, ?, ... View more

syntax error comes for cats function ... View more