How do I build a frequency table without including missing values as a category in the TABLES statement? I thought SAS doesn't include missing values as a category by default, but when I run the code below, that doesn't seem to be the case (missing values in 'ethnicity' are interpreted as a category in my output data set 'eth').
proc freq data=dt noprint ;
by firm year;
tables ethnicity / out=eth ;
run;
Sample output:
firm year ethnicity percent
1 1990 . 50
1 1990 caucasian 50
When ethnicity='
.'
this is not a missing value for a character variable. It has a value of one character, which is a period.
If you want a character variable to have a missing value, it must be a single space, such as in this code:
ethnicity=' ';
When ethnicity='
.'
this is not a missing value for a character variable. It has a value of one character, which is a period.
If you want a character variable to have a missing value, it must be a single space, such as in this code:
ethnicity=' ';
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.