Interview Questions   Tutorials   Discussions   Programs   Videos   

SAS - What is the use of proc sql?




329
views
asked mar September 20, 2014 06:30 AM  

What is the use of proc sql?


           

1 Answers



 
answered By vishnoiprem   0  

PROC SQL is a powerful tool in SAS, which combines the functionality of data and proc steps. PROC SQL can sort, summarize, subset, join (merge), and concatenate datasets, create new variables, and print the results or create a new dataset all in one step! PROC SQL uses fewer resources when compard to that of data and proc steps. To join files in PROC SQL it does not require to sort the data prior to merging, which is must, is data merge.

flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert