Hi,
Can you please show the log you get from both the working code, and non-working code? Do you intend for VAR1 and VAR2 to be macro variables?
I could not get the code you say is working to work. It's unusual to create a dataset with an & in the name. Apparently it can be done if you turn on ValidMemName=extend. But even with that, you need to use a name literal to reference the data set.
1 options validmemname=extend ;
2
3 data FullList;
4 set Items&20220101;
-
22
200
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, -, :, ;,
CUROBS, END, INDSNAME, KEY, KEYRESET, KEYS, NOBS, OPEN, POINT, _DATA_, _LAST_, _NULL_.
ERROR 200-322: The symbol is not recognized and will be ignored.
5 run;
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.FULLLIST may be incomplete. When this step was stopped there were 0
observations and 5 variables.
WARNING: Data set WORK.FULLLIST was not replaced because this step was stopped.
6
7 data FullList;
8 set "Items&20220101"n;
9 run;
NOTE: There were 1 observations read from the data set WORK.'ITEMS&20220101'n.
NOTE: The data set WORK.FULLLIST has 1 observations and 0 variables.
... View more