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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.