Is there a way to bring the value from a PROC FREQ output dataset into a PROC REPORT header?    For ex:    proc freq data=data; tables cohort/out=cohortct (drop=percent rename=count=cohortct); run; data cohortct; set cohortct; cohortct2=strip(cohort||' (N='||(strip(cohortct)||')')); put cohortct2; run;   I need to display COHORTCT2 in a column header in PROC REPORT. This is the value of COHORTCT2  1A (N=4) 1B (N=7) proc report data=table1 split="|" ; column cohort number1 ; define cohort/display center style(column)={width=1in} 'Cohort I need the numbers for COHORTCT here'; define number1 /display right style(column)={width=.5in} 'Subjects experiencing Grade 1'; run;   How can this be done?    ... View more

Can someone please help me create an automation/macro for this data step. Right now, I get data on a daily basis and I have to create fileid every day which is a pain when I get more than 1000 file ids. Is there a way it can automatically pick the total file ids from my stats data to create the %fileid(num=n) datasets, inN datasets and newN datasets. And is there a way to reduce the macro to few lines without filling the editor window. Please help. For more information, this is what I am trying to achieve https://communities.sas.com/message/185370#185370 Many thanks in advance! /*Comparing for unique VehicleIds*/ /*Update everyday*/ %macro fileid (num=); proc sort data=tripstats; by fileid vehicleid; data fileid# set stats; by fileid vehicleid; if fileid = # if first.vehicleid then output; run; proc sort data=fileid# by vehicleid; run; %mend fileid; %fileid (num=6);%fileid (num=7);%fileid (num=8);%fileid (num=9);%fileid (num=10);%fileid (num=11);%fileid (num=12);%fileid (num=13); %fileid (num=14);%fileid (num=15);%fileid (num=16);%fileid (num=17);%fileid (num=18);%fileid (num=19);%fileid (num=20); proc sort data=stats; by fileid vehicleid; data fileid5; set stats; by fileid vehicleid; if fileid=5; if last.vehicleid then output; run; proc sort data=fileid5; by vehicleid; run; /*New vehicles in each fileid*/ title1 "Unique vehicles in each fileid"; data want ;   merge fileid5 (in=in5 keep=vehicleid)         fileid6 (in=in6 keep=vehicleid)         fileid7 (in=in7 keep=vehicleid)         fileid8 (in=in8 keep=vehicleid)         fileid9 (in=in9 keep=vehicleid)         fileid10(in=in10 keep=vehicleid)   fileid11(in=in11 keep=vehicleid)   fileid12(in=in12 keep=vehicleid)   fileid13(in=in13 keep=vehicleid)   fileid14(in=in14 keep=vehicleid)   fileid15(in=in15 keep=vehicleid)   fileid16(in=in16 keep=vehicleid)   fileid17(in=in17 keep=vehicleid)   fileid18(in=in18 keep=vehicleid)   fileid19(in=in19 keep=vehicleid)   fileid20(in=in20 keep=vehicleid) ...................................     end=eof   ;   by vehicleid;   if first.vehicleid;   new6 + (in6 and ^in5);   new7 + (in7 and ^in6 and ^in5);   new8 + (in8 and ^in7 and ^in6 and ^in5);   new9 + (in9 and ^in8 and ^in7 and ^in6 and ^in5);   new10+ (in10 and ^in9 and ^in8 and ^in7 and ^in6 and ^in5);   new11+ (in11 and ^in10 and ^in9 and ^in8 and ^in7 and ^in6 and ^in5);   new12+ (in12 and ^in11 and ^in10 and ^in9 and ^in8 and ^in7 and ^in6 and ^in5);   new13+ (in13 and ^in12 and ^in11 and ^in10 and ^in9 and ^in8 and ^in7 and ^in6 and ^in5);   new14+ (in14 and ^in13 and ^in12 and ^in11 and ^in10 and ^in9 and ^in8 and ^in7 and ^in6 and ^in5);   new15+ (in15 and ^in14 and ^in13 and ^in12 and ^in11 and ^in10 and ^in9 and ^in8 and ^in7 and ^in6 and ^in5);   new16+ (in16 and ^in15 and ^in14 and ^in13 and ^in12 and ^in11 and ^in10 and ^in9 and ^in8 and ^in7 and ^in6 and ^in5);   new17+ (in17 and ^in16 and ^in15 and ^in14 and ^in13 and ^in12 and ^in11 and ^in10 and ^in9 and ^in8 and ^in7 and ^in6 and ^in5);   new18+ (in18 and ^in17 and ^in16 and ^in15 and ^in14 and ^in13 and ^in12 and ^in11 and ^in10 and ^in9 and ^in8 and ^in7 and ^in6 and ^in5);   new19+ (in19 and ^in18 and ^in17 and ^in16 and ^in15 and ^in14 and ^in13 and ^in12 and ^in11 and ^in10 and ^in9 and ^in8 and ^in7 and ^in6 and ^in5);   new20+ (in20 and ^in19 and ^in18 and ^in17 and ^in16 and ^in15 and ^in14 and ^in13 and ^in12 and ^in11 and ^in10 and ^in9 and ^in8 and ^in7 and ^in6 and ^in5);   ..................... if eof;   put (new6-new108) (=/); run; ... View more