Hi,   I am trying to calculate binomial CI for my efficacy data using below code. But it is throwing error when we have only one category(resp='0') in response variable for a particular category of by variable. As i am using LEVEL=2 option its throwing error. Let me know how to handle this.   proc freq data=dsin1;   by  viswin  leg_sort ;   tables &G_A_RESPVAR/ binomial (level=2);   exact binomial;   ods output OneWayFreqs=freqs              BinomialProp=Exttst(where=(name1 in("XL_BIN", "XU_BIN"))); run;   Thanks, Ravi. ... View more

Hi All, Pl let me know how to password protect/readonly the .xls file using SAS. I want to created read only file when I exporting the dataset to .xls file. Thanks in advance. ... View more

Hi All, Can you pl let me know how to get adjusted geometric mean? model is resp as dependent and trt is independent. And also I need the comparison treatmets (ratio and 95% CI) Like A:B A:C Thanks, Ravi. ... View more

Hi All, Pl help me to read the .txt tile to sas as a dataset using sas or unix. .txt file contains sas reports like listing or summary table. Thanks in advance, Ravi ... View more

Hi, ods escapechar='^'; I used "Page ^{thispage} of ^{lastpage}" to get the page nos. But Iam not able to get the page nos for the following code. But it worked for me for other sample code. goptions /*reset=all*/ gsfmode=replace targetdevice=emf device=/*cgmof97l*/emf /*gaccess=gsasfile*/ colors=(black) ftitle=simplex ftext=simplex htext=1 /*hsize=0 vsize=0 */xpixels=1450 ypixels=/*1350*/1000; symbol interpol=join repeat=&n1 h = 2 width=1 mode=include color=black; symbol2 interpol=join h=2 width=1 l=1 repeat=&n2 color=black value=dot; axis1 label=(h=3 'Time (days)' font=Arial ) order=(0 to 120 by 10) MINOR=NONE; axis2 label =(angle=90 h=3 "concentration (ng/mL)") logbase=10 logstyle=expand minor=none; ODS pdf FILE = "/vob/CSMS995L/CSMS995L2102/report/export/pkpd/pgm_cp/temp.pdf" startpage=never; title1 j=r f=Arial "Page @{thispage} of @{lastpage}"; footnote1 h=2 j=l f=Arial "&tit" j=r f=Arial 'Page ^{thispage} of ^{lastpage}'; proc gplot data=pk1 /*gout=work.tempc */; by trt; plot conc_*stm4n=sid1a / /*name="g1" */ vaxis=axis2 haxis=axis1 nolegend /*annotate=anno*/; plot2 median*stm4n=sid1a / vaxis=axis2 haxis=axis1 nolegend /*annotate=anno1*/; format stm4n best. conc_ 6.2 trt $trt.; title5 h=2 f=Arial "Treatment: #byval1"; run; quit; ods pdf close; ... View more

Hi, I have generated page numbers in trt like x of y. My rreport is having 4 figures in four pages. So, page numbers are comming like 1 of 1, 2 of 4, 3 of 4, 4 of 4. But when i scrolldown to fourth page and come back to first page, first page is changing to 1 of 4. Pl help me in this. Thanks. ... View more

Dear all, Could you pl tell how to simulate (data generation) clinical data (numaric and catogarical)? Thanks, Ravi ... View more

Hi all, Could you pl any one tell how to update the annotated CRF with hyperlinks? Pl give some information on "update the annotated CRF with hyperlinks". Thanks.. Ravi. ... View more

hi all, Could u pl tell how to place password for sas code (programme) file. I mean, I want to create read only file. Thanks, Ravi. ... View more

Hi all, Could you pl tell how to sort the varaible names in a dataset using data step. Thanks, Ravi ... View more