topic Re: How do I run a sas program from another sas program in SAS Viya? in SAS Viya

How do I run a sas program from another sas program in SAS Viya?

Ryanb2 — Wed, 07 Feb 2024 06:31:31 GMT

I've used base SAS for 15 years and now I'm moving to Viya. In base SAS I use a lot of %include statements to run other SAS programs from a SAS program, for example:

%include 'C:/sample_sas_code.sas';

runs sample_sas_code.sas from my sas program

However, when I try using the %include statement in Viya to run code I stored in my snippets folder I keep getting "ERROR: physical file does not exist". I right click on the SAS program and select "insert as path" so I'm pretty sure the path is correct. I'm guessing this is common knowledge but I've been googling this for a while and haven't been able to find the right word combination to find out how to achieve this in SAS Viya. I've seen mention that %include doesn't work in Viya but maybe just not in CAS(?). Is there someone who can point me in the right direction?

Re: How do I run a sas program from another sas program in SAS Viya?

BrunoMueller — Wed, 07 Feb 2024 07:50:16 GMT

You have stored your SAS program in a SAS Content folder. In order to access files from this location, you will need to use a FILENAME statement with a specific file access method. See this example below.

filename mypgm filesrvc folderpath="/Users/<your-userid>/My Folder/My Snippets";
%include mypgm(simple);

See the doc about FILESRVC for more information. Make sure you look at the SAS Viya version that you use.

Re: How do I run a sas program from another sas program in SAS Viya?

Ryanb2 — Wed, 07 Feb 2024 16:53:08 GMT

Thanks for the reply BrunoMueller.

I tried the code exactly as you provided after replacing my userid (see below) but I'm getting an error message when running the filename statement:

ERROR: Folder denoted by path '/Users/ryanb/My Folder/My Snippets' was not found.
ERROR: Error in the FILENAME statement.

filename mypgm filesrvc folderpath="/Users/ryanb/My Folder/My Snippets";

I also right clicked on the My Snippets folder and selected "insert as path" and verified I was using the correct path.

Re: How do I run a sas program from another sas program in SAS Viya?

MAGG — Wed, 07 Feb 2024 17:26:33 GMT

You are missing one argument

filename mypgm filesrvc folderpath="/Users/ryanb/My Folder/My Snippets" filename="your_program.sas";

filename ffile FILESRVC folderpath='your_folder_content_path' filename='your_program.sas';
%include ffile / source;
filename ffile clear;

Re: How do I run a sas program from another sas program in SAS Viya?

Ryanb2 — Wed, 07 Feb 2024 19:02:06 GMT

Thanks for your suggestion, MAGG. I tried adding the sas program as you described but I'm still getting the same error message.

Re: How do I run a sas program from another sas program in SAS Viya?

BrunoMueller — Thu, 08 Feb 2024 08:45:46 GMT

If your code is stored as a snippet, it is not a simple .sas file. But stored as a .csm file, see screenshot below.

simple.sas can be executed as shown above. The files with the .csm extension stored an XML structure that contain the code and other information.

So if you want to %include code stored in SAS Content, it is best to store it as plain SAS program code.

Re: How do I run a sas program from another sas program in SAS Viya?

Ryanb2 — Thu, 08 Feb 2024 17:35:23 GMT

Thanks for the reply BrunoMueller. I moved my code to another folder but I'm still getting the same error message. The error message indicates a problem with the path. Whether I try the filename statement with or without referencing the SAS code I get the same message so I don't think this is about the file extension. When I right click my program and select properties it has a sas extension and the type is SAS Program.

filename ffile FILESRVC folderpath='/Users/ryanb/My Folder/SAS_FILES' filename='program.sas';
%include ffile / source;
filename ffile clear;

ERROR: Folder denoted by path '/Users/ryanb/My Folder/SAS_FILES' was not found.

ERROR: Error in the FILENAME statement.

Re: How do I run a sas program from another sas program in SAS Viya?

MAGG — Thu, 08 Feb 2024 22:30:23 GMT

Could you try if you can acces a other sas-file in '/Users/ryanb/My Folder' ? So you can check you've access to the grandparent folder.

Re: How do I run a sas program from another sas program in SAS Viya?

BrunoMueller — Fri, 09 Feb 2024 08:37:23 GMT

