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 (1214 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 (1321 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 (1322 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 (1144 views) | In reply to shivas

Thanks Shivas

Calcite | Level 5

Calcite | Level 5

Re: Changing Date format

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

Siva can i have your email id plz

April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Call for Content EXTENDED

Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.

Submit your proposal!