Trying to use proc report to get a proc format to resolved but not working. proc format; value grpfmt 1 = "< 6 years " 2 = "6 to < 12 years " 3 = "12 to < 18 years" 4 = ">= 18 years " ; value aprd1_ /*0 = " "*/ 1 = "PK-I Infusion 1" 2 = "PK-I Infusion 2" 3 = "Period 1" 4 = "Period 2" 5 = "PK-II Infusion 3" 6 = "PK-II Infusion 4" 7 = "Period 3" 8 = "PK-III Infusion 5" 99="End of Study" ; value $regname 'Actual Potency of ADAMTS13 Activity [a]' = 'Actual Potency of ADAMTS13 Activity [a]' '3FRETS-VWF73 Potency of ADAMTS13 Activity' = 'FRETS-VWF73 Potency of ADAMTS13 Activity'; run; ** produce report ; %odsstart(output_id=1, useods=0); ods escapechar = "^"; options FORMCHAR="|_---|+|---+=|-/\<>*"; proc report data=finaldsc split="*" spacing=1 center nowindows wrap /*headskip*/ missing headline /*ps=42*/ /*spanrows*/ out=qctlf.&_progname.(drop=_pg _break_) ; column ("__" _pg order1 statorder &gByVars. catc paramstat1 c1 c2); define _pg / order order=internal noprint; define order1 / order order=internal noprint; define statorder / order order=internal noprint; define cohortn / order order=internal noprint; define cohort / order order=internal noprint; define &gGrpVarN. / order order=internal noprint; define &gGrpVar. / order order=internal noprint; define aperiod / order order=internal noprint; define aperiodc / order order=internal noprint; define catc / order order=internal noprint; define paramstat1 / display "" left width=75; define c1 / display style(header)= [asis=on] "TAK-755" center width=31 ; define c2 / display style(header)= [asis=on] "SoC" center width=31; break after order1 / skip; break after _pg / page; compute before _page_; line @1 "&gPageHeader. " &gGrpVarN. grpfmt. ; line @1 "Treatment Cohort: " cohortn cofmt. ; endcomp; compute before _pg; line @1 " " aperiod aprd1_.; endcomp; compute before order1; line @1 " " catc $regname./*catn catc.*/; endcomp; compute after _page_; line @1 139* '_'; endcomp; quit; %odsstop; %let list=&_progname..lst; %odsstart(bundleoptions='toc=no,BookMarkTitleStart=3', metadata=no, outname=&_progname..rtf); %collate_list(&list); %odsstop; ... View more

Hi: I'm looking to get KM stats for 25th percentile, median & 75th percentile, but can't understand what's the issue. I have 2 treatment groups instead of 3. 1 group with missing data. Below is the data and the program. Program: ods output Quartiles=quartiles; proc lifetest data=adtte1 method=KM alpha=0.05 conftype=loglog; where trtpn ^= 2; time AVAL*CNSR(1); strata trtpn/notest; run; ... View more

Hi: I have a dataset with 250 columns and would like to convert all the sas labels into variable names. How to do it? Thanks! ... View more

Hi: I would like to copy some excel files from one location to another in SAS. Can't find the best solution out there. Let's say in the source folder, I have 5 files and I want to only copy 3 files to the destination folder. The filenames are random. What is the best solution? I tried Fcopy but didn't work. Thanks, Rajesh. ... View more

How can we open .sas7bdat files using Power BI? The solution I know is to convert to .csv files. What are the other ways? Does .xptfile work during import?   Thanks, Rajesh. ... View more