cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
kaet78ha
‎07-07-2021
  • 3 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Proc Report space under #BYVAL header

by Calcite | Level 5 in SAS Programming
‎07-06-2021 05:32 AM
‎07-06-2021 05:32 AM
The is a proc report with a #BYVAL statement header:   ods listing close; ods &outype file="%sysfunc(pathname(out))\&outname2..&outype" style=acrsstyle &bookmk; run; proc report data=tab split='~' missing nowd style={bordertopcolor=black bordertopwidth=1}; column pgcnt COHORT SITEID SUBJECT DATE AGE_C SEX RACE_C ETHNIC WGTLB_C HGTINCH_C CBP FST PROT ; define pgcnt / order order=internal noprint; define COHORT / order order=data noprint; define SITEID / order order=internal 'Site' style(column)=[width=10% just=left asis=on font_face=&fontf font_size=&fontsz ] ; define SUBJECT / order order=internal 'Subject' style(column)=[width=11% just=left asis=on font_face=&fontf font_size=&fontsz ] ; define DATE / 'Date of Birth' style(column)=[width=7% just=left asis=on font_face=&fontf font_size=&fontsz ] ; define AGE_C / 'Age~(Years)' style(column)=[width=5% just=left asis=on font_face=&fontf font_size=&fontsz ] ; define SEX / 'Gender' style(column)=[width=5% just=left asis=on font_face=&fontf font_size=&fontsz ] ; define RACE_C / 'Race' style(column)=[cellwidth=8% just=left asis=on font_face=&fontf font_size=&fontsz ] flow ; define ETHNIC / 'Ethnicity' style(column)={width=7.5% just=left font_face=&fontf font_size=&fontsz}; define WGTLB_C / 'Weight~(kg)' style(column)={width=6% just=left font_face=&fontf font_size=&fontsz}; define HGTINCH_C / 'Height~(cm)' style(column)={width=6% just=left font_face=&fontf font_size=&fontsz}; define CBP / "Childbearing~Potential?" style(column)={width=9% just=left font_face=&fontf font_size=&fontsz}; define FST / "FST~Score" style(column)={width=8% just=left font_face=&fontf font_size=&fontsz}; define PROT / "Protocol~Version" style(column)={width=15% just=left font_face=&fontf font_size=&fontsz}; break after pgcnt / page; compute before SUBJECT ; line '' ; endcomp; by COHORT; TITLE8 justify=left 'Treatment: #BYVAL(COHORT)'; endcomp; run; ods &outype close; ods listing; The space between headline and "Treatment: #byvar" header should be removed, I've tried few things but it doesn't work:      ... View more

Proc univariate : Conf intervals for percentiles

by Calcite | Level 5 in SAS Procedures
‎06-01-2021 05:39 AM
‎06-01-2021 05:39 AM
I'm trying to calculate the following stats :  25th percentile (95% CI) Median (Weeks) (95% CI) 75th percentile (95% CI) by using proc univariate   And I'm getting the results: But I'm a little bit confused with output CI to the datset, I'm trying like:    ods select Quantiles;    proc univariate data=Sashelp.Cars ciquantnormal(alpha=.1 );    var MPG_City;    output out=a1 q1=q25 q3=q75 median=median min=min max=max lclm=lci uclm=dfd;   run; But I'm getting an error : ERROR 22-322: Syntax error, expecting one of the following: CSS, CV, GEOMEAN, GINI, KURTOSIS, MAD, MAX, MEAN, MEDIAN, MIN, MODE, MSIGN, N, NMISS, NOBS, NORMAL, P1, P10, P5, P90, P95, P99, PCTLNAME, PCTLPRE, PROBM, PROBN, PROBS, PROBT, Q1, Q3, QN, QRANGE, RANGE, SIGNRANK, SKEWNESS, SN, STD, STDMEAN, STD_GINI, STD_MAD, STD_QN, STD_QRANGE, STD_SN, SUM, SUMWGT, T, USS, VAR. I suppose I'm using the wrong way for output CI, can somebody help?    ... View more

Macro loop to get particular array

by Calcite | Level 5 in SAS Programming
‎01-05-2021 09:15 AM
‎01-05-2021 09:15 AM
For every parameter, there is needed different scope of subcategories. I'm trying to do these by getting the respective array name for the respective parameter's name in the macro loop, but I can't find the way to get the array name in the loop.    %macro arrs(j); %do i=1 %to %dim(arr.&j); category=arr1(i); output; %end; %mend arrs; data mock; length param category $200; array arr1(4) $200 ("Safety Analysis Set [a]" "Safety Run-in Set [b]" "Efficacy Evaluable Set (c)" "Immunogenity Analysis Set (d)"); array arr2(2) $200 ("Completed Study" "Discontinued Study"); array arr3(2) $200 ("Competed Treatment" "Terminated Treatment"); array arr4(6) $200 ("Death" "Lost to Follow-up" "Withdrawal by patient from study" "Termination of study by sponsor" "Completed 24 months of therapy" "Other"); do id=1 to 6; param=put(id,param.); %arrs(id); output; end; run; ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎07-07-2021 05:12 AM
Quick links