topic Create a new variable based on flag indicator in SAS Programming

Create a new variable based on flag indicator

westbestern — Thu, 30 Sep 2021 01:15:05 GMT

I have towns in a dataset flagged with "*" or nothing (" ")

I want to create a new variable called location where "*"= "north" and " "= "south"

When I do this code, it codes " " to "south" but not "*" to "north"

data class4.water;
if flag="*" then location="north";
else if flag="" then location="south";
run;

Why is that happening? What can I do in my code to fix it?

Re: Create a new variable based on flag indicator

Astounding — Thu, 30 Sep 2021 01:42:43 GMT

This step works as it should. There is no SET statement, so no data is being brought in. I hope you have a way of re-creating CLASS4.WATER, because running this program just wiped it out, replacing it with a single observation and no data other than what you are observing.

Re: Create a new variable based on flag indicator

tarheel13 — Thu, 30 Sep 2021 16:06:08 GMT

need to post data so we can help.