topic Scan function causes problems in proc import in SAS Programming

Scan function causes problems in proc import

Uknown_user — Thu, 22 Feb 2018 15:33:49 GMT

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!

Re: Scan function causes problems in proc import

GinaRepole — Thu, 22 Feb 2018 15:47:39 GMT

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.

Re: Scan function causes problems in proc import

Uknown_user — Thu, 22 Feb 2018 15:51:15 GMT

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

Re: Scan function causes problems in proc import

Uknown_user — Thu, 22 Feb 2018 15:55:38 GMT

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

Re: Scan function causes problems in proc import

Uknown_user — Thu, 22 Feb 2018 15:59:00 GMT

This also did not work:

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

Re: Scan function causes problems in proc import

Astounding — Thu, 22 Feb 2018 16:02:14 GMT

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

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