topic Re: Proc Print WHERE multiple input in SAS Enterprise Guide

Proc Print WHERE multiple input

Stepik — Tue, 11 Jul 2023 10:33:44 GMT

Dear team, I I have been stuck to find a solution to provide the output results for the 3 months. The solution does not work if I add months 04 and 05.

What is the best way to display the data for the condition WHERE Check = 0 and month = 03 04 05?

proc print data=Oth (obs=1000);
where Check=0 and month = 03;
run;

Re: Proc Print WHERE multiple input

yabwon — Tue, 11 Jul 2023 10:59:19 GMT

If month is numeric:

month in (3 4 5)

or if month is character:

month in ('03' '04' '05')

Re: Proc Print WHERE multiple input

Stepik — Tue, 11 Jul 2023 11:48:15 GMT

it is numeric, so

the code is the next:

proc print data=Ret_oth (obs=1000);
where Check=0 and reporting_month in (03 04 05);
run;

But still the results only provide 03 data

Re: Proc Print WHERE multiple input

yabwon — Tue, 11 Jul 2023 11:54:10 GMT

The following:

data Ret_oth;
  do reporting_month = 1 to 5;
    Check=0; output;
    Check=1; output;
  end; 
run;

proc print data=Ret_oth (obs=1000);
where Check=0 and reporting_month in (03 04 05);
run;

works as expected.

Check you data (Maxim 3), maybe months 4 and 5 are after obs=1000?

Bart

Re: Proc Print WHERE multiple input

Stepik — Tue, 11 Jul 2023 12:02:14 GMT

correct, I need to check for more observations. Then it works. Thanks