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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.