topic Re: Can someone tell me what this all means? in SAS Procedures

Can someone tell me what this all means?

SASHunter — Tue, 01 Jun 2010 20:05:20 GMT

I have the following macro that I was looking at, but need more explanations of what one part is made up of :

/* Loops through the directory */
%do i = 1 %to &memcnt;

%let fname=%qscan(%qsysfunc(dread(&did,&i)),1,.);
%let testname=%substr(&fname,1,4);

%if &testname = capi or &testname = cati %then %do;

* delete the file;
proc datasets library=lhost;
delete &fname.;
run;
quit;
%end;
%end;

The one I need more info on is the %qscan statement. I don't know what the number one is for or the (.).

Thanks,
Nancy

Re: Can someone tell me what this all means?

Cynthia_sas — Tue, 01 Jun 2010 20:44:50 GMT

Hi:
From the doc:
http://support.sas.com/documentation/cdl/en/mcrolref/61885/HTML/default/viewer.htm#/documentation/cdl/en/mcrolref/61885/HTML/default/z3514scan.htm

%QSCAN(argument, n<,charlist <,modifiers>>)

by that documentation, then your %QSCAN breaks down as:

%QSCAN(
argument is %qsysfunc(dread(&did,&i))
n is 1
charlist is .
there are no modifiers to the %QSCAN

You can look up what N is in the documentation for %QSCAN. Basically, &FNAME will be set to the first chunk of whatever is returned by %QSYSFUNC invocation of the DREAD function delimited by the . (or period).

cynthia

Re: Can someone tell me what this all means?

SASHunter — Wed, 02 Jun 2010 13:46:37 GMT

Thanks for explaining that.
It helped.

Nancy