11-14-2016 08:18 PM
Dear SAS communities,
I need to generate a table of summary statistics like this attached example. Would like to use proc freq for categorical and proc ttest for continuous variables. The flexibility of switching to other procedures such as proc glm or proc npar1way is even better.
Does any one know of a easy to use MACRO for this purpose (just plug in location of dataset, desired list of variables to compare, class)?
thanks a million!
11-14-2016 08:55 PM - edited 11-14-2016 11:07 PM
Microsoft-formatted files have a built-in ability to carry unwanted and nefarious payloads.
It is very likely that no one will take the risk to look at your excel file.
11-14-2016 09:28 PM
I have a few, if you email me I can send you one. Not sure it's exactly what you want but should get you started.
You can also look for papers on lexjansen.com. These are commonly called Table 1 or Table of characteristics.
09-05-2017 07:11 AM
Pls can you email me the sas macro for table 1. my email address is email@example.com
Looking forward to hearing from you.
11-16-2016 12:12 PM
Many users here don't want to download Excel files because of virus potential, others have such things blocked by security software. Also if you give us Excel we have to create a SAS data set and due to the non-existent constraints on Excel data cells the result we end up with may not have variables of the same type (numeric or character) and even values.
has instructions on turning SAS data sets into data step code we can run to duplicate your data set.
Since your image post shows a p-value then you are apparently doing some test. What test would that be? Do you already have all those values and are just trying to show the table or do you need to generate the statistics and then show a table? If the later then you need to provide a much more detailed description of your existing data and what you are attempting to portray.