BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Tom
Super User Tom
Super User

This question was recently posted on stackoverflow. 

 

I am working with a dataset containing a date variable with the format MMDDYY10.. The problem is, that the day, month and the year have been swapped.

The data set as it looks now:

Obs Date
1   11/01/1931
2   11/06/1930
3   12/02/2003
4   12/07/2018

What I would like is a date variable with the format DDMMYY10., or a similar:

Obs Date
1   31/01/2011
2   30/06/2011
3   03/02/2012
4   18/07/2012

Observation 1 is hence written as the 1st of November 1931, but really it is the 31st of January 2011.

Does anyone know how I can change this?

1 ACCEPTED SOLUTION

Accepted Solutions
Tom
Super User Tom
Super User
I am typing this on cell phone. I noticed that the code formatting did display in chrome browser on my cell phone.

View solution in original post

3 REPLIES 3
Tom
Super User Tom
Super User
data have ;
  input olddate mmddyy10.;
  newdate = input(put(olddate,mmddyy6.),yymmdd6.);
  format olddate newdate yymmdd10. ;
  put (olddate newdate) (=);
cards;
11/01/1931
11/06/1930
12/02/2003
12/07/2018
;;;;
Tom
Super User Tom
Super User
I am typing this on cell phone. I noticed that the code formatting did display in chrome browser on my cell phone.
Tom
Super User Tom
Super User
It does not seem possible to edit replies on a cell phone.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 757 views
  • 0 likes
  • 1 in conversation