Hi all,
I need help ASAP!
I am trying to create an "Mean (SD)" variable using a separate mean and SD variables, how can I do this? I have tried many things, but it is hard to add parenthesis and still have SAS read the variable names.
Thank you!
Looks like this is your first post. So welcome to the SAS forum. Sure, you will get help but you need to provide more details. A sample of your dataset, a sample of your requirement(output) and a logic.
I wish I could show you a link that explains how to post a comprehensive question that is often shared by @Reeza /@Kurt_Bremser , but I feel bad that I don't have it. Sorry
Please post what you’ve tried so far. I would expect you to first summarize the data via PROC MEANS and then combine it using a data step (CATT) and then displaying via PROC PRINT.
There is a paper called Creating Complex Reports from Cynthia Zender that has examples with code and definitely several on here.
@Calvarez282 wrote:
Hi all,
I need help ASAP!
I am trying to create an "Mean (SD)" variable using a separate mean and SD variables, how can I do this? I have tried many things, but it is hard to add parenthesis and still have SAS read the variable names.
Thank you!
@Calvarez282 wrote:
Hi all,
I need help ASAP!
I am trying to create an "Mean (SD)" variable using a separate mean and SD variables, how can I do this? I have tried many things, but it is hard to add parenthesis and still have SAS read the variable names.
Thank you!
Short answer: don't. Use a valid SAS name (like mean_sd), consisting of letters, digits and underlines (and must not start with a digit), and put fancy names/descriptions in the label where they belong.
For detailed help how to calculate values etc, post the code you tried, example data (see my footnotes for how to do this), and the expected output/result.
If you want to name your variables in non-standard ways, you will have to quote the names like this:
'Mean (SD)'n=<whatever expression you use to calculate it>;
Also, you will have to set
option validvarname=ANY;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.