Macros variable in date parameter

troopon — Tue, 20 Dec 2016 09:57:36 GMT

I have a macros variable for year defined by %let year = 2016;

I want to use this within a date parameter as below but I can't seem to amend my code so it works. At the moment I am getting 0 records where as if I run without the macros variable and just use 2016 instead it returns records. How can I adjust so this works?

data want;
set have;
where date = "01AUG&aat_year_ty."d;
run;

(0 records returned)

data want;
set have;
where date = '01AUG2016'd;
run;

(300 rows)

Re: Macros variable in date parameter

Patrick — Tue, 20 Dec 2016 10:01:00 GMT

What does the SAS log tell you? Any warnings?

You say your macro variable is &year but then you use a macro variable &aat_year_ty in your code. Which one is the correct name.

The following should work:

%let year = 2016;

data want;
set have;
where date = "01AUG&year"d;
run;

topic Re: Macros variable in date parameter in SAS Programming

Macros variable in date parameter

Re: Macros variable in date parameter