I have 2 datasets with structure <Id Year month result>. Say data is
SET1:
0 2001 01 12
1 2001 02 10
2 2001 03 13
AND set2
0 2001 01 14
1 2001 02 15
2 2001 03 16
i want only the "result" of set 2 to be substracted from the corresponding rows of set1 (where id year and month match)..result set would be
0 2001 01 -2
1 2001 02 -5
2 2001 03 -3
I use proccompare, but it diffs both the datasets across all the corresponding elements. How can I diff only the corresponding "results" and preserve "id year month"..thank you
try:
data want;
merge set1(in=a rename =(result=r1)) set2(in=b rename=(result=r2));
by id year month;
if a and b;
r_diff=r1-r2;
run;
try:
data want;
merge set1(in=a rename =(result=r1)) set2(in=b rename=(result=r2));
by id year month;
if a and b;
r_diff=r1-r2;
run;
thanks Linlin
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.