If Logic, Setting one variable = to another

Accepted Solution Solved
Reply
Contributor
Posts: 49
Accepted Solution

If Logic, Setting one variable = to another

Could someone tell me why this code isn't working?

I have a data set called "Feb_2",

I'm creating a data set "Feb_3",

Feb_2 has a variable "Net Points" and if it's less than 0 I would like to have a new variable "Net_Point_Adj" set to 0, else if "Net Points" is 0 or greater, I'd like the new variable "Net_Point_Adj" to = the value of "Net Points".

SAMPLE 1

DATA Feb_3;

Set Feb_2;

IF Net_Points <0, THEN Net_Point_Adj = 0;

ELSE Net_Points_Adj = Net_Points;

RUN;

SAMPLE 2

DATA Feb_3;

Set Feb_2;

IF Net_Points <0, THEN Net_Point_Adj = 0;

ELSE IF Net_Points_Adj => 0, THEN Net_Point_Adj = Net_Points;

RUN;


Accepted Solutions
Solution
‎05-22-2015 09:19 AM
Super User
Super User
Posts: 7,942

Re: If Logic, Setting one variable = to another

Posted in reply to GalacticAbacus

Why are you putting a comma after the value?

IF Net_Points <0, THEN Net_Point_Adj = 0;

This is invalid SAS code.


Secondly, may I suggest some code readability:

data Feb_3;

     set Feb_2;

     if Net_Points < 0 then Net_Point_Adj=0;

     else Net_Points_Adj=Net_Points;

run;

View solution in original post


All Replies
Solution
‎05-22-2015 09:19 AM
Super User
Super User
Posts: 7,942

Re: If Logic, Setting one variable = to another

Posted in reply to GalacticAbacus

Why are you putting a comma after the value?

IF Net_Points <0, THEN Net_Point_Adj = 0;

This is invalid SAS code.


Secondly, may I suggest some code readability:

data Feb_3;

     set Feb_2;

     if Net_Points < 0 then Net_Point_Adj=0;

     else Net_Points_Adj=Net_Points;

run;

Contributor
Posts: 49

Re: If Logic, Setting one variable = to another

I added the comma because I was being sloppy Smiley Sad Thank you.

And yes I'll be more vigilant in code organization.

Thanks again.

TS

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 178 views
  • 0 likes
  • 2 in conversation