topic Re: how it applying in SAS Programming

how it applying

thanikondharish — Thu, 10 Jan 2019 14:16:32 GMT

proc sql ;

libname ss 'pathname' ;

quit;

if i apply above program the library will form can you explain?

Re: how it applying

VDD — Thu, 10 Jan 2019 14:28:22 GMT

@thanikondharish a library does not form.

A library is assigned and that is what you have with libname ss 'pathname' ;

@thanikondharish help those that have helped you, go back to all of your unsolved questions and confirm if they were solved. You have a whole lot of questions that are very simple to answer that have been answered and are marked as not solved.

Give create to others, learn by reading and please do some searching.

Re: how it applying

SuryaKiran — Thu, 10 Jan 2019 14:35:29 GMT

Hello,

PROC SQL is part of Base SAS that is used for SQL. Please check this link to see what it can do.

Re: how it applying

cosmid — Thu, 10 Jan 2019 14:50:35 GMT

Interesting, I didn't know you could assign a lib ref within a Proc SQL step like that. Does this mean that you can pretty much use the libname statement almost anywhere? I know by convention, it's usually at the top of programming code.

Re: how it applying

novinosrin — Thu, 10 Jan 2019 14:57:26 GMT

"Does this mean that you can pretty much use the libname statement almost anywhere? "

- Libname statement is a global statement and you can use global statements anywhere in a SAS program. This applies to all global statements. Global statements are not executable; they take effect as soon as SAS compiles program statements.

With the above being said, I do not like the practice of using anywhere that causes difficulty in reading ease. Basically, the good thing is that it is flexible. That's about it

@cosmid wrote:

Interesting, I didn't know you could assign a lib ref within a Proc SQL step like that. Does this mean that you can pretty much use the libname statement almost anywhere? I know by convention, it's usually at the top of programming code.

Re: how it applying

cosmid — Thu, 10 Jan 2019 15:01:07 GMT

Thanks for the clarification! I forgot that it's a global statement.

Re: how it applying

ballardw — Thu, 10 Jan 2019 15:59:32 GMT

@cosmid wrote:

Interesting, I didn't know you could assign a lib ref within a Proc SQL step like that. Does this mean that you can pretty much use the libname statement almost anywhere? I know by convention, it's usually at the top of programming code.

The library has to be defined before use.

I consider this particular behavior one of the SAS helpful interpretations of doing what we meant and not actually coded such as the warning about misspelled keywords such as accidentally using PROG instead of PROC.

Re: how it applying

cosmid — Thu, 10 Jan 2019 16:02:34 GMT

Yes, I know it has to be defined before use. But thanks for pointing it out:)