SAS Studio: Advanced Topics and What's New

[#1]

Did you miss the Ask the Expert session on SAS Studio: Advanced Topics and What's New? Not to worry, you can catch it on demand at your leisure.  Seems like it might be time to do another live session! check back soon for dates.

Watch the webinar

With SAS Studio, writing and running SAS code has never been easier. This web browser interface lets you access your data and create SAS programs wherever and whenever you need them. No installation required.

Showcasing the latest version of SAS Studio, this live webinar will explore:

• The batch submission process.
• Import data and query utilities.
• A variety of new tasks.

We’ll also focus on the software’s Visual Programmer perspective, designed for users who want to work with process flows in a project-based environment.

Q&A Session for SAS Studio: Advanced Topics and What's New

­What are the global settings that SAS Admins get modify? I am sure that there are defaults. Any feedback on the defaults /recommended changes?­

There a quite a few. Please refer to this link.

­Can you batch-submit multiple files?­

­

Yes­, the default is three per session of Studio for the Enterprise Edition and five for the single user, PC version.  The maximum is eight.

­How can I make data step/procedure wrap in 1 line with '+' sign (similar to SAS PC). Can you describe steps? 

This is not possible in SAS Studio.

­Can you run a select segment of the code or do we need to run the entire program each time? ­

­

Yes you can highlight and run only a segment of your code when you select the running man.­

­What is the difference between interactive and non-interactive button? ­

Interactive allows you to run procs that have interactive modes like PROC IML, IMSTAT procs and some of the new VIYA products. Non-interactive runs and is done. Interactive you can continue to submit statements under that proc.­

­Batch submit - it will run on the server even when I quit the browser, right?­

Yes, and you can log back on to see the progress and get the results.­

­Can a program be scheduled to run on a specific date & time?­

­

Not currently. You can export the code and schedule in an external scheduler.­

­Where does the log go?

­

Goes where the program is located­/run from.

­Can you specify a location for log and output?­

­

Yes.  You have to have Studio 3.6 and you can set it in the Preferences.

­Did you import the excel sheet from your local PC to server or it on the server?­

The import was from a server-based (Windows) directory.

­Can you set up a batch file to run multiple programs?­

­

Yes, you can use %include in a .sas file and then submit run in background­.

­Is there a version control feature in SAS Studio?­

Not true version control - more Submission History.  You can see different versions of programs and you can revert back to past versions as well as there are additional options.­

­For batch-submit multiple field, will you get separate logs for each program?­

­

Yes, one for each program submission.­

­Can you use input prompts like in EG?­

Not currently although it is on the development roadmap.  We have created some custom tasks that you can use from a repository on Github here.

Can I use Enterprise Guide Process flows in SAS Studio?

Not currently, but that is being looked at by development. You can take the code from a process flow and with some editing, run that in SAS Studio.

What version are you showing today? I don’t have some of the same options as you do.

3.6

Can I update my SAS studio without updating other parts of my SAS install?

A qualified yes.  You need to be at a certain maintenance  level of 9.4.  I will post the link to the SAS Note to the SAS Studio Community site.

I don’t have access to SAS Studio at work. Is there a way I can work with SAS Studio even though I am not a student?

Yes, as long as you don’t use it for commercial purposes, you can download and use University Edition.

­You can't see rapid predictive modeler if you don't have EM licensed though -- right?­

­

Right­.  Also, if you have an earlier version, you may not see it as a Task.

­I make a %window in my SAS code so the user can select which programs to run. However I find that  %display fails  in SAS Studio and the user never gets  the %window screen to select from.­

­

Yes, anything that attempts to open a new window will fail as SAS is running on the server, not a local PC.

­Also, the X command fails.­

X command is by default not allowed.  You can change this as an administrator.  Please refer to the SAS Studio Administrator’s Guide.

­Can I put Options XCMD in a background job?­

­

Not by default will this work.  Please see the above answer.  Also, SAS Studio does not provide anything comparable to the command line in SAS Display Manager. However, you can change some environment options by using the Preferences.  More details can be found here. 

­If the github is not allowed by our security, can we copy to an internal github?­

Yes, you could copy it to a url/repository that is not blocked.

How do I turn the 'Output' on or off? is there a toggle/option?­

Yes, Application Options, Preferences, Results and deselect Automatically open generated output data.

Recommended Resources
Course: Essential Data Analysis Using SAS Studio Tasks: A Point-and-Click Approach
Book: An Introduction to SAS® University Edition

A great resource: https://support.sas.com/software/products/sasstudio/faq/index.html­

Want more tips? Be sure to subscribe to the Ask the Expert Community Library to receive follow up Q/A, slides and recordings from other SAS Ask the Expert webinars. From the Ask the Expert Library, just click Subscribe from the orange bar underneath the list of the recent articles.

NOTE: For best results when opening the attached slides, click on the “download” icon.

[JohnJPS]

Do you know if there's anything on the roadmap for scheduling a background submission?  That would be a feature we'd love to see.

Thanks!

[AnnaBrown]

Hi @JohnJPS,

Per the thread, How can we run batch jobs in sas studio?, scheduling is planned for 2019. @AmyP_sas welcomes feedback on the idea of linking to the Environment Manager schedule module.