topic Re: Help needed with creating new variable in SAS Programming

Help needed with creating new variable

Calvarez282 — Thu, 24 May 2018 19:32:56 GMT

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!

Re: Help needed with creating new variable

novinosrin — Thu, 24 May 2018 19:48:16 GMT

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

Re: Help needed with creating new variable

Reeza — Thu, 24 May 2018 19:52:00 GMT

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!

Re: Help needed with creating new variable

Kurt_Bremser — Fri, 25 May 2018 06:08:25 GMT

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

Re: Help needed with creating new variable

s_lassen — Mon, 28 May 2018 11:15:48 GMT

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;