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.
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.
Ready to level-up your skills? Choose your own adventure.