DATA Step, Macro, Functions and more

what is wrong with this code?

Accepted Solution Solved
Reply
Contributor
Posts: 66
Accepted Solution

what is wrong with this code?

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.


Accepted Solutions
Solution
‎03-20-2012 01:42 PM
Super User
Posts: 5,085

what is wrong with this code?

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.

View solution in original post


All Replies
Regular Contributor
Posts: 233

what is wrong with this code?

How are these data sets related to the code?

WORK.GOPTIONS.DATA

WORK.NOACCESSIBLE.DATA

Super Contributor
Posts: 1,636

what is wrong with this code?

/* you missed a ";" */

%LET PREV_MONTH2=2011DEC31

Solution
‎03-20-2012 01:42 PM
Super User
Posts: 5,085

what is wrong with this code?

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.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 426 views
  • 3 likes
  • 4 in conversation