SAS macro to read multiple rawdata files and create multiple SAS dataset for each raw data file -
sas macro read multiple rawdata files , create multiple sas dataset each raw data file
hi there
my name chandra. not @ sas macro looping part , resolving &&. etc. here problem statement.
problem statement: have large number of raw data files (.dat files) stored in folder in sas server. need macro can read each of these raw data file , create sas data set each raw data file , store them in separate target folder in sas server. these raw data files have same file layout structure. need automate operation every week, macro reads raw data files source folder , creates corresponding sas dataset , stores them in target folder in sas server. example, if there 200 raw data files in source folder, want read them , create 200 sas datasets 1 each raw data file , save them in target folder. not @ constructing looping statement , resolving && or &&& etc. how do it?
i highly appreciate kind assistance in regard.
respectfully
chandra
you don't need use macro or loop in case have files same fields. can try pipe option , filename keyword. here link
Comments
Post a Comment