IMPORTIG TEXT FILES IN OHTER WAYS....

[kuridisanjeev]

Is it possible to Import a text file by using proc sql????

[manojinpec]

I guess not. I have never heard of that. Have you heard somewhere?

[kuridisanjeev]

YES..

i had faced this this question in  one interview.....

[LinusH]

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.

[sassharp]

How about proc sql pass through?