topic Re: Converting a SAS Date into a DatePart in SAS Programming

Converting a SAS Date into a DatePart

wlierman — Wed, 14 Oct 2020 23:10:30 GMT

This is a pretty basic question that nonetheless keeps tripping me up.

I have a datetimevariable. I extract the datepart and it is returned as a SAS date form.

I want a a DatePart form like dd/mm/yy. Here is the code

Data SASCDC_2.Arias_Median_Days_Monitoring;
   Set SASCDC_2.Arias_Median_Days_Monitoring;
   C_Date=DatePart(Created_On);
   Create = ??? (C_Date);
   rename Create = Create_date;
run;

I put the ? marks in there.

So I have the following output

Created_on C_date

26JUN20:09:40:24 22092

So I want Create (in code) to contain the DatePart representation of C_date

like 26JUN20 and so on for the rest.

Thank you for your help.

wlierman

Re: Converting a SAS Date into a DatePart

Reeza — Wed, 14 Oct 2020 23:16:09 GMT

You've done it correctly but have not formatted it. Computer applications often store dates as the number of days from a reference point so 22092 is the number of days from January 1, 1960. To have it show as a date you apply a format.

FYI I strongly recommend against coding so that your input data set has the same name as the output data set (DATA/SET statements). This makes it hard to debug your code and is not a good practice.

Data SASCDC_2.Arias_Median_Days_Monitoring2;
   Set SASCDC_2.Arias_Median_Days_Monitoring;

   C_Date=DatePart(Created_On);
   format c_date ddmmyyd10.;

run;

Here's a great, but longer and in depth, reference for dates and times in SAS
https://communities.sas.com/t5/SAS-Communities-Library/Working-with-Dates-and-Times-in-SAS-Tutorial/ta-p/424354

@wlierman wrote:

This is a pretty basic question that nonetheless keeps tripping me up.

I have a datetimevariable. I extract the datepart and it is returned as a SAS date form.

I want a a DatePart form like dd/mm/yy. Here is the code
Data SASCDC_2.Arias_Median_Days_Monitoring;
   Set SASCDC_2.Arias_Median_Days_Monitoring;
   C_Date=DatePart(Created_On);
   Create = ??? (C_Date);
   rename Create = Create_date;
run;
I put the ? marks in there.

So I have the following output

Created_on C_date

26JUN20:09:40:24 22092

So I want Create (in code) to contain the DatePart representation of C_date

like 26JUN20 and so on for the rest.

Thank you for your help.

wlierman

Re: Converting a SAS Date into a DatePart

wlierman — Thu, 15 Oct 2020 03:56:18 GMT

Thank you for your review and solution.

Also thank you for the coding tips as well as well as the link to Andrew Karp's article.

Thank you.

wlierman