Hi,
What i'm trying to do is to stack 3 different datasets with the exact same structure using macros to identify the files by a timestamp for each of the datasets.
I'm unsure why i'm getting an error with the code below:
%LET CUR_MONTH=2012FEB29;
%LET PREV_MONTH=2012JAN31 ;
%LET PREV_MONTH2=2011DEC31
DATA RATED.RATEDEVENT_L3MTH_STACK_&CUR_MONTH ;
SET RATED.RATED_EVENT_&CUR_MONTH
RATED.RATED_EVENT_&PREV_MONTH
RATED.RATED_EVENT_&PREV_MONTH2;
RUN ;
ERROR: File WORK.GOPTIONS.DATA does not exist.
ERROR: File WORK.NOACCESSIBLE.DATA does not exist.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set RATED.RATEDEVENT_L3MTH_STACK_2012FEB29 may be incomplete. When this step was
stopped there were 0 observations and 10 variables.
WARNING: Data set RATED.RATEDEVENT_L3MTH_STACK_2012FEB29 was not replaced because this step was
stopped.
Thanks for your help.
Danglytics,
You're getting an error message because you're working too hard and getting bleary-eyed.
The third %LET statement is missing a semicolon.
Good luck.
How are these data sets related to the code?
WORK.GOPTIONS.DATA
WORK.NOACCESSIBLE.DATA
/* you missed a ";" */
%LET PREV_MONTH2=2011DEC31
Danglytics,
You're getting an error message because you're working too hard and getting bleary-eyed.
The third %LET statement is missing a semicolon.
Good luck.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.