Please add a screenshot of the Explorer pane in SAS Studio for the folder in question so that we can see what it looks like and what kind of files are in the folder. Since you could save files to this folder access permissions should be ok.

You can also add the debug=http option to the FILENAME statement to get more details on what is failing

filename mypgm
 filesrvc
 folderpath="<your-folder>"
 debug=http
;

Send the complete log.

Re: How do I run a sas program from another sas program in SAS Viya?

Ryanb2 — Sat, 10 Feb 2024 01:04:47 GMT

Thanks, BrunoMueller. I think this image includes everything you mentioned.

Re: How do I run a sas program from another sas program in SAS Viya?

Quentin — Sat, 10 Feb 2024 01:24:50 GMT

Linux paths are case sensitive.

From the screenshot, it looks like the path may be /Users/RYANB/... instead of /Users/RyanB/...

Re: How do I run a sas program from another sas program in SAS Viya?

Patrick — Sat, 10 Feb 2024 01:28:22 GMT

@Ryanb2 The code you run works in my environment. I can also replicate the error you encounter by using an invalid path.

Question: If you run below code does this return RYANB?

%put &=sysuserid;

Re: How do I run a sas program from another sas program in SAS Viya?

MAGG — Sat, 10 Feb 2024 12:36:03 GMT

You could try insert as path feature from SAS-studio. So you are sure you are rigth on the capitals

Re: How do I run a sas program from another sas program in SAS Viya?

BrunoMueller — Mon, 12 Feb 2024 08:58:47 GMT

Check the value of the SERVICESBASELURL option, using this code:

proc options option=servicesbaseurl;
run;

Does the URL match the URL used by SAS Studio? The port number might be missing from the SAS Studio URL.

Re: How do I run a sas program from another sas program in SAS Viya?

Sajid01 — Mon, 12 Feb 2024 17:14:07 GMT

Hello @Ryanb2
My understanding is that the snippets folder is a virtual folder and the contents are stored in the infrastructure data server.
You can add the snippet to an existing program or open the snippets as a program. (Place the mouse cursor and right click on the snippets folder and also on specific snippets folder. See if you can see a physical path in the properties)
What you went to achieve is something that is achievable but all depends on the way the environment at your end was set.
Do have a look at the documentation and particularly this Control SAS Studio file system access in SAS Viya 3.5 - SAS Support Communities.
Your local SAS Administrator should be able to assist.

Re: How do I run a sas program from another sas program in SAS Viya?

Ryanb2 — Mon, 12 Feb 2024 18:06:07 GMT

Thanks for the suggestion. Sorry. I was doing some masking so I doctored the image a bit. I always use the insert as path option so case and path should not be the issue.

Re: How do I run a sas program from another sas program in SAS Viya?

Ryanb2 — Mon, 12 Feb 2024 18:10:43 GMT

Thanks, BrunoMueller. I ran your code and I can see the URL in the log doesn't match the URL I currently see in my session nor does this URL include anything that looks like a port number. I'm not sure I know what to do with this information.

Re: How do I run a sas program from another sas program in SAS Viya?

Ryanb2 — Mon, 12 Feb 2024 18:12:38 GMT

Thanks, Sajid01. If running from the snippets folder is more complicated then I don't have any concerns about running from a non-snippets folder, but running from a non-snippets folders gives me the same error message.

Re: How do I run a sas program from another sas program in SAS Viya?

Sajid01 — Mon, 12 Feb 2024 18:52:59 GMT

Hello @Ryanb2
What you want to do is not complicated at all. The issue is identifying the physical location you can access.
You must seek the help of your local Admins to provide the path of physical location that you can access. Depends upon value of fileNavigationRoot in the Viya configuration.
If you click the server icon in SAS Studio V and right click. See if "properties" is listed. Typically Files and Users(This is likely to be under SAS Contents) may have a folder with your ID. These typically represent physical paths accessible in SAS Viya.

Re: How do I run a sas program from another sas program in SAS Viya?

BrunoMueller — Mon, 12 Feb 2024 20:23:35 GMT

The two urls should be the same, see the screenshot below

If they are not the same then the FILESRVC file access method is not "talking" to same SAS Viya as you are using with SAS Studio. You should contact your SAS administrator.

Which SAS Viya version are you using? Go to the top right in SAS Studio, click on the user icon and then on About.