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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.