topic Re: Help with IF-THEN Output clause in New SAS User

Help with IF-THEN Output clause

Jesusismygrace — Tue, 24 Jan 2023 21:54:53 GMT

Hi, I can't seem to get this code to work.

data BSC_mbr_2021b;
set BSC_mbr_2021;
if (payercode = 'C' and productcode = 'H') or (payercode = 'C' and productcode = 'S') then do;
product = 'Commercial HMO POS';
output;
else do;
product = 'Other';
output;
end;
run;

I get this error message.

24
25 GOPTIONS ACCESSIBLE;
26 data BSC_mbr_2021b;
27 set BSC_mbr_2021;
28 if (payercode = 'C' and productcode = 'H') or (payercode = 'C' and productcode = 'S') then do;
29 product = 'Commercial HMO POS';
30 output;
31 else do;
____
160
ERROR 160-185: No matching IF-THEN clause.

32 product = 'Other';
33 output;
34 end;
35 run;

35 run;
_
117
ERROR 117-185: There was 1 unclosed DO block.

Re: Help with IF-THEN Output clause

ballardw — Tue, 24 Jan 2023 22:10:23 GMT

data BSC_mbr_2021b;
set BSC_mbr_2021;
if (payercode = 'C' and productcode = 'H') or (payercode = 'C' and productcode = 'S') then do;
product = 'Commercial HMO POS';
output;
end; /* to end the first "then do" */
else do;
product = 'Other';
output;
end;
run;

Re: Help with IF-THEN Output clause

Jesusismygrace — Tue, 24 Jan 2023 23:13:49 GMT

Thank you!