Desktop productivity for business analysts and programmers

Add new variable

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 7
Accepted Solution

Add new variable

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,


Accepted Solutions
Solution
‎07-08-2011 10:52 AM
Trusted Advisor
Posts: 2,114

Add new variable

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

View solution in original post


All Replies
Solution
‎07-08-2011 10:52 AM
Trusted Advisor
Posts: 2,114

Add new variable

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

Occasional Contributor
Posts: 7

Add new variable

Thanks this helped greatly!

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

Trusted Advisor
Posts: 2,114

Add new variable

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.

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 181 views
  • 0 likes
  • 2 in conversation