topic Re: Columns with value 1 or greater in SAS Programming

Columns with value 1 or greater

Solly7 — Tue, 16 Mar 2021 09:09:03 GMT

Hi I need help in extracting only policies whereby there is a value greater than or equals 1 from either contents/ motor/ home columns..if all the values from contents/ motor/ home columns are 0, then delete the entire row..

see below code for data have

data have; input policy_no risk contents motor home cycle; datalines; 1 1 0 1 0 0 2 0 0 0 0 1 3 0 1 1 2 1 4 1 0 0 0 0 5 1 0 0 0 1 6 0 1 1 2 0 ;

Data Want

policy_no risk contents motor home cycle

1 1 0 1 0 0

3 0 1 1 2 1

6 0 1 1 2 0

Re: Columns with value 1 or greater

PeterClemmensen — Tue, 16 Mar 2021 09:18:55 GMT

Do this

data have;
input policy_no risk contents motor home cycle;
datalines;
1 1 0 1 0 0
2 0 0 0 0 1
3 0 1 1 2 1
4 1 0 0 0 0
5 1 0 0 0 1
6 0 1 1 2 0
;

data want;
   set have;
   if sum(contents, motor, home);
run;

Result:

policy_no risk contents motor home cycle 
1         1    0        1     0    0 
3         0    1        1     2    1 
6         0    1        1     2    0

Re: Columns with value 1 or greater

Solly7 — Tue, 16 Mar 2021 09:34:01 GMT

Thanks a lot..its working fine

Re: Columns with value 1 or greater

PeterClemmensen — Tue, 16 Mar 2021 10:12:35 GMT

Anytime 🙂