Saved Bookmarks
| 1. |
What Types Of Programming Tasks Do You Use Proc Sql For Versus The Data Step? |
|
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 u can modify them …apply format….creating new variables , macro variables…as well as SUB setting 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 u can modify them …apply format….creating new variables , macro variables…as well as sub setting the data.PROC SQL offers great flexibility for joining tables. |
|