topic Re: If-Then Statement help in SAS Programming

If-Then Statement help

JibJam221 — Sat, 30 Oct 2021 02:05:50 GMT

Hello,

I am trying to make a code that can help me recategorize my tables. The variables that will be conditioned are: Province and City. Basically, if Province is = to Toronto and the Province is Ontario, i'd like the region to be categorized as "Toronto". If province is = to Ontario and city is NOT equal to toronto, id like region to be categorized as "outside of toronto".

Here is the code I have:

data work.tester2;

if province="ON" and city="torontp"
then
Region="Toronto";

else if province= "ON" and city^="toronto"
then Region="outside of toronto";
end;

run;

when I run this code, all fields go blank.

Thanks

Re: If-Then Statement help

SASKiwi — Sat, 30 Oct 2021 02:12:01 GMT

Try removing your END statement and can only be used with a matching DO statement which you don't have.

Check your SAS log for errors. What does it say?

Re: If-Then Statement help

JibJam221 — Sat, 30 Oct 2021 02:17:09 GMT

thanks for your help, when I remove the END, all columns delete and I am left with three blank columns: Province, City, and Region. I'm not sure what is going wrong, but there is no errors or notes in the log

Re: If-Then Statement help

SASKiwi — Sat, 30 Oct 2021 02:27:43 GMT

Ah, you aren't reading any data in. You need a SET statement to read in an existing SAS dataset.

Re: If-Then Statement help

JibJam221 — Sat, 30 Oct 2021 02:28:53 GMT

WOW good catch! Its always the little things. I appreciate your help!

Re: If-Then Statement help

JibJam221 — Sat, 30 Oct 2021 03:05:12 GMT

hello, quick question. I updated my code to categorize the entire dataset. Here is my code:
data work.tester4;
set work.tester4;

if province="ON" and city="Toronto" then Region="Toronto";
else if province= "ON" and city^="Toronto" then Region="Outside of Toronto";
else if province="AB" and city="Calgary" then Region="Calgary";
else if province="AB" and city^="Calgary" then Region="Outside of Calgary";
else Region="N/A";
run;

I am recieving the following error:
WARNING: Limit set by ERRORS= option reached. Further errors of this type will not be printed.

is this a reason for concern? The warning is highlighted as the 'run;' statement.

thanks