topic solve question - based on creating a new variable on basis of 6 existing variable in SAS Programming

solve question - based on creating a new variable on basis of 6 existing variable

TiaK — Sat, 10 Mar 2018 21:02:48 GMT

I dont have any data but i have to give a sample code for how i would solve such a problem.

the problem is to Create a variable decision_pt that sums the occurences of the following

age < 45
state is “URBAN” or “HIGHLY URBAN”
furniture >= 5
premium = yes
usage = “COMMERCIAL”
male = 1

data a;
set a;
retain decision_pt = 0;
if age < 45 then decision_pt =decision_pt +1 ;
if state ="URBAN" or "HIGHLY URBAN" decision_pt =decision_pt +1 ;

am i on the right track?

Re: solve question - based on creating a new variable on basis of 6 existing variable

PaigeMiller — Sat, 10 Mar 2018 20:52:43 GMT

You can't expect us here in SAS Communities to do your homework for you! You will not learn anything that way.

So here's my suggestion: you write some SAS code to do this, and if you can't get it to work, show us the code and the SASLOG, and someone here will know how to fix it.

Re: solve question - based on creating a new variable on basis of 6 existing variable

TiaK — Sat, 10 Mar 2018 21:06:23 GMT

i modified the question with my answer now. hope this helps.

Re: solve question - based on creating a new variable on basis of 6 existing variable

PaigeMiller — Sat, 10 Mar 2018 21:09:04 GMT

Seems like this could produce the desired answer, once you clean up your syntax errors.

if state ="URBAN" or state="HIGHLY URBAN" then decision_pt =decision_pt +1 ;

Re: solve question - based on creating a new variable on basis of 6 existing variable

TiaK — Sun, 11 Mar 2018 11:23:39 GMT

Is adding retain important here?

Re: solve question - based on creating a new variable on basis of 6 existing variable

PaigeMiller — Sun, 11 Mar 2018 18:10:09 GMT

RETAIN probably isn't needed here, and may have undesired effects.

I think you want

decision_pt=0;