topic Why am getting blank values while inputting Date column in SAS Programming

Why am getting blank values while inputting Date column

SASCODERS — Mon, 11 Apr 2022 17:51:44 GMT

DATA df1;
Informat  dob DDMMYY10.  Date_ DATE9.;
Input @32dob DDMMYY10. @55Date_ DATE9.;
Format dob DDMMYY10. Date_ DATE9.;
DATALINES;
 05/06/1990  23Dec2000
 05/11/1991  20NOV2020
;
run;

I am new SAS programming. I would like to create data with dob and date column by using above code am Am getting output like below

dob Date_

. .

Please, help me where am gone wrong.

Re: Why am getting blank values while inputting Date column

PaigeMiller — Mon, 11 Apr 2022 18:08:53 GMT

When you use @32 and @55 in an INPUT statement, it tells SAS to read starting in column 32 and starting in column 55, and there is nothing in there.

This should work.

DATA df1;
Input dob :DDMMYY10. Date_ :DATE9.;
Format dob DDMMYY10. Date_ DATE9.;
DATALINES;
 05/06/1990  23Dec2000
 05/11/1991  20NOV2020
;
run;

Re: Why am getting blank values while inputting Date column

SASCODERS — Mon, 11 Apr 2022 18:14:01 GMT

is @32 ,@55 means we are telling SAS that column position?

Re: Why am getting blank values while inputting Date column

ballardw — Mon, 11 Apr 2022 19:46:00 GMT

@SASCODERS wrote:

is @32 ,@55 means we are telling SAS that column position?

Yes. With input the @ moves the input pointer to that character position on the line of text to be read. Then your next "instruction" such as reading a variable occurs depending to the actual line

Similar, an #n reads "on line number n" if the Infile has been set up to read multiple lines correctly.

Re: Why am getting blank values while inputting Date column

SASCODERS — Mon, 11 Apr 2022 19:53:27 GMT

Thank you for explaining.