topic Re: Need Date formatting code while exporting in SAS Programming

Need Date formatting code while exporting

Sandeepkumar — Sat, 04 Jul 2015 06:41:39 GMT

Hi All,

I am working on the number of ticket bookings of a flight.I have the different number of bookings in one day at different time points and I have written the below code.

proc sql;

create table new as

select date,sum(TOTAL_BOOKINGS_IN_CABIN) as neww from boo

group by date;

quit;

When I export this dataset called "new", then I am not getting the date column as in the date format (mm/dd/yyyy).It is giving as

date

41235

41236

.........

and so on.

I want the date as:

date

04/04/2014

02/05/2014

...... and so on.

Can someone pls help me on this?

Thanks in advance.

Sandeep

Re: Need Date formatting code while exporting

mingfeng07 — Sat, 04 Jul 2015 08:24:33 GMT

data _null_;

a=41235;

put a mmddyys10.;

run;

Re: Need Date formatting code while exporting

LinusH — Sat, 04 Jul 2015 10:33:12 GMT

How do you export?

Re: Need Date formatting code while exporting

Ksharp — Sat, 04 Jul 2015 10:53:45 GMT

Does your date have a format ?

proc sql;

create table new as

select date format=mmddyy10. ,sum(TOTAL_BOOKINGS_IN_CABIN) as neww from boo

group by date;

quit;

Re: Need Date formatting code while exporting

Sandeepkumar — Sat, 04 Jul 2015 11:50:05 GMT

Hi friend,

Thanks for the reply.

Yes,the date has the format of : 04/04/2014......

I tried your code but it didn't work.I was exporting through the menu driven option(manually).

Please let me know if i miss something.

Re: Need Date formatting code while exporting

Sandeepkumar — Sat, 04 Jul 2015 11:52:48 GMT

Hi Madam,

Thanks for the reply.I did not understand your code.The date has the format of : 04/04/2014...but when I export ,date format is different.

If I assign a=41235, then it's difficult to assign for all the values,right? Can you please elaborate your code?

Thank you,

Sandeep

Re: Need Date formatting code while exporting

Ksharp — Sat, 04 Jul 2015 12:06:31 GMT

Export it to what ? CSV ,EXCEL ?

Re: Need Date formatting code while exporting

Ksharp — Sat, 04 Jul 2015 12:22:20 GMT

If it didn't work out.

Try to change date into character type variable :

Does your date have a format ?

proc sql;

create table new as

select '09'x||put(date,mmddyy10. -l) as d ,sum(TOTAL_BOOKINGS_IN_CABIN) as neww from boo

group by date;

quit;

Re: Need Date formatting code while exporting

mingfeng07 — Sat, 04 Jul 2015 12:35:41 GMT

First, I am sorry to tell you that I'm a Sir, and then I 'm wonder that where do you want to export? I can give you a example as follows:

data a;

a=1;

format a mmddyys10.;

run;

proc export outfile="C:\Users\Pactera\Desktop\test.txt" dbms=tab replace;

run;

And the results is as following:

So, you can see that the results' format is what you want.