topic How to only select non-zero values from a column of data containing 1's and 0's? in SAS Programming

How to only select non-zero values from a column of data containing 1's and 0's?

lolol0101 — Thu, 29 Dec 2022 15:42:51 GMT

Hi, I am very new to SAS, so I'm still learning...

How do create a new data set and select non-zero values in a column?

Thank you.

Re: How to only select non-zero values from a column of data containing 1's and 0's?

Tom — Thu, 29 Dec 2022 15:46:00 GMT

Let's assume the existing dataset is named HAVE and the variable you want to test is named STATUS.

Then to make a new dataset, let's call it WANT, that is the subset of HAVE that has non zero values of STATUS you could use this simple data step.

data want;
  set have;
  where status ne 0 ;
run;

Re: How to only select non-zero values from a column of data containing 1's and 0's?

Astounding — Thu, 29 Dec 2022 16:08:01 GMT

A slight variation on that result:

data want;
   set have;
   where status;
run;

This removes cases that have zero for STATUS, and also removes cases that have a missing value for STATUS. Which one you use depends on which result you want.