Help using Base SAS procedures

Find no of missing observations for character

Reply
Regular Contributor
Posts: 229

Find no of missing observations for character

Hi i ave a data set

data lo;
input id $ sal $ ;
cards;
dfgh
dfgh dsfhdsf
dfgh urkrkrj
fjhjh
run;

Now i want the no of observations missing in that variables and no of non missing observations
N/A
Posts: 0

Re: Find no of missing observations for character

You'll need to add an infile with a missover option so that SAS will not simply skip the blank value for the second varibale and go to the next line, as it will by defualt.

Then simply add a couple counters (you would normally need to use a retain to carry the values of the counters from one iteration to the next but this syntax will retain automatically).

data lo;
infile cards missover;
input id $ sal $ ;
if id='' or sal='' then no_of_missing+1;
else no_of_non_missing+1;
cards;
dfgh
dfgh dsfhdsf
dfgh urkrkrj
fjhjh
run;
Ask a Question
Discussion stats
  • 1 reply
  • 100 views
  • 0 likes
  • 2 in conversation