If Logic, Setting one variable = to another

[GalacticAbacus]

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;

[RW9 · Accepted solution]

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;

[GalacticAbacus]

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

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

Thanks again.

TS