DATA Step, Macro, Functions and more

Dynamic Where Condition With Date Values

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 5
Accepted Solution

Dynamic Where Condition With Date Values

 

I am trying to subset my dataset based on months, and I want it to loop through the months and create a different dataset for each month.

This is my code:

%macro SASPLay;

%let start = 30JUN2014;

%do i=0 %to 10;

    data _null_;

  call symputx("mth",put(intnx("MONTHS",input("&start",Date9.),&i,'SAME'),Date9.));

     run;

  %put &mth;

 

    data final_&mth;

    set mockdata;

  where DATE = '&mth'd;

run;

%end;

%mend;

 

%SASPlay;

 

It gives these error messages:

ERROR: Invalid date/time/datetime constant '&mth'd.

ERROR: Syntax error while parsing WHERE clause.

 

 

I am trying to generalise this, because when I use a hardcoded value (e.g.  where DATE = '30JUN2014'd; ) it works.

I don't know why I can't just swap out the hardcoded value for &mth, giving that &mth shows as 30JUN2014.

I also tried just using where DATE = &mth; That doesn't work either.

 

 

 

 


Accepted Solutions
Solution
‎10-13-2016 10:22 PM
Occasional Contributor
Posts: 5

Re: Dynamic Where Condition With Date Values

Ohh, looks like I got it to work with

 

where DATE = "&mth"d;

 

double quotes, not single quotes.

**bleep** this is strange.

 

View solution in original post


All Replies
Solution
‎10-13-2016 10:22 PM
Occasional Contributor
Posts: 5

Re: Dynamic Where Condition With Date Values

Ohh, looks like I got it to work with

 

where DATE = "&mth"d;

 

double quotes, not single quotes.

**bleep** this is strange.

 

Super User
Posts: 11,343

Re: Dynamic Where Condition With Date Values


random1 wrote:

Ohh, looks like I got it to work with

 

where DATE = "&mth"d;

 

double quotes, not single quotes.

**bleep** this is strange.

 


Not at all strange. The use of double quotes for macro variables to resolve is very well documented. For one thing it allows the use of literal text values containing possible macro invocations such as '%InData' or '&Sons' without the macro processor trying to handle such when you know they are not macro code or macro variables.

Respected Advisor
Posts: 4,925

Re: Dynamic Where Condition With Date Values

macro variable replacement doesn't occur within single quotes. Use double quotes instead

 

where DATE = "&mth"d;

PG
☑ This topic is solved.

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

Discussion stats
  • 3 replies
  • 283 views
  • 0 likes
  • 3 in conversation