topic Re: Listing contents of a catalog in SCL in SAS Programming

Listing contents of a catalog in SCL

Nieumysl — Tue, 19 Aug 2014 09:34:04 GMT

Hi!

I'm looking for a way to get all entry/object/whatever names of a catalog into a list in SCL. I must stress that I'm new to SAS, so perhaps there is an obvious solution here that I'm not seeing... .

To be exact, my catalog (sas7bcat) contains SCL files/scripts, and i would like to have an SCL list containing all the names of the SCL scripts in that catalog.

Is there any way to do this?

Thanks for any advise!

Re: Listing contents of a catalog in SCL

jakarman — Tue, 19 Aug 2014 10:17:28 GMT

Using proc catalog?

Eguide with the catalog browser added?

Using base/sas?

You can brows/edit SCL in remote connections it is also browsable. Just open is like a dataset library. No idea what your problem is.

Re: Listing contents of a catalog in SCL

Nieumysl — Tue, 19 Aug 2014 11:08:30 GMT

Thanks for answer. I dont need to display the entries anywhere. What I need is a list containing all file names as a variable in a scl program. For example: 'file1.scl file2.scl file3.scl'

Re: Listing contents of a catalog in SCL

jakarman — Tue, 19 Aug 2014 11:44:43 GMT

Base SAS(R) 9.3 Procedures Guide, Second Edition (proc catalog) google is your friend.
Remember it are no files it are members in a catalog. Having it as a SAS dataset you can get it into a list.

Re: Listing contents of a catalog in SCL

Nieumysl — Tue, 19 Aug 2014 12:07:03 GMT

thanks a lot Google is indeed a friend, provided you know what to look for - i was just looking for a way to do it in scl directly, and this hadn't occured to me. Like i said, I'm new ...

Re: Listing contents of a catalog in SCL

jakarman — Tue, 19 Aug 2014 12:15:08 GMT

perhaps it can also be done with some functions. They must be there (open dir ) getting them one for one building the list. SAS(R) Component Language 9.2: Reference (catlist) but all depends on what you are going to do. There is never just one solution.