Hello,   As C is on the numerator, you shouldn't have to test its value. Also, D is a numeric variable so "INF" is not a valid value. You could set it to . and add an indicator variable as follows :   proc sql; SELECT a, b, abs(a-b) AS c, CASE WHEN a=0 THEN . ELSE round(CALCULATED c*100/a,0.01) END AS d, CASE WHEN a=0 THEN 1 ELSE 0 END AS INF FROM test; quit; ... View more

Hello,   Your problem is independant of Eg prompts. When a macrovariable is created as follows :   %let mv1=1; %let mv2=2; %let mv=&mv1.+&mv2.;   The compiler only performs text substitution so you wil end up with &mv.=1+2.   If you want to evaluate the resulting expression you have to enclose the whole expression in an evaluation function %eval() or %sysevalf   %let mv=%eval(&mv1.+&mv2.); /* => 3 */ ... View more

Hello, If you're using SEG, right click in the program editor lets you select whicjh server to run the program on. There must be a  "Select server" entry in the contextual menu  (my SEG version is in french so the exact label may differ) where you can select "local". ... View more

Hello,   Assuming you have character dates as input :   data have; length date_1 date_2 $10; input id date_1 $ date_2 $; cards; 1 01/01/2018 05/16/2017 2 02/03/2018 06/25/2016 3 12/21/2017 03/01/2015 ; run; data _NULL_; set have end=eof; call execute('data want; set have(rename=('); length colname $32; do while (upcase(colname) ne "COLNAME"); call vnext(colname); if colname=:"date" then do; call execute(cats(colname,'=old_',colname)); end; end; call execute('));'); colname=""; do while (upcase(colname) ne "COLNAME"); call vnext(colname); if colname=:"date" then do; call execute(catx(' ','format',colname,'date9.;',colname,'=input(old_'||colname,', mmddyy10.);')); end; end; call execute('drop old_:; run;'); stop; run; ... View more

Hello, try to describe your problem with a simple example that can be replicated by SAS forum users.   The following query on sashelp.class has a form similar to your example : proc sql; SELECT sum(HEIGHT1,WEIGHT) FROM sashelp.class WHERE HEIGHT1 IN ( SELECT sum(HEIGHT) AS HEIGHT1 FROM sashelp.class WHERE HEIGHT>60 ); quit; You cannot use the varaible name HEIGHT1 created in the subquery in the main query.  You can do as follows instead : proc sql; SELECT sum(sum((HEIGHT>60)*HEIGHT),WEIGHT) FROM sashelp.class ; quit; ... View more