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,
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
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
Thanks this helped greatly!
How can I use two variables from the dataset to create a new one? Is this possible?
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.