topic Date / Time Formatting Issue in SAS Programming

Date / Time Formatting Issue

sas_td2016 — Sun, 28 May 2017 16:30:56 GMT

Hello Friends

I have the following programe. Can you please help me whether is there any issue with this code?

DATA test5;
INFORMAT LASTNAME $20. DOB MMDDYY8. GENDER $1.;
INPUT ID LASTNAME $12. DOB mmddyy8. HEIGHT 2. WEIGHT 3. GENDER $1. AGE 2.;
FORMAT DOB MMDDYY8.;
DATALINES;
1 SMITH 1/23/66 68 144 M 26
2 JONES 3/14/60 78 202 M 32
3 DOE 11/26/47 62 99 F 45
4 WASHINGTON 8/1/70 66 101 F 22
Run;

PROC PRINT;
TITLE 'Example 3.1';
RUN;

Thanks in advance.

Re: Date / Time Formatting Issue

kiranv_ — Sun, 28 May 2017 16:57:23 GMT

something like this should work. plesse look into this link which will help you understand . http://support.sas.com/documentation/cdl/en/lrcon/62955/HTML/default/viewer.htm#a003209907.htm

DATA test5;

informat lastname $12.;

INPUT ID LASTNAME $ DOB: mmddyy8. HEIGHT WEIGHT GENDER $ AGE ;

FORMAT DOB MMDDYY8.;

DATALINES;

1 SMITH 1/23/66 68 144 M 26

2 JONES 3/14/60 78 202 M 32

3 DOE 11/26/47 62 99 F 45

4 WASHINGTON 8/1/70 66 101 F 22

Run;

PROC PRINT;

TITLE 'Example 3.1';

RUN;

Re: Date / Time Formatting Issue

sas_td2016 — Sun, 28 May 2017 17:30:01 GMT

Thanks a lot. Highly appreciated. This works.

I will check out the link you provided for more info.