Help needed with creating new variable

[Calvarez282]

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!

[novinosrin]

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

[Reeza]

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!

---

[Kurt_Bremser]

---

@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.

[s_lassen]

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;