topic Re: Date / Time Formatting Issue in SAS Programming

Date / Time Formatting Issue

sas_td2016 — Sun, 25 Sep 2016 01:16:24 GMT

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;

Re: Date / Time Formatting Issue

Ksharp — Sun, 25 Sep 2016 01:44:39 GMT


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;

Re: Date / Time Formatting Issue

Astounding — Sun, 25 Sep 2016 01:47:12 GMT

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,.

Re: Date / Time Formatting Issue

sas_td2016 — Sun, 25 Sep 2016 02:52:04 GMT

Thanks. It is working.

Re: Date / Time Formatting Issue

sas_td2016 — Sun, 25 Sep 2016 02:54:24 GMT

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

Re: Date / Time Formatting Issue

Reeza — Sun, 25 Sep 2016 06:07:26 GMT

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