Hi,
I am trying to figure out why below mentioned code is not working (problem occurs at out= statement, when I set out=a by hard, it works but creates just one file clearly...):
%let list_of_names = first second third; %macro _loop(); %do i = 1 %to 4/*%sysfunc(countw(&list_of_names))*/; proc import datafile = "\\someAddress\%scan(&list_of_names, &i).csv" out=%scan(&list_of_names, &i) dbms=csv replace; getnames=yes; run; %end; %mend _loop; %_loop();
Thanks for your suggestions!
That's a good line of thought, implementing it would be even simpler than what you tried:
out=_%scan(&list_of_names, &I)
Hi, yes, here I am posting a picture of the error returned:
I assume its problem is a string dsn starting with int..looks like I will have to rename it in some way, otherwise there is some other option...?
This also did not work:
out='_'||%scan(&list_of_names, &i)
That's a good line of thought, implementing it would be even simpler than what you tried:
out=_%scan(&list_of_names, &I)
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.