CODEWITHSUNDEEP
sassas-macro
Moon
Moon

Reputation: 20022

Convert SAS numeric dates to datetime format

I am trying to convert a numeric date into date-time format. I am first subtracting a few days from the date I have.

$let from_date = "21JUL2016:00:00:00"dt;

data _null_;
    datediff = intnx('dtday',&from_dt,-180);
    call symput("cutoff_dt",datediff);
run;

After this I get numeric date like 17633333 which is fine because I am using this numeric date in pass through queries. But I also need to convert this date into datetime format like "21Dec2015:00:00:00"dt so that I can use this date in proc sql as well. So far after searching through sas documents and blogs I have been unable to do this. Help please.

Upvotes: 1

Views: 2066

Answers (2)

monei011
monei011

Reputation: 46

SAS stores dates times and datetime values as numbers. Just like in a datastep where you can write "where x='19feb2016'd" or "where x=20503" which is the number that SAS stores for the date=19feb2016, you can do the same in proc sql.

You only need to write the date value out as a character value if the variable you are comparing to contains the date as a character string. that is y has the value "19feb2016" and x has the value 20503, the test if y=x will not achieve what you want. That is when you have to write if y=put(x,date9.);

Upvotes: 0

Reeza
Reeza

Reputation: 21294

You can use PUT to apply the format, but if you need quotes and the dt then that's a different story. If you do need them, I think that the current macro variable would work as well. Otherwise you have some other issue going on. There is no requirement for SQL to require the formatted value, unless you need a character or you're passing it through to a DB. In those cases the dt won't be required either.

%let from_date = "21JUL2016:00:00:00"dt;

data _null_;
datediff = intnx('dtday',&from_dt,-180);
call symput("cutoff_dt", put(datediff, datetime21.));
run;

Upvotes: 2

Related Questions