topic Re: How to tell sas read missing values? in SAS Programming

How to tell sas read missing values?

Barkamih — Thu, 28 Feb 2019 14:27:30 GMT

Hi all

I have got this issue when I run my code.

958,105 observations are not included because of missing values, and all observations are 1.1 million, in this case, a large number of data are not used in the analysis

So, I did this code to fix this problem but still the same, it is true the outputs are changed but the number of observation who are not used because of missing values still the same in the log

data milk;
set milk;
if  a = . then a =' ';
if  b = . then b =' ';
if  c = . then c =' ';
if  p = . then p =' ';
if  peakyield = . then peakyield =' ';
run; quit;

regards

Re: How to tell sas read missing values?

andreas_lds — Thu, 28 Feb 2019 14:39:16 GMT

"but the number of observation who are not used because of missing values still the same in the log "

Used by what? Many procedures have option, often named "missing" to include observations having missing-values.

You can not assign a string/char to a numeric variable.

EDIT: Added the missing NOT 😐

Re: How to tell sas read missing values?

Astounding — Thu, 28 Feb 2019 14:38:47 GMT

Your "fix" still leaves you with missing values. What non-missing value could you substitute? For example, would this make sense?

if a = . then a = 0;

Re: How to tell sas read missing values?

gamotte — Thu, 28 Feb 2019 14:41:04 GMT

' ' is the missing value for charcater variables while . is the missing value of numerics.

You cannot convert a numeric variable to character on the fly.

If you don't want the . to appear in reports you can use

option missing=' ';

Re: How to tell sas read missing values?

Barkamih — Thu, 28 Feb 2019 14:44:19 GMT

I'm using proc mixed !!