topic Re: SAS set statement in SAS Procedures

SAS set statement

Lopa2016 — Sun, 08 Jan 2017 00:22:17 GMT

I am trying to use the set statement for multiple datasets in one shot namely I have datasets vmoreranked1,vmoreranked2,vmoreranked3,...But constantly getting an error

 data stackorig;
set vmoreranked1-vmoreranked&vmcnt; run;
                  -
                  22

ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, ;, END, KEY, KEYS, NOBS, OPEN, POINT, DATA, LAST, NULL.

NOTE: The SAS System stopped processing this step because of errors.

Can someone help?

Re: SAS set statement

Reeza — Sun, 08 Jan 2017 00:34:57 GMT

What version of SAS do you have? This type of syntax is valid in SAS 9.3+

Re: SAS set statement

SASKiwi — Sun, 08 Jan 2017 01:17:45 GMT

This may be caused by &vmcnt not resolving correctly. Check by replacing this with a number like 2 just to see if it fixes the problem.

Re: SAS set statement

Astounding — Sun, 08 Jan 2017 01:46:02 GMT

My guess: &VMCNT was created by PROC SQL and thus includes leading blanks. The easiest way to overcome this is to add this statement before the DATA step:

%let vmcnt = &vmcnt;

Alternatively (depending on how much subsequent processing has taken place), you might be able to use &SQLOBS instead of &VMCNT.

Re: SAS set statement

Jagadishkatam — Sun, 08 Jan 2017 02:52:58 GMT

I agree with @Astounding, may be there are leading blank spaces in the macro variable vmcnt, so try to use %cmpres function which will remove the blank if any.

data stackorig;
set vmoreranked1-vmoreranked%cmpres(&vmcnt);
run;