topic Re: creating a library without using libname statement in SAS Programming

creating a library without using libname statement

rohithverma — Wed, 27 Nov 2019 10:47:06 GMT

Is it possible to create a library without using libname statement in sas and also without using the options in menu bar ??

Re: creating a library without using libname statement

ed_sas_member — Wed, 27 Nov 2019 11:02:11 GMT

Hi @rohithverma

What is the purpose of the question? For example, do you want to call macros automatically?

Re: creating a library without using libname statement

rohithverma — Wed, 27 Nov 2019 11:16:04 GMT

I just want to know is there any way of creating a library without using LIBNAME statement as I have faced this question in one my interview recently. Thank you

Re: creating a library without using libname statement

Ksharp — Wed, 27 Nov 2019 11:32:20 GMT

Do you mind using libname() function in data step ?

Re: creating a library without using libname statement

Amir — Wed, 27 Nov 2019 11:33:04 GMT

You could consider using the libname() function (not statement) as detailed in the documentation:

http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000212079.htm

Kind regards,

Amir.

Re: creating a library without using libname statement

LinusH — Wed, 27 Nov 2019 11:33:56 GMT

Assigning SAS Libraries Using Environment Variables:

https://go.documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.5&docsetId=hostwin&docsetTarget=p1janotyd8q0qrn1jhkin21462in.htm&locale=en#p098mcci0eoeavn1pn1dozgei42d

Re: creating a library without using libname statement

Amir — Wed, 27 Nov 2019 11:40:19 GMT

If the organisation who interviewed you use SAS on the Mainframe then allocating a library through JCL (Job Control Language) might also be an option.

Amir.

Re: creating a library without using libname statement

Kurt_Bremser — Wed, 27 Nov 2019 12:23:29 GMT

@Amir wrote:

If the organisation who interviewed you use SAS on the Mainframe then allocating a library through JCL (Job Control Language) might also be an option.

Amir.

Which is basically the mainframe version of using environment variables.

Re: creating a library without using libname statement

Tom — Wed, 27 Nov 2019 14:44:56 GMT

@Kurt_Bremser wrote:

@Amir wrote:

If the organisation who interviewed you use SAS on the Mainframe then allocating a library through JCL (Job Control Language) might also be an option.

Amir.

Which is basically the mainframe version of using environment variables.

Yes, but you have it backwards. I am sure that SAS's support of environment variables in other operating systems was created to mimic how they used DDnames on IBM mainframes.

Re: creating a library without using libname statement

Kurt_Bremser — Wed, 27 Nov 2019 14:49:01 GMT

Absolutely. Mainframe SAS predates everything else, and the direct use of DD's in code (COBOL, PL/1) is standard on a MF.

Re: creating a library without using libname statement

ballardw — Wed, 27 Nov 2019 15:39:32 GMT

@rohithverma wrote:
I just want to know is there any way of creating a library without using LIBNAME statement as I have faced this question in one my interview recently. Thank you

One way that is not really recommended but will work in SAS Foundation at least if your operating system has the correct associations for the SAS files: Double click to open a dataset file from something like the Windows Explorer or similar tool. SAS will create a library such as TMP1, the digit will likely increment if done to sets in different locations, to display the data set.

You may find this also happens when downloading a data set from the web depending on your browser or the source (like this forum).