DATA Step, Macro, Functions and more

comparison of dates

Accepted Solution Solved
Reply
Contributor
Posts: 27
Accepted Solution

comparison of dates

data _null_;

call symputx('td','01May2017'd);

call symputx('td1','03May2017'd);

call symputx('td2','15May2017'd);

call symputx('td3','10May2017'd);

run;

%put &td. &td1. &td2.;

 

%macro test;

%if &td1. <= &td. <= &td2. %then %do;

proc print data=sashelp.air;

run;

%end;

%else %do;

proc print data=sashelp.cars; run;

%end;

%mend test;

%test;

 

In this example, td is not between td1 and td2. Sashelp.air is printed as output. What is the explanation for this?

 

Thank you.


Accepted Solutions
Solution
‎05-08-2017 03:59 PM
Super User
Posts: 5,516

Re: comparison of dates

A set of comparisons works differently in macro language:

 

%if &td1. <= &td. <= &td2. %then %do;

 

In macro language, these function as if you had added parentheses:

 

%if (&td1. <= &td.) <= &td2. %then %do;

 

The first comparison returns a 1 (if true) or a 0 (if false).  You need to spell them out separately:

 

%if &td1. <= &td. and &td. <= &td2. %then %do;

View solution in original post


All Replies
Solution
‎05-08-2017 03:59 PM
Super User
Posts: 5,516

Re: comparison of dates

A set of comparisons works differently in macro language:

 

%if &td1. <= &td. <= &td2. %then %do;

 

In macro language, these function as if you had added parentheses:

 

%if (&td1. <= &td.) <= &td2. %then %do;

 

The first comparison returns a 1 (if true) or a 0 (if false).  You need to spell them out separately:

 

%if &td1. <= &td. and &td. <= &td2. %then %do;

☑ This topic is solved.

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

Discussion stats
  • 1 reply
  • 166 views
  • 1 like
  • 2 in conversation