topic Re: Converting dates from text format in SAS Procedures

Converting dates from text format

deleted_user — Thu, 16 Oct 2008 19:23:02 GMT

In my dataset, dates are stored in text as daymonthyear, where "day" is the date in two digits, "month" is 3-letter abbreviation for the month, and "year" is the 4-digit year. I want to retain month and year in a date or numeric format to ease comparison of data across months. What is the most efficient way to do this?

Thanks!

Re: Converting dates from text format

sbb — Thu, 16 Oct 2008 19:52:11 GMT

The most effective approach within the SAS system is to assign DATE and / or DATETIME SAS (numeric) variables. So, then using these numeric variables, you can display them in various formats, while still being able to compare and calculate differences and such with the numeric SAS variable (which are stored internally as days since 1/1/1960 or seconds since 1/1/1960).

I have provided a SAS support website http://support.sas.com/ link to related DOC for your reference (mind any broken URL string):

SAS 9.2 DOC - About SAS Date, Time, and Datetime Values
http://support.sas.com/documentation/cdl/en/lrcon/59522/HTML/default/a002200738.htm

more of the same topic discussion at the link below:
http://support.sas.com/documentation/cdl/en/etsug/60372/HTML/default/etsug_intervals_sect014.htm

Scott Barry
SBBWorks, Inc.

Re: Converting dates from text format

GertNissen — Mon, 20 Oct 2008 12:21:14 GMT

data test;
dates_txt = '20oct2008';
dates_sd = input(dates_txt,date9.); put dates_sd= date.;
month = month(dates_sd);
year = year(dates_sd);
run;

Store your dates as numeric variables (ie. the result of dates_sd), then you can use all the many SAS date functions and formats.