topic Re: Create list of all the SAS codes and their folder in SAS VIYA 4 in Administration and Deployment

Create list of all the SAS codes and their folder in SAS VIYA 4

smm662002 — Thu, 04 Apr 2024 10:17:44 GMT

Hello,

I am using SAS VIYA LTS 2023.03.

Having admin rights, I would like to create a list of all the SAS codes and SAS job definitions available on our SAS VIYA platform. Has anyone tried that before or maybe you can help with suggestions or starting points.

Thank you,

smm662002

Re: Create list of all the SAS codes and their folder in SAS VIYA 4

joeFurbee — Thu, 04 Apr 2024 17:56:38 GMT

Hi @smm662002,

To get a list of the job definitions, you could make an API call using the Get a collection of job definitions endpoint in the Definitions API. You could then parse the JSON results in SAS using the LIBNAME Statement: JSON Engine.

I don't see an API for SAS Codes, so I'm not sure on that one.

Re: Create list of all the SAS codes and their folder in SAS VIYA 4

sbxkoenk — Thu, 04 Apr 2024 18:10:40 GMT

@joeFurbee wrote:

I don't see an API for SAS Codes, so I'm not sure on that one.

@smm662002

you want a list of all *.sas files?

Do you want

a list of all *.sas files in file system
a list of all *.sas files in SAS Content folder
a list of all *.sas files in file system AND in SAS Content folder

Koen

Re: Create list of all the SAS codes and their folder in SAS VIYA 4

smm662002 — Mon, 08 Apr 2024 09:29:09 GMT

Hi,

Thank you for your answer.

Your understanding is right, I would like an automated solution to extract all the SAS codes from:

a list of all *.sas files in file system
a list of all *.sas files in SAS Content folder
a list of all *.sas files in file system AND in SAS Content folder

Thank you,

smm662002

Re: Create list of all the SAS codes and their folder in SAS VIYA 4

sbxkoenk — Mon, 08 Apr 2024 10:24:16 GMT

For point 1 (a list of all *.sas files in file system) ...

, have a look here :
Home > Programming > Programming > How to: List all the files in a folder
https://communities.sas.com/t5/SAS-Programming/How-to-List-all-the-files-in-a-folder/m-p/674065#M202918

Look at the full topic thread (not only the solution).

Koen