Post test data in the form of a datastep. As such this is just an example:
proc sql;
select a.*,
b.*,
b.p_t1-a.p_t as variationp,
b.c_t1-a.c_t as variationc
from tablet a
full join tablet1 b
in a.id=b.id
and a.lib=b.lib;
quit;
You need to be more specific on the values you have. Your values are like -->65901635,61 is this a single values or two values separated by comma? If they were two values then what was your logic for calculating -7693248,1 How did you get that one there?
Please be more specific and provide your sample data in the form of a data step.
Thanks, Suryakiran
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.