Hi, Thanks for being patient. I succeeded with the part of importing them all one by one but I have a new trouble now. In the highlighted step, VAR2 column is getting replaced but its truncated. Eg: If value_after_editing = HANDWASH, only HANDWA is coming in VAR2 column. It is truncating after 6/7 chars. I tried INFORMAT but then column becomes empty. Help please! %MACRO edit_file(dataset, value_after_editing); data &dataset; set &dataset; VAR2= "& value_after_editing"; run; %mend edit_file; %MACRO SCANLOOP(SCANFILE,FIELD1,FIELD2,FIELD3); /* First obtain the number of */ /* records in DATALOG */ DATA _NULL_; IF 0 THEN SET &SCANFILE NOBS=X; CALL SYMPUT('RECCOUNT',X); STOP; RUN; /* loop from one to number of */ /* records */ %DO I=1 %TO &RECCOUNT; /* Advance to the Ith record */ DATA _NULL_; SET &SCANFILE (FIRSTOBS=&I); /* store the variables */ /* of interest in */ /* macro variables */ CALL SYMPUT('csv_to_imported',&FIELD1); CALL SYMPUT('dataset_name_After_importing',&FIELD2); CALL SYMPUT('Edited_value_in_column_2',&FIELD3); STOP; RUN; /* now perform the tasks that */ /* wish repeated for each */ /* observation */ %import_file(&csv_to_imported, &dataset_name_After_importing); %edit_file(&dataset_name_After_importing,&Edited_value_in_column_2); %END; %MEND SCANLOOP; /* Call SCANLOOP */ %SCANLOOP(DATALOG,FILENM,FIELD2,FIELD3); RUN;
... View more