Watch the Webinar
You will learn:
- Benefits and features of SAS Studio relative to SAS Enterprise Guide.
- How to migrate a project from SAS Enterprise Guide to SAS Studio.
- How you can start using SAS Studio.
The questions from the Q&A segment held at the end of the webinar are listed below and the slides from the webinar are attached.
Q&A
How was the SAS Enterprise Guide project brought into SAS Studio server initially?
The .EGP file must be moved to the SAS server or made available through a shared drive. Files can be uploaded into SAS Studio by right mouse clicking on folders in the explorer, provided you have proper permissions. Then in SAS Studio, right mouse click on .EGP file to import it.
Can SAS Enterprise Guide (EG) connect to SAS Studio on Viya directly? Or is any download/upload required to bring in projects from EG to Viya?
Enterprise Guide is only available on SAS version 9; SAS Studio is available on SAS version 9 and SAS Viya. To bring SAS Enterprise Guide projects into SAS Studio on version 9:
- Move the .EGP file is moved to the SAS server or access it through a shared drive
- In SAS Studio, right mouse click on .EGP file to import it.
Files can be uploaded into SAS Studio by right mouse clicking on folders in the explorer, provided you have proper permissions. If migrating to Viya, there is an import process that needs to occur, and SAS Viya needs to be at the Viya 4 level (not Viy....
When migrating to Viya 4, what is that important process that needs to be done?
.EGP files on SAS 9 need to be imported by the SAS Viya Environment Manager Application or by using command line scripting (this is typically an Administrator task) to create a SAS Viya SAS Studio flow.
Can you view a query builder as a GUI in Viya (similar to SAS Enterprise Guide)?
Yes, the SAS Studio Query Task is very similar in SAS Studio to SAS Enterprise Guide – see Query Bui...
Imagine you want to change a filter condition or a calculated column in a query builder item inside Enterprise Guide. How do you do that (where exactly, how do you locate quickly) in SAS Studio if you have migrated a SAS Enterprise Guide project to a SAS Studio Code project?
The SAS Enterprise Guide Query Builder task is one of the tasks that appears in SAS Studio with much of the same functionality – it was demonstrated in the last few minutes. You can modify queries in SAS Studio that come from SAS Enterprise Guide.
How much re-coding would you say is required to make a SAS Enterprise Guide program run in SAS Viya SAS Studio?
Very little. If you’re running the program on the SAS Viya Compute Server, typically the libname and filename statements need to be changed to point to the new locations on the Viya server. There may be other small changes to make as well.
I tried to open a SAS Enterprise Guide project in SAS Studio in SAS Viya, but it does not work. Any suggestions?
There is an import operation that is required for migrating SAS Enterperise Guide projects to SAS St.... Start small with an Enterprise Guide project that just has one or two programs in it to confirm that can conduct its migration to SAS Studio on SAS Viya. Because the architecture is different, SAS Studio must be properly configured so that items you're referencing in the directories and the names of the databases become compatible with using a browser interface. For example, if you have specifications that are pointing to your D:\ drive and that was on your laptop and Enterprise Guide knew about that, SAS Studio might not know about that. That's a configuration aspect at your site that you'll have to accommodate or alter in some way so that SAS Studio can ‘see’ your D:\ drive.
What about the formats files that are attached to SAS7BDAT files?
If you are running SAS version 9 in a server or grid deployment and using SAS Studio in that environment, there should be nothing you need to do to accommodate formats files; SAS datasets and formats should be in the same place and accessible. If you’re moving to SAS Studio on SAS Viya, formats and files will likely need to be migrated to the SAS Viya installation and accessed from there. This configuration task is conducted by SAS administrators.
When I place a SAS program into a flow, I don't see the CODE, LOG, and RESULTS options like I do when I separately create a SAS program. Is there a way to get the LOG and RESULTS to show for that program?
You have to run the program in SAS Studio in order to gain the LOG and RESULTS tabs.
I don't see an option at the top to toggle between the Visual Programmer view and the SAS Programmer view. Is that just a configuration option that I need to ask my IT folks about? Or is there a different way to toggle?
That toggle only appears in SAS Studio on SAS version 9; your environment is likely SAS Viya.
When a program is part of a flow in Studio, how do you view the log for that program? To see the log for any individual program run within the flow, is the only option to view the flow log (which captures the log for everything in the flow)? Or is there a way to view the log only for a specific program run within the flow?
Depending upon version, right mouse click on the node to see options for viewing its log, or double click on the node after it has run.
I think more people would want to move to Viya if the standalone SAS Studio for SAS version 9 wasn't so clunky. It moves to the top of the document after every save!
SAS Studio on SAS Viya has many enhancements on various versions of SAS Viya.
How do you add a Computed Column in Query Builder in SAS Studio?
Because SAS Studio 3.8 on version 9.4 does not support calculated items via its query interface, edit the generated PROC SQL to add a new computed column (review the Query Builder’s generated code and see example below). SAS Studio’s Query Builder on SAS Viya includes computed columns as a point-and-click operation.
PROC SQL;
CREATE TABLE WORK.QUERY_FOR_CARS AS
SELECT t1.Make,
t1.Model,
t1.Type,
t1.Origin,
t1.Invoice,
(t1.MSRP / t1.Invoice) AS Calculation
FROM SASHELP.CARS t1;
QUIT; RUN;
How do I locate (in a visual way) the exact point where I locate the query whose filter I'd like to change? For me, "losing" the graphic interface would be catastrophic (when you have hundreds of guide projects, it’s really fast to locate whatever in a visual tool instead of locating whatever in code).
Click on the filter tab in the query.
I'm using SAS 9 currently, but we also have a SAS Viya installation. I figure to get SAS code to run on Viya (Unix), we'd probably have to open SAS Studio on that remote Unix box to run SAS code against Unix. If I open SAS Studio as a Windows client, can I see or update SAS files on Viya?
SAS Studio operates as a browser interface; your permissions and site-specific configuration determine what you can view, read, write.
Will SAS Enterprise Guide be discontinued in the near future? Are there any EOL schemas?
https://support.sas.com/kb/33/359.html
Recommended Resources
SAS Studio Support Page
Distinguishing SAS Enterprise Guide and SAS Studio
Differences between SAS Studio in SAS 9.4 and SAS Viya
Please see additional resources in the attached slide deck.
Want more tips? Be sure to subscribe to the Ask the Expert board to receive follow up Q&A, slides, and recordings from other SAS Ask the Expert webinars.
Click image to register for webinar