Interview Questions   Tutorials   Discussions   Programs   Videos   

SAS - What is the use of proc sql?

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.

   add comment

Your answer

Join with account you already have



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!