Measure Subject (N=000) Age (yrs) 00 ± 00 (00) 00 (00, 00) [00,00] Gender       Male 00% (00/00)     Female 00% (00/00) Race       American Indian / Alaska Native 00% (00/00)     Asian 00% (00/00)     Black / African American 00% (00/00)     Native Hawaiian / Pacific Islander 00% (00/00)     Caucasian 00% (00/00)     Other 00% (00/00) Ethnicity       Hispanic or Latino 00% (00/00)     Non-Hispanic or Latino 00% (00/00) Height (cm) 00 ± 00 (00) 00 (00, 00) [00,00] Weight (kg) 00 ± 00 (00) 00 (00, 00) [00,00] BMI 00 ± 00 (00) 00 (00, 00) [00,00] I want to make this table using the variables on the left and calculate means, standard deviation, median, min, max for continuous measures and percent and n/N for categorical variables.  Can you please help me with this?     ... View more

I need to make a demographics table with two columns: the first column is measure and the rows are age, gender, race, ethnicity, height, weight and bmi.  the second column must include numbers are mean +/- SD, median, min, max for continuous variables and Percent (count/n)   Here is the code that isn't working   %Let output = c=\Prgram\datnul.rtf; options validvarname=upcase; Proc sql; Create table demographics  (age sex race ethnicity weight height BMI); Insert into demographics (age sex race ethnicity weight height BMI); proc print width=min; run; quit;   proc datasets library=work mt=catalog; delete formats; run; quit; Proc format; value age_n 1= "age @Page @01  @order @010 @Age @\li360 N"  @N 2= "age @Page @01  @order @020 @Age @\li360 Mean(SD)" @Mean SD 3= "age@Page @01  @order @030 @Age @\li360 MINMAX" @MINMAX 4= "age @Page @01  @order @040 @Age @\li360 Median" @Median; value sex 1 = 'sex @Page @01 @order @050@ sex-n(%) @\li360 Male' 2 = 'sex @Page @01 @order @060@ sex-n(%) @\li360 Female'; value race 1 = 'race @Page @01 @order @070@race-n(%) @\li360 Caucasian' 2 = 'race @Page @01 @order @080@race-n(%) @\li360 Black or African American' 3 = 'race @Page @01 @order @090@race-n(%) @\li360 American Indian or Alaska Native' 4 = 'race @Page @01 @order @100@race-n(%) @\li360 Asian' 5 = 'race @Page @01 @order @110@race-n(%) @\li360 Hawaiian or Pacific Islander' 6 = 'race@Page @01 @order @120@race-n(%) @\li360 Other' 7 = 'race @Page @01 @order @130@race-n(%) @\li360 NA'; value ethnicity 1 = 'ethnicity  @Page @01 @order @140@ethnicity -n(%) @\li360 Caucasian' 2 = 'ethnicity  @Page @01 @order @150@ethnicity -n(%) @\li360 Black or African American' 3 = 'ethnicity @Page @01 @order @160@ethnicity -n(%) @\li360 American Indian or Alaska Native';   value height_n 1= "Height @Page @02  @order @010 @Height @\li360 N" @N 2= "Height @Page @02  @order @020 @Height @\li360 Mean(SD)" @Mean SD 3= "Height @Page @02  @order @030 @Height @\li360 MINMAX" @MINMAX 4= "Height @Page @02  @order @040 @Height @\li360 Median" @Median; value weight_n 1= "Weight @Page @02  @order @050 @Weight @\li360 N" @N 2= "Weight @Page @02  @order @060 @Weight @\li360 Mean(SD)" @Mean SD 3= "Weight @Page @02  @order @070 @Weight @\li360 MINMAX" @MINMAX 4= "Weight @Page @02  @order @080 @Height @\li360 Median" @Median;   value BMI_n 1= "BMI @Page @02  @order @090 @BMI @\li360 N" @N 2= "BMI @Page @02  @order @100 @BMI @\li360 Mean(SD)" @Mean SD 3= "BMI @Page @02  @order @110 @BMI @\li360 MINMAX" @MINMAX 4= "BMI @Page @02  @order @120 @BMI @\li360 Median" @Median; run; proc format library=work.formats cntlout=unv1st; run; data nrm1st; keep age sex race ethnicity height weight BMI; length question $96; set dm;   proc format library=work.formats cntlout=un1st; run; data nrm1st; keep trt; return; output; savtrt=trt; trt= "All"; output; trt=savtrt; return; run;   ... View more

Thank you ... View more

Hello,   I need to convert inches to cm in some of my data, it is a mixed bag of inches and cms.  my variables comor_9hgtunit_decode = says whether it is in inches or cm comor_9hgtunit  gives 1 for cm and 2 for inches comor_9hgt  = measurements in inches or cms   Here is how I approached it.   data demo2; set mergedata; If comor_9htunit then do; height_cm = comor_9ht/2.54; end; else do; height_cm =comor_9ht; end; run;   I am getting the error code WARNING: The data set WORK.DEMO2 may be incomplete. When this step was stopped there were 0 observations and 3 variables.     ... View more