Help needed with creating new variable

Reply
New User
Posts: 1

Help needed with creating new variable

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!

PROC Star
Posts: 1,763

Re: Help needed with creating new variable

Posted in reply to Calvarez282

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 /@KurtBremser , but  I feel bad that I don't have it. Sorry

Super User
Posts: 23,661

Re: Help needed with creating new variable

Posted in reply to Calvarez282

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!


 

Super User
Posts: 10,209

Re: Help needed with creating new variable

Posted in reply to Calvarez282

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

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
PROC Star
Posts: 260

Re: Help needed with creating new variable

Posted in reply to Calvarez282

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;

Ask a Question
Discussion stats
  • 4 replies
  • 130 views
  • 0 likes
  • 5 in conversation