Solved
Contributor
Posts: 49

# 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
Posts: 9,599

## 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;

run;

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

## 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;

run;

Contributor
Posts: 49

## Re: If Logic, Setting one variable = to another

I added the comma because I was being sloppy 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
• 219 views
• 0 likes
• 2 in conversation