topic Re: Date Format in SAS Procedures

Date Format

R_Win — Wed, 11 Feb 2009 08:57:19 GMT

HI i have a date it is in 20050110 in the form of year month and date now i want it to be in 10/01/2005 how can i do it

Re: Date Format

venkatesh — Wed, 11 Feb 2009 09:41:08 GMT

Hi user,

data test;
input date yymmdd8.;
cards;
20050110
;
proc print;
format date ddmmyy10.;
run;

Venkatesh.

Re: Date Format

LinusH — Wed, 11 Feb 2009 10:11:43 GMT

Is this data stored as a SAS date value, with a column format on it, a numerical column with value 20050110 or a char value?

If it's the first case, just change/use another date format: ddmmyy10.

If it's the other situations, you need to convert the columns to SAS date values first, by using INPUT/PUT functions. Read on-line doc, forum posts, papers etc on support.sas.com for examples.

/Linus