code Hi guys,
I was wondering if anyone knew how to create a new variable by performing a simple mathematical operation on an existing column.
I've shown the operation im trying to do in the NEW COLUMN):
EXISTING COLUMN NEW COLUMN
-1
-5 (-5) - (-1)
7 ( 7) - (-5)
-3 (-3) - ( 7)
2 etc...
9
4
1
I basically need to create a new column that subtracts existing observation #1 from #2, existing observation #2 from #3, and so on...
Any ideas as to how I can write a code for this?
Thanks in advance.
data want;
set your_dataset;
new=EXISTING_ COLUMN-lag(EXISTING_ COLUMN);
run;
Also note ... we use LAG quite often, so often that we might forget about:
data want;
set your_dataset;
new_column = dif(EXISTING_COLUMN);
run;
That is so true. Thank you! - Linlin
Thank you guys so much, I appreciate the help.
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 the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.