Hi all,
This is one xl formula can any one give a sas code (in macros)
=SUM(IF(O7>0.5,0.5+0.5*(O7-0.5),O7), IF(P7>0.5, 0.5+0.5*(P7-0.5),P7),IF(Q7>0.5,0.5+0.5*(Q7-0.5),Q7),IF(R7>0.5,0.5+0.5*(R7-0.5),R7),IF(S7>0.5,0.5+0.5*(S7-0.5),S7),IF(T7>0.5,0.5+0.5*(T7-0.5),T7))
Thanks
suresh
I would use an array to do this in SAS, something along the following lines.
%let val=0.5;
data want;
input o7 p7 q7 r7 s7 t7;
array vars{*} o7--t7;
sumvars=0;
do i=1 to dim(vars);
sumvars+ifn(vars{i}>&val.,&val.+&val.*(vars{i}-&val.),vars{i});
end;
drop i;
cards;
0.5 0.3 0.2 0.6 0.1 2
;
run;
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.