If-Then Statement help

[JibJam221]

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

[SASKiwi]

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?

[JibJam221]

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

[SASKiwi · Accepted solution]

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

[JibJam221]

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

[JibJam221]

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