DATA Step, Macro, Functions and more

Date / Time Formatting Issue

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 17
Accepted Solution

Date / Time Formatting Issue

[ Edited ]

Hello Friends

I have issue in executing this program.  Can you please guide me on this?  Is there problem with this code?

Your help is highly appreciated.

data dates;
input @1 subject @4 date_of_birth mmddyy8. @12 visit_date date9.;@12 visit_date date9.;
datalines;
0011021195011Nov2006
0020802196212Dec2010
0030125195502Jan2011
;
run;
proc print;
format date_of_birth date9.
visit_date mmddyy10.;
run;


Accepted Solutions
Solution
‎09-24-2016 10:52 PM
Occasional Contributor
Posts: 17

Re: Date / Time Formatting Issue

Thanks.  It is working.

View solution in original post


All Replies
Super User
Posts: 9,671

Re: Date / Time Formatting Issue


data dates;
input  subject $3.   date_of_birth mmddyy8.  visit_date date9.;
format visit_date date9. date_of_birth mmddyy10.;
datalines;
0011021195011Nov2006
0020802196212Dec2010
0030125195502Jan2011
;
run;
proc print;run;

Solution
‎09-24-2016 10:52 PM
Occasional Contributor
Posts: 17

Re: Date / Time Formatting Issue

Thanks.  It is working.

Super User
Posts: 17,776

Re: Date / Time Formatting Issue

@sas_td2016 When marking a correct answer please mark the answer that helped you, NOT your own response. 

Super User
Posts: 5,079

Re: Date / Time Formatting Issue

[ Edited ]

The source of the problem is (as was indicated) reading in SUBJECT.  Your program tells SAS to start at column 1, but doesn't tell it where to finish.  As a result, SAS keeps reading until it either hits a blank or hits the end of the line,.

Occasional Contributor
Posts: 17

Re: Date / Time Formatting Issue

thanks for your input.  So here we need not to use column input, right?

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 5 replies
  • 391 views
  • 0 likes
  • 4 in conversation