IRI/Education Analytics 101-3: SAS PROC SQL

Perhaps, the next important skills within the IRI component is the ability to write SQL code in SAS. There has been many discussions the plus and minus of SQL and SAS PROC SQL. Knowing both tools will not hurt, but applying SQL for certain task is more difficult and cumbersome than using SAS SQL. SAS has developed certain PROCs to accomplish certain tasks. Therefore, one won’t need to write line of SQL codes to accomplish such tasks. One obvious example is on writing modeling codes equivalent to SAS PROC Arima. One can find several papers below to know and learn more about SAS PROC SQL. To learn more about SAS PROC SQL, please click here.