Help using Base SAS procedures

IMPORTIG TEXT FILES IN OHTER WAYS....

Reply
Super Contributor
Posts: 276

IMPORTIG TEXT FILES IN OHTER WAYS....

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

Frequent Contributor
Posts: 139

IMPORTIG TEXT FILES IN OHTER WAYS....

Posted in reply to kuridisanjeev

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

Super Contributor
Posts: 276

IMPORTIG TEXT FILES IN OHTER WAYS....

Posted in reply to manojinpec

YES..

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

Super User
Posts: 5,431

IMPORTIG TEXT FILES IN OHTER WAYS....

Posted in reply to kuridisanjeev

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.

Data never sleeps
Frequent Contributor
Posts: 110

IMPORTIG TEXT FILES IN OHTER WAYS....

How about proc sql pass through?

Ask a Question
Discussion stats
  • 4 replies
  • 217 views
  • 3 likes
  • 4 in conversation