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;
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;
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;
I added the comma because I was being sloppy Thank you.
And yes I'll be more vigilant in code organization.
Thanks again.
TS
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.