topic Add new variable in SAS Enterprise Guide

Add new variable

Tasha — Fri, 08 Jul 2011 13:54:15 GMT

I am new to Enterprise Guide. I am using version 4.2.

I created a project and opened a dataset. Because this dataset is pointing to a another location, I am not able to directly add a new variable to it. I'm assuming this is correct.

So, I am using Query Builder where I add all the columns and would like to add some variables with conditions.

For example:

if column1='a' then order='First';

else if column1='b' then order='Second';

So, I am creating a new varaible order.

How can I add a new variable (if-then-else statement) to an open dataset in my project?

Thanks,

Add new variable

Doc_Duke — Fri, 08 Jul 2011 14:52:43 GMT

Tasha,

You can do this with the Query Builder task. It does not modify the original data; rather it builds a new data set or view with the added column.

Click computed column and then select recode. The help should take you from there.

The SAS for Dummies (second edition) covers this and more for EGuide 4.2 and 4.3.

Doc Muhlbaier

Duke

Add new variable

Tasha — Fri, 08 Jul 2011 15:54:06 GMT

Thanks this helped greatly!

How can I use two variables from the dataset to create a new one? Is this possible?

Add new variable

Doc_Duke — Fri, 08 Jul 2011 17:45:47 GMT

It is possible, but can be more difficult.

If the result is to be numeric, you can do it as a 'formula" in the Advanced Expression part of the computed column. To do that, you need to understand how columns are created in PROC SQL (because you are now writing a SQL expression).

You could also, potentially, do it as a two step process to create an intermediate variable. This depends largely on what you want to do.