Saved Bookmarks
| 1. |
Why And When Do You Use Proc Sql? |
|
Answer» Proc SQL is very convenient for PERFORMING table joins compared to a data step merge as it does not REQUIRE the key columns to be sorted PRIOR to join. A data step is more suitable for sequential observation-by-observation processing. PROC SQL can SAVE a great deal of time if u want to filter the variables while selecting or we can modify them, apply format and CREATING new variables, macro variables. as well as subsetting the data. PROC SQL offers great flexibility for joining tables. Proc SQL is very convenient for performing table joins compared to a data step merge as it does not require the key columns to be sorted prior to join. A data step is more suitable for sequential observation-by-observation processing. PROC SQL can save a great deal of time if u want to filter the variables while selecting or we can modify them, apply format and creating new variables, macro variables. as well as subsetting the data. PROC SQL offers great flexibility for joining tables. |
|