topic Show missing values in datastep in SAS Programming

Show missing values in datastep

Q1983 — Mon, 13 Nov 2017 00:32:10 GMT

data test(keep=State Amount);

set test2;

run;

Output example
State Amount

AR 150
CA 7

Presently if a State has no entries, the code skips to the next variable
I want the results to handle missing values and place a zero in amount
AL 0 (so I want to show a 0 for AL even though there were no amounts for AL)
AR 150

CA 7

Re: Show missing values in datastep

Reeza — Mon, 13 Nov 2017 00:37:27 GMT

Presently if a State has no entries, the code skips to the next variable

Currently your code does nothing....I'm not sure what you need help with here.

Re: Show missing values in datastep

Shmuel — Mon, 13 Nov 2017 00:39:23 GMT

It seems that your input does not have the AL state.

If you have a dataset with all states merge it with your test dataset before printing the output;