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?
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.