BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Uknown_user
Quartz | Level 8

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Astounding
PROC Star

That's a good line of thought, implementing it would be even simpler than what you tried:

 

out=_%scan(&list_of_names, &I)

View solution in original post

5 REPLIES 5
GinaRepole
SAS Employee
Could you be a little bit more explicit about what your error is? I've run this program modified for a valid path and csv files on my PC and it works perfectly for me.
Uknown_user
Quartz | Level 8

Hi, yes, here I am posting a picture of the error returned:

 

picture.png

Uknown_user
Quartz | Level 8

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...?

Uknown_user
Quartz | Level 8

This also did not work:

 

out='_'||%scan(&list_of_names, &i)

Astounding
PROC Star

That's a good line of thought, implementing it would be even simpler than what you tried:

 

out=_%scan(&list_of_names, &I)

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 5 replies
  • 1857 views
  • 0 likes
  • 3 in conversation