topic Re: YYYYMMDD format to MMDDYYYY in ODS and Base Reporting

YYYYMMDD format to MMDDYYYY

sanjay1 — Thu, 10 Oct 2019 11:37:21 GMT

Hi Team,

In my dataset I have a date format as YYYYMMDD, but I am tryng to convert it to MMDDYYYY format.

Please suggest.

Here is the example;

Data a;

input Dat ;

cards;

20191026

run;

Requiered output:

Dat

10262019

Thanks,

Sanjay

Re: YYYYMMDD format to MMDDYYYY

Kurt_Bremser — Thu, 10 Oct 2019 11:42:58 GMT

Read into a SAS date with the proper informat, and use the proper display format:

Data a;
input Dat yymmdd8.;
format Dat mmddyyn8.;
cards;
20191026
;

Re: YYYYMMDD format to MMDDYYYY

ed_sas_member — Thu, 10 Oct 2019 11:43:40 GMT

Hi @sanjay1 ,

You need to specify an informat so that SAS correctly reads input data as dates and not numbers.

Once, it has been correctly interpret as a date, you can apply the format you want.

Hope this help!

Data a;
input Dat ;
informat Dat YYMMDD10.;
format Dat MMDDYY10.;
cards;
20191026
;
run;

Re: YYYYMMDD format to MMDDYYYY

sanjay1 — Thu, 10 Oct 2019 11:46:56 GMT

Hi,

I am not creating it manually I am pulling it form from database.

Re: YYYYMMDD format to MMDDYYYY

Kurt_Bremser — Thu, 10 Oct 2019 11:52:49 GMT

Then you need to get a clear picture of your data. Run a proc contents on the dataset to see how the variable is defined. From that you can infer the real content.

No sane database admin stores a date as a 8-digit number.

Re: YYYYMMDD format to MMDDYYYY

sanjay1 — Thu, 10 Oct 2019 11:58:19 GMT

Hi @Kurt_Bremser

I did the contents here is the result.

Variable Type Len Format Informat Label

Dat Num 8 9. 9. Dat

Re: YYYYMMDD format to MMDDYYYY

Kurt_Bremser — Thu, 10 Oct 2019 12:03:53 GMT

@sanjay1 wrote:

Hi @Kurt_Bremser

I did the contents here is the result.

Variable Type Len Format Informat Label

Dat Num 8 9. 9. Dat

OMG.

Well, in that case, you need to do a double conversion:

dat = input(put(dat,z8.),yymmdd8.);
format dat mmddyy8.;

Create a new dataset in a step where you use this, so you do not destroy your incoming data if something fails.

Re: YYYYMMDD format to MMDDYYYY

sanjay1 — Thu, 10 Oct 2019 12:27:04 GMT

Thank you @Kurt_Bremser , Its working