topic Re: Add new column in SAS Studio 5.2 in SAS Programming

Add new column in SAS Studio 5.2

patrick85 — Wed, 11 Aug 2021 12:52:29 GMT

Hello,

Please, can someone assist me with this question. I want to add another column to my data set in sas studio which has 138435 observations and 22 variables. I would like the new column to be the 23 variable.

Re: Add new column in SAS Studio 5.2

PaigeMiller — Wed, 11 Aug 2021 13:06:18 GMT

If you want code, here is an example:

data want;
     set have;
     twenty_third_variable=temperature_celsius*9/5 + 32; /* or any other value you want */
run;

If you want to do this via menus only, then I defer to others.

Re: Add new column in SAS Studio 5.2

jimbarbour — Wed, 11 Aug 2021 14:22:07 GMT

Can you tell us the source of the column? Will it be from another SAS dataset? Is it based on a calculation (as in @PaigeMiller's response)? Is it from a file? A database? How will you obtain this value?

Adding a new column to a SAS dataset is pretty easy. Say you have an existing data set, let's call it "Have." If you want to add a column to the data, one way is a Data step, for example, the below. In my existing data, if I have a column named "Centimeters" but I want a new column called "Inches," I can create a new column by using the standard conversion formula as shown.

Data Want;
    Set Have;
    Inches = Centimeters / 2.54;
Run;

The output of the above Data set will be a new dataset named "Want". The new data set will be a copy of Have but will have a new column added to, a column named "Inches."

Jim

Re: Add new column in SAS Studio 5.2

Reeza — Wed, 11 Aug 2021 14:36:59 GMT

Here's a video tutorial on how to add a new column:
https://video.sas.com/detail/videos/sas-analytics-u/video/4573023399001/creating-a-new-column-in-sas?autoStart=true&page=1

Re: Add new column in SAS Studio 5.2

PaigeMiller — Wed, 11 Aug 2021 14:51:49 GMT

To re-phrase @jimbarbour comments into Paige-speak:

Be specific. By providing more information and specific information, you will get faster and better answers.

General and vague questions get general and vague answers. Specific questions get specific answers.

Re: Add new column in SAS Studio 5.2

patrick85 — Thu, 12 Aug 2021 07:51:27 GMT

Thank you