DATA Step, Macro, Functions and more

Show missing values in datastep

Reply
Regular Contributor
Posts: 178

Show missing values in datastep

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

Super User
Posts: 22,846

Re: Show missing values in datastep

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.

Trusted Advisor
Posts: 1,826

Re: Show missing values in datastep

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;

Ask a Question
Discussion stats
  • 2 replies
  • 124 views
  • 0 likes
  • 3 in conversation