Here is my coding. I am expecting s value of var x and missing value of y in the report. When I run the below codiing , I get value 'a' of x but the value 's' of x. can you please let me if there any options that I can put to get this value in my proc report. I am using SAS 9.2 in Windows XP
input @1 x $1. @2 y $1. @3 z 1.;
proc report data=temp nowd;
column x y z;
define x / order;
define y / order;
define z / analysis;
It seems that you are confusing the SAS System Option MISSING with a different option. Your syntax should be showing you an ERROR message in the SAS log:
2944 options missing;
ERROR 26-12: Expect an equal sign and value to follow SAS option MISSING.
What SAS means by the error message is that the correct syntax for the option is: OPTIONS MISSING=' ';
which would replace the normal . (period) for missing numeric values with a blank or space character.
To have PROC REPORT reveal the missing values of GROUP or ORDER variables, you can use the MISSING option either on the PROC REPORT statement or the DEFINE statement:
proc report data=.... nowd missing;
define varname / ORDER missing;
The PROC REPORT MISSING option is working with missing GROUP or ORDER variables -- not missing numeric variable values, such as those used for summarizing (which would be affected by the system option).