topic missing value in SAS Programming

missing value

Ronein — Tue, 23 Oct 2018 05:01:20 GMT

Hello

I want to ask please about a missing value in a char var.

In this example there is a missing value in a char var.

Why should we use point (.) symbol and not a blank to represent a missing value?

data tbl;
   length name $ 12;
   input name $ score1 score2;
   datalines;
Riley 1132 1187
Henderson 1015 1102
.    1018  1027
;
Run;

Re: missing value

Kurt_Bremser — Tue, 23 Oct 2018 05:33:50 GMT

Run it with a blank instead of the dot and look at the log.

Re: missing value

singhsahab — Tue, 23 Oct 2018 05:38:56 GMT

Hello,

In your case, you can use a blank to represent a missing value for character variable .

For you example , in place of .(dot) if you want to place a space (blank) you can use DSD and DLM options with infile statement.

data tbl;
   length name $ 12;
   infile datalines dsd dlm='';
   input name $ score1 score2;
   datalines;
Riley 1132 1187
Henderson 1015 1102
 1018 1027
;
Run;