can you suggest best style options for pdf format graphs? ... View more

Hi ,   Sorry I am now to this site and not able to understand process, please find below code which is I used, My main concern is why can't we generated graphs in pdf?,   ods graphics on; ods graphics/reset=all border=off height=3.5in width=9in ; proc sgplot data=derive.&outdat. noautolegend ; format TRT01PN trt. avisitn avisit.; series x=AVISITN y= Estimate /group=TRT01PN markers markerattrs=(size=10 ); keylegend/ title="" location=inside position=TOPLEFT VALUEATTRS=(Size=13pt) across=2 ; Xaxis type=linear label="Week" VALUEATTRS=(Size=10pt) labelattrs=(size=10pt) display=all interval=auto; yaxis label="LS mean Change ^{unicode '00B1'x} SE ^{unicode '1d43'x}" minor display=all VALUEATTRS=(Size=13pt) type=linear; scatter x=AVISITN y= Estimate / group=TRT01PN groupdisplay=cluster clusterwidth=0.4 yerrorlower=low yerrorupper=high markerattrs=(size=10 ); xaxis type=discrete; xaxistable Number /x=avisitn class=TRT01PN nomissingchar TITLE = "Number of Subjects" titleattrs=(family="Arial" size=8pt color=black style=normal weight=bold ) /*valueattrs=(family="Arial" size=8pt color=black style=normal weight=bold)*/ labelattrs=(family="Arial" size=8pt color=black style=normal weight=bold); run; ods graphics off; ods pdf close;   ... View more

good ... View more

Sorry sir i can't post data, in one column i want split data,  you can imagine as XYZ.. ,, is there any way to do like that, if an option in  proc report also not a problem  ... View more

Yes, Please find the below, i want final report like this.     Week 2 Change from baseline Number Mean (SD) - LS Mean (SE) a - LS Mean Diff vs. matching placebo (95% CI) a - P-value vs. matching placebo a -   like this i have multiple sections , so i am going to create macro with ion data set level. ... View more

Thanks for your replay Sir.   I don't want set  all datasets , it should be separately and macro variable should create in all datasets. ... View more

Hi Sir, for CDISC studies(Clinical trails) we have to create variable Domin and it should contain data set name.  and length also minum $2 and max 5. ... View more

Thank you ... View more

Sorry, please find below code for the same     data ned; length parameter $15. stats $10. DrugA $5. DrugB $5. total $5.; input parameter stats DrugA DrugB total ; datalines; Age(years) Maximum 48 42 48 Age(years) Mean 33.5 28.93 31.29 Age(years) Median 35 29 32 Age(years) Minimum 22 21 21 Age(years) Q1 25.5 23 24 Age(years) Q3 39 33 36 Age(years) SD 7.581 5.75 7.039 Age(years) n 16 15 31 Height(cm) Maximum 173 173 173 Height(cm) Mean 166.81 167.4 167.1 Height(cm) Median 167 167 167 Height(cm) Minimum 159 161 159 Height(cm) Q1 164.5 165 165 Height(cm) Q3 169.5 171 170 Height(cm) SD 3.371 3.602 3.439 Height(cm) n 16 15 31 Weight(kg) Maximum 78 79.5 79.5 Weight(kg) Mean 68.7 68.07 68.4 Weight(kg) Median 69.4 68.3 69 Weight(kg) Minimum 54.1 51.6 51.6 Weight(kg) Q1 65.53 64 64.75 Weight(kg) Q3 74.5 72.4 74 Weight(kg) SD 6.872 6.945 6.799 Weight(kg) n 16 15 31 ; run; ... View more

Please find the below screen shot and my data in below formate ... View more

Please find my code below i am using proc report to generate rtf file   proc report data= derived.&derive.  nowd split='*' headskip headline missing style(column)=[vjust=center ];   column ORPRM CAT ordst STATS   T_DRUG R1_DRUG TOTAL_DRUG;   define ORPRM /noprint order order = internal ; define CAT / "Variable/*  Category " order=data style=[asis=on just=left  cellwidth=.8cm  ] left order order ; define ordst /noprint order  ; define STATS / "Statistics" style=[just=left cellwidth=.5cm ] left ; define T_DRUG / "T*(N=&NT.)" order=data style=[just=center  cellwidth=.5cm  ] left order  ; define R1_DRUG / "R1*(N=&NR.)" style=[just=center  cellwidth=.5cm ] left ; define TOTAL_DRUG / "Total*(N=&NTot.)" order=data style=[just=center  cellwidth=.5cm  ] left order ;   compute CAT; if CAT in ("Ethnicity/Race","BMI(kg/m^{super 2})","Age (years)" "Height (cm)" "Weight (kg)") then         call define(_col_, "style", "style=[font_weight=bold]"); endcomp;   compute after ORPRM; line @1 ""; endcomp;   compute after / style=[borderbottomcolor=black bordertopwidth=2]; line ""; endcomp; run; ods _all_ close;   ... View more