Solved: Changing Date format - SAS Support Communities

🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.

Obsidian | Level 7

Obsidian | Level 7

Changing Date format

Posted 06-25-2012 06:39 AM (1142 views)

Hi,

I have date my dataset as 20120625 which is numeric field. Now i want to change it into date9 format. How can i achieve this?

1 ACCEPTED SOLUTION

Accepted Solutions

Pyrite | Level 9

Pyrite | Level 9

Re: Changing Date format

Posted 06-25-2012 06:59 AM (1249 views) | In reply to manojinpec

Hi,

Try this..

data have;

x=20120625;

y=input(put(x,z8.),yymmdd8.);

format y date9.;

run;

Thanks,

Shiva

View solution in original post

3 REPLIES 3

Pyrite | Level 9

Pyrite | Level 9

Re: Changing Date format

Posted 06-25-2012 06:59 AM (1250 views) | In reply to manojinpec

Hi,

Try this..

data have;

x=20120625;

y=input(put(x,z8.),yymmdd8.);

format y date9.;

run;

Thanks,

Shiva

Obsidian | Level 7

Obsidian | Level 7

Re: Changing Date format

Posted 06-25-2012 07:16 AM (1072 views) | In reply to shivas

Thanks Shivas

Calcite | Level 5

Calcite | Level 5

Re: Changing Date format

Posted 07-09-2012 11:44 AM (1072 views) | In reply to shivas

Siva can i have your email id plz