InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
When To Use Proc Sql? |
|
Answer» The SQL procedure supports ALMOST all the functions AVAILABLE in the DATA step for the creation of data as well as the manipulation of the data. When we compare the same result, obtained from SQL and with the Data step, PROC SQL REQUIRES LESS code and, more IMPORTANTLY it requires less time to execute the code. The SQL procedure supports almost all the functions available in the DATA step for the creation of data as well as the manipulation of the data. When we compare the same result, obtained from SQL and with the Data step, PROC SQL requires less code and, more importantly it requires less time to execute the code. |
|