That's really helpful, Reeza-thank you! When I code: %let covar_list1 = fns parent_revenue firm_employees_parent1  ;   /*edit covar list here: parent_revenue firm_employees_parent1 N*/ proc means data=sample stackods nway n mean std; class estabgroup ; var &covar_list1.; ods output summary=mean_estabgroup; run; I get : Do you know if there is a way I can get the pooled mean for each covariate as well (instead of only the mean at each level of estabgroup?) Thank you for your time and help ... View more

Thanks, RW9!  To be clearer: My input dataset for the DATA step is a proc tabulate output dataset in the following form:                                                    Obs   estabgroup      N     fns_Mean   fns_Std    1      amp        46306      .         .          .    2      hih        39270      .         .          .    3      nur        11606      .         .          .    4      sst         4840      .         .          .    5                102022      .         .          .    6      amp            .    40.8703     .        40.8703    7      hih            .    44.0349     .        44.0349    8      nur            .    82.7968     .        82.7968    9      sst            .    82.7768     .        82.7768   10                     .    48.5631     .          .   11      amp            .      .       49.3312      .   12      hih            .      .       51.7005      .   13      nur            .      .       64.1790      .   14      sst            .      .       68.1879      .   15                     .      .       55.0111      . Problem-solve1: In the data step below I'm trying to create an analysis variable called estabgroup_&level._fns for each level/valid value of estabgroup (i.e. amp, hih, nur, and sst) which is the concatenation of the mean and std(for standard deviation) variable. Problem-solve2: After creating the mean/std analysis variable for each of the four levels of estabgroup (estabgroup_amp_fns, estabgroup_hih_fns, estabgroup_nur_fns, estabgroup_sst_fns,), I want to create mean/std variables at each of the four levels of estabgroup for n number of covariates.  Right now, I haven't introduced that I'll have n number of covariates; I've just let the macro variable covar=fns, the first covariate. But currently my code (previous post) produces the following output, where mean and standard deviation aren't concatenated properly. Problem-solve3: How would I create the mean/std concatenated variable so that it displays as follows:  for each level of estabgroup, estab_amp/sst/nur/hih_fns=fns mean where level=amp/sst/nur/hih (fns std where level=amp/sst/nur/hih)? Ideas? Many thanks for your time and help in advance ... View more

It looks like proc tab can't actually combine statistics in a cell using punctuation. So I ll switch to proc report. Thanks to you both! ... View more

Thanks ballardw!  This was what I was looking for. I'm looking to combine the mean and standard deviation statistics into one cell:  if I wasn't using proc tab, I may have used the concatenation operator to combine a mean var and a std deviation var.  With proc tab, however, I'm not sure:  I see proc tab has an option to remove the horizantal lines in a table.  Would you know how to display mean and standard deviation in one cell, i.e. mean (std dev)   ? Thank you very much. ... View more

Estabgroup is a character variable and I'm not allowed to it in the var statement then request a statistic apparently...  Is that how you'd interpret the following LOG messages?: 374  proc tabulate data=sample  out=tab_estabgroup (drop=_TYPE_  _PAGE_  _TABLE_); 375 376  var Firm_employee_n estabgroup; ERROR: Variable estabgroup in list does not match type prescribed for this list. 377  table Firm_employee_n*(mean std), estabgroup*N ; 378  run; Alternative code 369  proc tabulate data=sample  out=tab_estabgroup (drop=_TYPE_  _PAGE_  _TABLE_); 370  class  estabgroup ; /*edit covars here*/ 371  var Firm_employee_n; 372  table Firm_employee_n*(mean std), estabgroup*N ; 373  run; ERROR: There are multiple statistics associated with a single table cell in the following nesting :        firm_employee_n * Mean * estabgroup * N. ERROR: There are multiple statistics associated with a single table cell in the following nesting :        firm_employee_n * Std * estabgroup * N. ... View more

Thanks for elaborating on how you use proc tabulate, ballardw--it's helpful advice.  Question:   My understanding was I should be able to combine frequencies and statistics in proc tabulate.  However, my current proc tab step doesn't produce a row of Ns (frequencies) for the estabgroup variable.  Would you know why? proc tabulate data=sample  out=tab_estabgroup (drop=_TYPE_    _PAGE_    _TABLE_); class  estabgroup ; /*edit covars here*/ var Firm_employee_n; table Firm_employee_n*(mean std), estabgroup ; run; ... View more

Thanks for problem solving, Reeza!  I got the output window table to export this way ... View more

Thanks ballardw! The proc tabulate code you guided me to use is what I was looking for. In my SAS Ouput window, the table dimensions appear as expected but not in ODS tagsets excel--would you have an idea why this is? code proc tabulate data=sample  out=tab_estabgroup (drop=_TYPE_    _PAGE_    _TABLE_); class  estabgroup ; /*edit covars here*/ var Firm_employee_n; table Firm_employee_n*(mean std), estabgroup ; run; ods ods tagsets.excelxp file='S:\Projects\DOL OSHA EVAL\Output\Pilot Study\Baseline_descriptives_b.xls' style=journal; ods tagsets.excelxp options(sheet_name="by_estabgroup"); proc print data=tab_estabgroup noobs; run; ods tagsets.excelxp close; Output window ---------------------------------------------------------------------             |                       |                    estabgroup                     |             |                       |---------------------------------------------------|             |                       |       vv1|    vv2|    vv3|    vv4|             |-----------------------+------------+------------+------------+------------|             |firm_emplo-|   Mean       |      11|       11|       11|       11|             |yee_n      |-----------+------------+------------+------------+------------|             |                      |Std        |               11|       11|      11|       11|             ----------------------------------------------------------------------------- But in the Excel output the estabgroup and firm_emp... var are switched.  I'm not sure why--would you know? estabgroup firm_employee_n_Mean firm_employee_n_Std vv1 11 11 vv2 11 11 vv3 11 11 vv4 11 11 ... View more

Thanks ballardw! proc tabulate is looking like the better option. Do you know if proc tabulate can create an output dataset? Also, when I use the following code proc tabulate data=sample; class Firm_employee_n ; /*edit covars here*/ var Firm_employee_n*(mean std); table Firm_employee_n, estabgroup ; run; The log error says : 202  var Firm_employee_n*(mean std);                         -                         22                         200 ERROR 22-322: Syntax error, expecting one of the following: a name, ;, -, /, :, _ALL_, _CHARACTER_,               _CHAR_, _NUMERIC_. ERROR 200-322: The symbol is not recognized and will be ignored. Do we know why this is ? ... View more