topic Re: Missing Values in SAS Programming

Missing Values

mariamon0 — Thu, 14 Mar 2019 23:27:57 GMT

How would I list the missing values of a particular variable?

for instance how would I list subject IDs (Variable is ID-numeric variable) who have missing cholesterol values (variable col-numeric variable) in sas code?

Re: Missing Values

PeterClemmensen — Thu, 14 Mar 2019 23:42:03 GMT

Questions like this is a lot easier to answer if you show us some example data to work with 🙂

Are there multiple observations for the same ID? And should the ID have all missing cholesterol values or is a single missing enough?

Re: Missing Values

mariamon0 — Thu, 14 Mar 2019 23:45:06 GMT

There were many different variables that the subject IDs have. Im only looking to see if the subject IDs (there are over 500) are missing cholesterol values. There is only one single cholesterol value for each subject ID. I would like a list of all subject Ids with missing cholesterol values.

Re: Missing Values

Reeza — Fri, 15 Mar 2019 02:07:19 GMT

Add a filter using a WHERE statement.

For example:

data want;
set sashelp.heart;
where missing(deathCause); *filter for only records with missing deathCause;
keep _all_; *keep only variables of interest;
run;

@mariamon0 wrote:

There were many different variables that the subject IDs have. Im only looking to see if the subject IDs (there are over 500) are missing cholesterol values. There is only one single cholesterol value for each subject ID. I would like a list of all subject Ids with missing cholesterol values.

Re: Missing Values

Astounding — Fri, 15 Mar 2019 02:17:38 GMT

Getting a list is easy:

proc print data=have;

where cholesterol = .;

var subject_id;

title 'IDs for subjects who are missing Cholesterol measurement';

run;