I have a large data set like this :
NAME MONEY NB NUMBER
John 300 1 4
Max 250 2 5
Alex 657 1 3
Matt 1520 2 2
For NB = 2, I want to divide NB by 2 , divide MONEY by NUMBER and also keeping observations for NB = 1. I mean how get this :
NAME MONEY NB
John 300 1
Max 50 1
Max 50 1
Alex 657 1
Matt 760 1
Matt 760 1
data want;
set have;
if nb = 2
then do;
money = money / number;
nb = nb / 2;
output;
end;
output;
drop number;
run;
data want;
set have;
if nb = 2
then do;
money = money / number;
nb = nb / 2;
output;
end;
output;
drop number;
run;
What if NB = 3 or higher, is that possible?
In my data set, NB is only equals to 1 or 2
You can replace the
nb = nb / 2;
in my code with
nb = 1;
as there can never be a different outcome.
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.