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.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.
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.