Is it possible to Import a text file by using proc sql????
I guess not. I have never heard of that. Have you heard somewhere?
YES..
i had faced this this question in one interview.....
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.
How about proc sql pass through?
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.