topic Re: Date format change in SAS Programming

Date format change

PujaDas — Thu, 13 Apr 2017 19:20:58 GMT

Hi Team,
I am new in sas programming. Can anyone help me to build the logic of the below.
Here the date is assigned as a char And we are getting output in pdf as for example 03/03/2017. Now the requirement is to change the ouput date look to 03-MAR-17.
Please help me out how it is possible to do.

Thsnks,
Puja

Re: Date format change

Reeza — Thu, 13 Apr 2017 19:28:49 GMT

You need to show how you're using the date and we can then show you how to change the format.

Re: Date format change

art297 — Thu, 13 Apr 2017 19:31:30 GMT

1. Converting a character date to a SAS date: SASDateVariableName=input(yourdatevariable, anydtdte.);

2. Assign the desired format: format ASDateVariableName mmddyyD10.;

Other variants of that format can be found at: http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000590662.htm

Art, CEO, AnalystFinder.com

Re: Date format change

Astounding — Thu, 13 Apr 2017 19:48:29 GMT

Well, I would never show you have to get a date with a two-digit year. I hope this is close enough:

data want;

length mydate $ 11;

set have;

mydate = put(input(mydate, mmddyy10.), date11.);

run;

That's assuming that 03/03/2017 is actually in MMDDYY form, rather than DDMMYY form.