Thank you for helping on how to create an auto report and keep blanks. I  run into another problem - the Eexcel output takes two rows for each data after "STYLE={ PRETEXT='  '  ASIS=ON}" is added.  Why? data t; order_c='001.0'; overall='64,491      ';  title = '   Number of Customer     '; output; order_c='002.0'; overall='100%       ';  title = '   Percentage of Customer '; output; order_c='002.1'; overall='            ';  title = 'Customer Info             '; output; order_c='002.2'; overall='            ';  title = '   Dollar Spend           '; output; order_c='003.0'; overall='$728       ';  title = '     Average              '; output; order_c='004.0'; overall='15%       ';  title = '     0:Zero               '; output; order_c='005.0'; overall='9%       ';  title = '     1:<600               '; output; run; proc report data=t NOWD  ;     column  title Overall order_c; DEFINE  title /DISPLAY STYLE={CELLWIDTH=5in}  ;  DEFINE order_c / /*NOPRINT*/ ORDER; DEFINE overall /DISPLAY STYLE={CELLWIDTH=1.5in  TEXTALIGN=R} STYLE(HEADER) = {font_weight=bold JUST=C};    COMPUTE order_c;    IF substr(order_c,5,1) in ('0','2') THEN      CALL DEFINE('_c1_', "STYLE","STYLE={ PRETEXT='  '  ASIS=ON}");    ELSE IF substr(order_c,5,1) = '1' THEN      CALL DEFINE('_c1_', "STYLE","STYLE={font_weight=bold}"); ENDCOMP;   run; ... View more

in a macro, I would like to make it fexible, instead of use  name = "tbl_&x1._&x2._&x3.", is there a way to make tbl_&&x1 %do k=2 %to &numbertype;     .._&&x&k %end; but how to make quotetion (") work in where statement?  Thank you! proc sql;   select attname from _v_relation_column   where name = "tbl_&x1._&x2._&x3."; quit; ... View more

Happy Holidays! Could you please explain why the value TYPE after the modification couldn’t give correct answer?  The correct answer should be like this but the code didn't give this.  Why?  Thank you! Type Frequency .                  1 3                1 5                4 data lk;    input id type; datalines; 1 1 2 2 3 3 ; run; data test; input id; datalines; 1 1 2 2 3 4 ; run; data test1; merge test(in=in1) lk; by id; if in1;   if type in (1,2) then type=5;   else if type ^= 3 then type=.; run; proc freq data=test1; tables  type/list missing; run; ... View more