Char to num for DATE

Babloo — Fri, 21 Sep 2018 08:03:58 GMT

I've created the macro variable and it resolves as follows.

SYMBOLGEN:  Macro variable REPORTING_DATE resolves to 30JUN2018
reporting_date           = 30JUN2018

Since the macro variable 'reporting_date' is character, I need to convert it to numeric to do comparison with other date variable.

Could someone please guide me?

Re: Char to num for DATE

RW9 — Fri, 21 Sep 2018 08:09:50 GMT

It can be done several ways, but most direct from what you have is:

%let reporting_date=30JUN2018;

data want;
  set have;
  where date <= "&reporting_date."d;
run;

You will note here that the text from the macro variable gets put into the quotes, which have a d after - which means for SAS to treat that text as a date literal. You could also say:

data want;
  set have;
  where date <= input("&reporting_date.",date9.);
run;

Which may be useful if you have formats of date other then date9. - as only date9 works with date literals.

topic Char to num for DATE in SAS Programming

Char to num for DATE

Re: Char to num for DATE