how it applying

[thanikondharish]

proc sql ;

libname ss 'pathname' ;

quit;

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

[VDD]

@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.

[SuryaKiran]

Hello,

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

[cosmid]

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.

[novinosrin]

"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.

---

[cosmid]

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

[ballardw]

---

@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.

[cosmid]

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