topic Re: Identifying missing data values in data set in New SAS User

Identifying missing data values in data set

armoore — Thu, 16 Jul 2020 03:49:49 GMT

For the missing values in cholesterol. The code is not working for the output variable chol_status. Each time I run the code the output variable chol_status displays “Safe” instead of a blank space.

To identify missing values I thought you used: if variable-name=. then variable-name=. ; or if missing(variable-name) then variable-name=. ;

What would be the correct code for missing values for ?

data results;
	set "/home/u44696116/TheCut/input/input44.sas7bdat";
	length chol_status $ 15;
	drop bp_status weight_status smoking_status;
	if cholesterol=. then chol_status=. ;
			if cholesterol<200 then chol_status="Safe";
			else if cholesterol<=239 then chol_status="High-Borderline";
			else if cholesterol>=240 then chol_status="High";		
run;

SAS ANSWER

data out;
	set "/home/u44696116/TheCut/input/input44.sas7bdat";
	length chol_status $ 15;
	drop bp_status weight_status smoking_status;
	if cholesterol ne . then do;
	                if cholesterol < 200 then chol_status='Safe';
			else if cholesterol <=239 then chol_status='High-Borderline';
			else if cholesterol >=240 then chol_status='High';
		end;
run;

Re: Identifying missing data values in data set

Tom — Thu, 16 Jul 2020 04:18:31 GMT

If the first place you reference the variable is when you are assigning it a numeric value then the variable will defined as numeric. So define the variable BEFORE using it.

length chol_status $20;

Also you told it to set the missing value to Safe with this statement:

if cholesterol<200 then chol_status="Safe";

SAS will consider any of the 28 missing values that SAS supports as less than any valid value.

You probably meant to have another ELSE.

if missing(cholesterol) then chol_status=' ';
else if cholesterol < 200 then chol_status='Safe';
else if cholesterol <=239 then chol_status='High-Borderline';
else if cholesterol >=240 then chol_status='High';

Re: Identifying missing data values in data set

Jagadishkatam — Thu, 16 Jul 2020 07:22:31 GMT

Alternatively you can try the proc format as below, for this you need to create a format and then use that format to derive a new variable.

Also, use the libname to call the dataset in the set statement.

proc format;
value chol
low-<200='Safe'
200-239='High-Borderline'
240-high='High'
other=' ';
run;

libname dat "/home/u44696116/TheCut/input";

data out;
	length chol_status $ 15;
	set dat.input44;
	drop bp_status weight_status smoking_status;
    chol_status=put(cholesterol,chol.);
run;

Re: Identifying missing data values in data set

armoore — Fri, 17 Jul 2020 04:31:10 GMT

Thank you