Date Format

[R_Win]

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

[venkatesh]

Hi user,

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

Venkatesh.

[LinusH]

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