topic null values for dates in SAS Programming

null values for dates

arde — Tue, 04 Sep 2018 16:51:45 GMT

I would like to enter blank values for dates using datalines. I keep getting errors from the program below. What placeholder do I need to enter in line Two for Scott in order to show a null for date?

data want;
length Rank $10 Name $8. Days 8. ;
input Rank $ Name $ Date date9. Days ;
format Date date9. ;
datalines;
One Joe 04Sep2018 30

Two Scott 20

Three Bob 04Sep2018 40

;
run;

Re: null values for dates

novinosrin — Tue, 04 Sep 2018 17:00:39 GMT

do you mean this?


data want;
infile datalines truncover;
length Rank $10 Name $8. Days 8. ;
input Rank $ Name $ Date :date9. Days ;
format Date date9. ;
datalines;
One Joe 04Sep2018 30
Two Scott . 20
Three Bob 04Sep2018 40
;
run;

Re: null values for dates

HB — Tue, 04 Sep 2018 17:04:20 GMT

s seems to read correctly:

data want;
	input Rank:$ Name:$ Date:date9. Days ;
	length Rank $10. Name $8. Days 8. ;
	format Date date9. ;
	datalines;
	One Joe 04Sep2018 30
	Two Scott . 20
	Three Bob 04Sep2018 40
	;
run;

Re: null values for dates

arde — Tue, 04 Sep 2018 17:10:37 GMT

oops, I had missed the colon in front of date9.

Thanks so much 🙂