topic Re: Formats in SAS Programming

Formats

Nikhil_1393 — Tue, 01 May 2018 06:40:22 GMT

DATA BIRTHDATES;
INPUT ID $ 1-5 GENDER $ 6 MARRIED 7 BDATE 8-16 ;
FORMAT BDATE WORDDATE18.;
DATALINES;
00001M112JAN1999
00021F003MAR1989
00043F018JUL1991
00054M022DEC1998
00132F110JUL1992
;
Title "FRIEND'S BIRTHDATES";
PROC PRINT DATA=BIRTHDATES;
RUN;

In this example my output is showing the BDATE column as blank despite specifying the DATE format for the same.Please help me out....!

Re: Formats

PeterClemmensen — Tue, 01 May 2018 06:42:36 GMT

Use the date9 informat on BDATE to tell SAS how to read it

data birthdates;
input id $ 1-5 gender $ 6 married 7 bdate:date9.;
format bdate worddate18.;
datalines;
00001m112jan1999
00021f003mar1989
00043f018jul1991
00054m022dec1998
00132f110jul1992
;

title "friend's birthdates";
proc print data=birthdates;
run;

Re: Formats

PeterClemmensen — Tue, 01 May 2018 06:43:19 GMT

Also, it is good practice to have some delimiter between your data values.

Makes it much easier to work with 🙂

Re: Formats

Nikhil_1393 — Tue, 01 May 2018 10:13:21 GMT

Thanks very much for your help.....!

Re: Formats

euro_andres — Tue, 01 May 2018 16:04:39 GMT

Hello My friend,

As everyone said you need to use an informat. Keep in mind that formats is the way information is shown in an output while INformat is the way information is read from an external source.

Hope this helps.