About ydang

ydang · ‎01-17-2025

Double quotes without using symget worked. %macro basefile ( haveseq, pathname ); data have_&haveseq; rc=filename('xx',"&pathname"); did=dopen('xx'); do i=1 to dnum(did); fname=dread(did,i); output; end; rc=dclose(did); rc=filename (did); run; %mend basefile;

ydang · ‎01-17-2025

Add double quotation marks, but still getting same error. %macro basefile6 ( haveseq, pathname ); data have_&haveseq; rc=filename("xx",symget("pathname")); did=dopen("xx"); do i=1 to dnum(did); fname=dread(did,i); output; end; rc=dclose(did); rc=filename (did); run; %mend basefile6;

ydang · ‎01-17-2025

I'm now using symget. I would like to run the macro with a call execute, so I will get a list of all the files in the folder. In the end some of these files would need to be deleted. I've now created the full path in variable pathname in the dataset deletefolders, this also contains the pathname. The deletefolder dataset has multiple folders listed with haveseq as sequence number. I'm still getting the same error when using symget. %macro basefile3 ( haveseq, pathname ); data have_&haveseq; rc=filename('xx',symget('pathname')); did=dopen('xx'); do i=1 to dnum(did); fname=dread(did,i); output; end; rc=dclose(did); run; %mend basefile3; data _null_; set Deletefolders; call execute(cats('%basefile3(',haveseq||','||pathname,')')); run;

ydang · ‎01-16-2025

Hi, I would like to use a macrovariable in filename in a macro, but it gives error NOTE: Argument 1 to function DNUM(0) at line 41 column 69 is invalid. ERROR: Invalid DO loop control information, either the INITIAL or TO expression is missing or the BY expression is missing, zero, or invalid. File doesn't seem to open. pathname is created earlier as C:\Users\ydang\OneDrive - Prinses Maxima Centrum\CDM_share\Briga share\ %macro basefile2 (pathname, haveseq ); %let path=cats(strip("&studypath"),strip("&pathname")); data have1; rc=filename('xx','&path'); did=dopen('xx'); do i=1 to dnum(did); fname=dread(did,i); output; end; rc=dclose(did); run; %put path; %mend basefile2; %basefile2 (01 Source\20230609,1); It works fine if I use: rc=filename('xx',C:\Users\ydang\OneDrive - Prinses Maxima Centrum\CDM_share\Briga share\01 Source\20230609

Online Status	Offline
Date Last Visited	‎04-02-2025 10:49 AM

Re: Using macrovariable path in filename error Invalid DO loop control...

Re: Using macrovariable path in filename error Invalid DO loop control...

Re: Using macrovariable path in filename error Invalid DO loop control...

Using macrovariable path in filename error Invalid DO loop control inf...

Re: Using macrovariable path in filename error Invalid DO loop control...

Re: Using macrovariable path in filename error Invalid DO loop control...

Re: Using macrovariable path in filename error Invalid DO loop control...

Using macrovariable path in filename error Invalid DO loop control inf...

SAS Analytics Explorers