SAS Help Center: Counting Duplicate Rows in a Table   in this link, it shows result for PROC SQL Output for Counting Duplicates. i want to save it to dataset or csv. not sure how to do that. thanks. ... View more

  well, I try to use proc printto save log, the log shows numbering on left. is there any way to remove it?   OPTIONS  NONUMBER not working? thanks         NOTE: PROCEDURE PRINTTO used (Total process time):       real time           0.00 seconds       cpu time            0.01 seconds       3    ods escapechar='^'; 4    5    proc sort data=sashelp.class out=class; 6    by sex; 7    run;   proc printto log='C:\Desktop\backup\CA402.log' new; run; ods escapechar='^'; proc sort data=sashelp.class out=class; by sex; run; data c11; set class; length sexf $50.; dup=1 ;output; dup=2; output; dup=3 ;output; dup=4; output; run; data c1; length sexf2 $50.; set c11; if dup=1 then sexf=sex; if dup=2 and sex='F' then sexf='g'; if dup=2 and sex='M' then sexf='h'; if dup=3 and sex='F' then sexf='i'; if dup=3 and sex='M' then sexf='j'; if dup=4 and sex='F' then sexf='k'; if dup=4 and sex='M' then sexf='l'; dupc=STRIP(PUT(dup, 8.)); if age in (11 12 13 ) then sexf2=strip(sexf)||strip(dupc)||' multi tests3 multi tests3'; else sexf2=strip(sexf)||strip(dupc)||' multi tests3 multi'; sexf3=strip(sex); sexf4=' multi tests3'; group=1; run; proc sort data=c1;by sexf4 sexf3 sexf2 age group;run; PROC MEANS DATA=c1 NOPRINT; BY sexf4 sexf3 sexf2 age group; VAR Weight; OUTPUT OUT=AB N=N0 MEAN=Mean0 CV=CV0 STD=SD0 STDERR=SE0 LCLM=LCLM UCLM=UCLM MIN=MIN0 Q1=Q10 MEDIAN=Median0 Q3=Q30 MAX=MAX0; RUN; PROC tabulate data=ab ORDER=data; by sexf4 sexf3 sexf2; CLASS sexf4 sexf3 sexf2 age group; VAR n0 median0 q30 MIN0 MAX0 ; keyword mean / style=[just=R]; keyword StD / style=[just=L]; TABLE sexf4=" "*sexf3=" "*sexf2=" "*age=" "*( n0='n'*max=''*f=4. median0='Median'*max=''*f=8.2 Q30='Q3'*max=''*f=8.2 min0='Tmin'*max=''*f=8.2 max0='Max'*max=''*f=8.2 ), age=" " / misstext='---' box=" sex" RTS=30 ; RUN; OPTIONS CENTER NODATE NONUMBER ORIENTATION=landscape CENTER LEFTMARGIN="1 IN" RIGHTMARGIN="1 IN" TOPMARGIN="1 IN" BOTTOMMARGIN="1 IN" ; proc printto; run;     ... View more

  …..I cleared log and use proc printto to save log, but log start from line 4109? how to make it start from line 1? don't know how to reset number after each run. thanks.     dm output 'clear'; dm log 'clear'; proc delete data=work._all_; run; proc printto log='L:\ acct.log' new; run;   NOTE: PROCEDURE PRINTTO used (Total process time):       real time           0.01 seconds       cpu time            0.00 seconds       4109  4110  4111  **************************************************************************** 4112  Filename ... View more

  I need to AUC_%Extrap in footnote, but sas thought I have a macro named EXTRAP and give me a warning. don't know how to fix it. thanks   FOOTNOTE1 J=L "Notes: parameters are based on AUC_%Extrap<60";   WARNING: Apparent invocation of macro EXTRAP not resolved. ... View more