Saved Bookmarks
| 1. |
What Is The Use Of Proc Sql? |
|
Answer» 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 compared 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. 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 compared 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. |
|