topic how can i compute new variable? in SAS Procedures

how can i compute new variable?

glee217 — Fri, 15 Sep 2017 09:14:26 GMT

/* This is the STATS301 start up file */
*Set up title on line 1;
TITLE1 "STATS 301 / 749750841 / glee217 : &sysuserid";
*Specify SAS library for storing permanent SAS datasets;
LIBNAME stats301 "C:\301";

***HERE
***import .sas7bdat file;
data temp;
set stats301.account_level_ds;
run;


data nonnegative;
set temp;
keep current_balance lending_interest;
if (current_balance <0) then delete;
rename lending_interest=yearint;
yearint = (current_balance)*0.03;
run;

title1 "nonnegative";
proc print data=nonnegative (obs=10);
run;

Hi I'm trying to create new variable called 'yearint' for data 'nonnegative' but somehow my code below doesn't work and it just gives me origianal 'lending_interest' value along to where it is not 'current_balance<0'

yearint = (current_balance)*0.03;

how can i write down new variable and compute some new integer which is calculated with another variable?

Thank you

Re: how can i compute new variable?

RW9 — Fri, 15 Sep 2017 09:27:36 GMT

Your issue is likely the placement and use of rename - this is renaming another variable to be current balance. This code below, renames the incoming variable, then your datasetp code will overwrite this.

Note some formatting changes:

title1 "STATS 301 / 749750841 / glee217 : &sysuserid";

libname stats301 "C:\301";

data nonnegative (keep=current_balance lending_interest);
  set stats301.account_level_ds (rename lending_interest=yearint);
  where current_balance < 0;
  yearint=(current_balance)*0.03;
run;

title1 "nonnegative";
proc print data=nonnegative (obs=10);
run;

Re: how can i compute new variable?

glee217 — Fri, 15 Sep 2017 09:50:50 GMT

data integer;
set temp;

if (current_balance <0) then yearint = lending_interest;

if (current_balance >=0) then yearint = int((current_balance)*0.03);
run;

proc print data=integer (obs=10);
var current_balance yearint
run;

hi sorry but can i ask you a difference question? i still want to create variable 'yearint' but this time i want to use 'current_balance' variable directly. And it didn't give me decimal places. do you know how to fix this?

Re: how can i compute new variable?

RW9 — Fri, 15 Sep 2017 11:32:08 GMT

You specify you want an integer result:

if (current_balance >=0) then yearint = int((current_balance)*0.03);

The int() is a function which returns only a hole number, remove that if you want decimals.

Re: how can i compute new variable?

Reeza — Fri, 15 Sep 2017 14:55:26 GMT

You should ELSE IF instead of multiple IF and comment your code. It also seems weird to round one value and not the other for the same variable?

if (current_balance <0) then yearint = lending_interest;
else if (current_balance >=0) then yearint = int((current_balance)*0.03);

@glee217 wrote:
data integer;
set temp;

if (current_balance <0) then yearint = lending_interest;

if (current_balance >=0) then yearint = int((current_balance)*0.03);
run;

proc print data=integer (obs=10);
var current_balance yearint
run;
hi sorry but can i ask you a difference question? i still want to create variable 'yearint' but this time i want to use 'current_balance' variable directly. And it didn't give me decimal places. do you know how to fix this?