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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.