topic Re: If Logic, Setting one variable = to another in SAS Programming

If Logic, Setting one variable = to another

GalacticAbacus — Fri, 22 May 2015 13:16:18 GMT

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;

Re: If Logic, Setting one variable = to another

RW9 — Fri, 22 May 2015 13:19:56 GMT

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;

Re: If Logic, Setting one variable = to another

GalacticAbacus — Fri, 22 May 2015 13:21:11 GMT

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

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

Thanks again.