Hello:
I would like to only PROC REPORT the non-missing value. But it didn't work when I remove the missing option below. How to fix it?
proc report data=test list headline headskip missing;
column Class name component product;
define Class /group width=150 left;
define name /group width=150 left;
define component /group width=150 left;
define product /group width=150 left;
run;
Add a WHERE statement to filter out what you want to exclude.
@ybz12003 wrote:
Hello:
I would like to only PROC REPORT the non-missing value. But it didn't work when I remove the missing option below. How to fix it?
proc report data=test list headline headskip missing; column Class name component product; define Class /group width=150 left; define name /group width=150 left; define component /group width=150 left; define product /group width=150 left; run;
Sorry, i don't work for the NSA and can't look into your computer to see the data you used, and i - shame on me - even can't read your mind, so i don't have any idea what you expected to get from running proc report.
proc report data=test list headline headskip missing;
column Class name component product;
define Class /group width=150 left;
define name /group width=150 left;
define component /group width=150 left;
define product /group width=150 left;
run;
It would be annoying if I have to put where state in each define column cause every time I would like to change different variable names.
@ybz12003 wrote:
It would be annoying if I have to put where state in each define column cause every time I would like to change different variable names.
Cleaning up the data before reporting is a pretty standard step and there are multiple ways to specify that you want all variables of a type to have non missing. Those approaches should be within your current skill set.
You also haven't really shown what you want or have so we're going off your code so far, general questions get general answers. The drill hasn't changed 🙂
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.