?
Solved

How do I convert a 6 position date format to a 10 position date format?

Posted on 2011-02-21
15
Medium Priority
?
763 Views
Last Modified: 2013-11-16
Hi All,

How do I convert the following date to a MM/DD/YYYY format?

112310 to 11/23/2010

Thanks,

SASnewbie
0
Comment
Question by:SASnewbie
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 7
15 Comments
 
LVL 11

Expert Comment

by:theartfuldazzler
ID: 34945763
Hi

Assuming the date is stored as text then:

DATA _NULL_;
  Old_date = '112310';
  SAS_Date = INPUT(Old_date, mmddyy.);
  New_date = PUT(SAS_Date, mmddyy10.);
  PUT _ALL_;
RUN;

Effectively, this ocde converts a text field to a SAS date, and then makes that SAS Date into a new text field in the format mm/dd/yyyy.

0
 

Author Comment

by:SASnewbie
ID: 34945779
Hi theartfuldazzler,

Thanks for responding so quickly.

Is there a way to keep the 'Old_date" name?
0
 
LVL 11

Expert Comment

by:theartfuldazzler
ID: 34945828
Hi

DATA _NULL_;
  Old_date = '112310';
  SAS_Date = INPUT(Old_date, mmddyy.);
  Old_date = PUT(SAS_Date, mmddyy10.);
  PUT _ALL_;
DROP SAS_Date;
RUN;
0
Get proactive database performance tuning online

At Percona’s web store you can order full Percona Database Performance Audit in minutes. Find out the health of your database, and how to improve it. Pay online with a credit card. Improve your database performance now!

 
LVL 11

Expert Comment

by:theartfuldazzler
ID: 34945838
Hi

You might have an issue with the length of the Old_Date.  If you place a format statement before the SET statement, it should work.


DATA _NULL_;
format Old_Date $10.;
  Old_date = '112310';
  SAS_Date = INPUT(Old_date, mmddyy.);
  New_date = PUT(SAS_Date, mmddyy10.);
  PUT _ALL_;
RUN;
0
 

Author Comment

by:SASnewbie
ID: 34945840
Thanks,
Let me try it and be right back.
0
 

Author Comment

by:SASnewbie
ID: 34945893
Hi,

I'm not getting it... Here is the section of the log with the error message.

2652  Date = input(stat_date,mmddyy.);
2653  Stat_date = put(date, mmddyy10.);
                            ---------
                            48
ERROR 48-59: The format $MMDDYY was not found or could not be loaded.

stat_date is in the mmddyy format, is text with length $6.
0
 
LVL 11

Accepted Solution

by:
theartfuldazzler earned 2000 total points
ID: 34945923
Hi

It looks like you have previously defined the "date" variable as text as well...  The date variable must be numeric...

In the two lines you sent me - try changing to:

x_Date = input(stat_date,mmddyy.);
Stat_date = put(x_date, mmddyy10.);
0
 

Author Comment

by:SASnewbie
ID: 34945955
Okay Thanks,
I will be back in an hour...
0
 
LVL 11

Expert Comment

by:theartfuldazzler
ID: 34946040
Hi

Its 10pm on my side of the world, I will look again tomorrow first thing
0
 

Author Comment

by:SASnewbie
ID: 34969628
I was able to make the conversion:

stat2_date = input(stat_date,mmddyy6.);
format stat2_date mmddyy10.;
stat_date = put(stat2_date,mmddyy10.);

Thanks,
0
 

Author Comment

by:SASnewbie
ID: 34969668
Please cancel this request to close without assigning points
0
 
LVL 11

Expert Comment

by:theartfuldazzler
ID: 34969924
Hi

Just interested - but the answer I gave works - and is identical to your answer...  why no points?
0
 

Author Comment

by:SASnewbie
ID: 34970400
Hi theartfuldazzler,

I put in a request for the cancel so I can give you the points.

Sorry about that.
0
 
LVL 11

Expert Comment

by:theartfuldazzler
ID: 34977198
As per comment ID: 34970400, the author agrees that comment ID: 34945923 is the correct solution, and should be granted the points.
0
 

Author Comment

by:SASnewbie
ID: 34980113
Thanks again!
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question