cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
BookmarkSubscribeRSS Feed
anilgvdbm
Quartz | Level 8 anilgvdbm
Quartz | Level 8

Regarding date format

Posted 01-28-2014 12:27 AM (1779 views)

Dear All,

here is the problem regarding date format. the date variable is in character format and some values are in numbers and some values are in date format.

so how do i convert all in to one format.

i attached the data for your reference.

Date of Interview

30/06/1990

30/06/1990

30/06/1990

30/06/1990

30/06/1990

30/06/1990

30/06/1990

30/06/1990

9/1/1990

9/1/1990

9/1/1990

9/1/1990

9/1/1990

9/1/1990

9/1/1990

9/1/1990

9/1/1990

9/1/1990

30/06/1990

30/06/1990

30/06/1990

8/1/1990

8/1/1990

8/1/1990

8/1/1990

8/1/1990

30/06/1990

30/06/1990

30/06/1990

11/1/1990

11/1/1990

11/1/1990

11/1/1990

11/1/1990

11/1/1990

11/1/1990

11/1/1990

11/1/1990

11/1/1990

11/1/1990

11/1/1990

11/1/1990

30/06/1990

30/06/1990

30/06/1990

10/1/1990

10/1/1990

10/1/1990

10/1/1990

10/1/1990

10/1/1990

30/06/1990

30/06/1990

9/1/1990

9/1/1990

9/1/1990

9/1/1990

9/1/1990

30/06/1990

30/06/1990

30/06/1990

11/1/1990

11/1/1990

11/1/1990

11/1/1990

10/1/1990

10/1/1990

10/1/1990

10/1/1990

10/1/1990

10/1/1990

10/1/1990

10/1/1990

30/06/1990

30/06/1990

30/06/1990

11/1/1990

11/1/1990

11/1/1990

11/1/1990

30/06/1990

30/06/1990

30/06/1990

11/1/1990

11/1/1990

11/1/1990

11/1/1990

11/1/1990

30/06/1990

30/06/1990

30/06/1990

30/06/1990

12/1/1990

12/1/1990

12/1/1990

12/1/1990

12/1/1990

12/1/1990

12/1/1990

30/06/1990

30/06/1990

8/1/1990

8/1/1990

8/1/1990

8/1/1990

8/1/1990

8/1/1990

8/1/1990

8/1/1990

8/1/1990

8/1/1990

30/06/1990

30/06/1990

30/06/1990

30/06/1990

10/1/1990

10/1/1990

10/1/1990

10/1/1990

10/1/1990

10/1/1990

30/06/1990

30/06/1990

10/1/1990

10/1/1990

10/1/1990

10/1/1990

10/1/1990

10/1/1990

30/06/1990

30/06/1990

30/06/1990

30/06/1990

11/1/1990

11/1/1990

11/1/1990

11/1/1990

11/1/1990

11/1/1990

11/1/1990

10/1/1990

10/1/1990

10/1/1990

10/1/1990

10/1/1990

10/1/1990

30/06/1990

30/06/1990

30/06/1990

30/06/1990

30/06/1990

8/1/1990

28/03/1990

9/1/1990

9/1/1990

9/1/1990

9/1/1990

9/1/1990

30/06/1990

30/06/1990

10/1/1990

10/1/1990

10/1/1990

10/1/1990

30/06/1990

30/06/1990

30/06/1990

30/06/1990

8/1/1990

8/1/1990

8/1/1990

8/1/1990

8/1/1990

8/1/1990

8/1/1990

30/06/1990

30/06/1990

30/06/1990

10/1/1990

10/1/1990

10/1/1990

10/1/1990

30/06/1990

30/06/1990

12/1/1990

30/06/1990

30/06/1990

30/06/1990

30/06/1990

30/06/1990

12/1/1990

12/1/1990

12/1/1990

12/1/1990

12/1/1990

12/1/1990

12/1/1990

12/1/1990

12/1/1990

30/06/1990

30/06/1990

30/06/1990

8/1/1990

8/1/1990

8/1/1990

8/1/1990

8/1/1990

8/1/1990

8/1/1990

8/1/1990

8/1/1990

30/06/1990

11/1/1990

11/1/1990

11/1/1990

11/1/1990

11/1/1990

30/06/1990

30/06/1990

30/06/1990

8/1/1990

8/1/1990

30/06/1990

30/06/1990

30/06/1990

11/1/1990

11/1/1990

11/1/1990

11/1/1990

11/1/1990

11/1/1990

11/1/1990

30/06/1990

30/06/1990

10/1/1990

10/1/1990

30/06/1990

12/1/1990

12/1/1990

12/1/1990

12/1/1990

12/1/1990

12/1/1990

12/1/1990

30/06/1990

30/06/1990

12/1/1990

12/1/1990

12/1/1990

12/1/1990

12/1/1990

30/06/1990

10/1/1990

10/1/1990

10/1/1990

10/1/1990

10/1/1990

10/1/1990

10/1/1990

30/06/1990

30/06/1990

8/1/1990

8/1/1990

8/1/1990

8/1/1990

8/1/1990

30/06/1990

30/06/1990

30/06/1990

30/06/1990

10/1/1990

10/1/1990

10/1/1990

10/1/1990

10/1/1990

10/1/1990

10/1/1990

30/06/1990

30/06/1990

30/06/1990

30/06/1990

1/7/1990

11/1/1990

11/1/1990

11/1/1990

11/1/1990

11/1/1990

30/06/1990

30/06/1990

30/06/1990

30/06/1990

12/1/1990

12/1/1990

12/1/1990

12/1/1990

12/1/1990

12/1/1990

30/06/1990

30/06/1990

0 Likes
Reply
3 REPLIES 3
LinusH
Tourmaline | Level 20 LinusH
Tourmaline | Level 20

Re: Regarding date format

Posted 01-28-2014 03:48 AM (1540 views)  |   In reply to anilgvdbm

Can't see the problem in your attached dates, they are all in date format. So just input them...?

Data never sleeps
0 Likes
Reply
Imroze
Fluorite | Level 6 Imroze
Fluorite | Level 6

Re: Regarding date format

Posted 01-28-2014 04:18 AM (1540 views)  |   In reply to anilgvdbm

Hope the below code works..

data _null_;
  set date;
  new_date=input(date,yymmdd10.);
  if not missing(new_date) then
    final_date=new_date;
  else
    final_date=date;

  put final_date=;
run;

0 Likes
Reply
pradeepalankar
Obsidian | Level 7 pradeepalankar
Obsidian | Level 7

Re: Regarding date format

Posted 01-28-2014 06:01 AM (1540 views)  |   In reply to anilgvdbm

data test;

input date_of_interview :$10.;

format final_date_of_interview date9.;

final_date_of_interview=input(date_of_interview,ddmmyy10.);

cards;

30/06/1990

30/06/1990

30/06/1990

30/06/1990

30/06/1990

30/06/1990

30/06/1990

30/06/1990

9/1/1990

9/1/1990

9/1/1990

9/1/1990

9/1/1990

9/1/1990

9/1/1990

9/1/1990

9/1/1990

9/1/1990

;

run;

0 Likes
Reply

sasinnovate.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

Call for Content EXTENDED

Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.

Submit your proposal!

How to choose a machine learning algorithm

Use this tutorial as a handy guide to weigh the pros and cons of these commonly used machine learning algorithms.

Watch How to choose a machine learning algorithm on YouTube

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • ‎01-28-2014 12:27 AM
  • 1780 views
  • 0 likes
  • 4 in conversation