03-29-2012 06:15 AM
Well, then it must a misunderstanding, or the interviewers bad.
There is no support in SAS SQL to import external files.
SQL can however read data that is available via an ACCESS engine, such as Excel.
You use the data step or PROC IMPORT for importing, then use SQL for whatever you want to do with the data.
I believe that other RDBMS does support some kind of extensions to SQL for importing external data.