topic IMPORTIG TEXT FILES IN OHTER WAYS.... in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/IMPORTIG-TEXT-FILES-IN-OHTER-WAYS/m-p/48259#M13038 <HTML><HEAD></HEAD><BODY><P> How about proc sql pass through?</P></BODY></HTML> Thu, 29 Mar 2012 14:18:51 GMT sassharp 2012-03-29T14:18:51Z IMPORTIG TEXT FILES IN OHTER WAYS.... https://communities.sas.com/t5/SAS-Procedures/IMPORTIG-TEXT-FILES-IN-OHTER-WAYS/m-p/48255#M13034 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: comic sans ms,sans-serif; font-size: 18pt;">Is it possible to Import a text file by using proc sql???? </SPAN></P></BODY></HTML> Thu, 29 Mar 2012 10:04:12 GMT https://communities.sas.com/t5/SAS-Procedures/IMPORTIG-TEXT-FILES-IN-OHTER-WAYS/m-p/48255#M13034 kuridisanjeev 2012-03-29T10:04:12Z IMPORTIG TEXT FILES IN OHTER WAYS.... https://communities.sas.com/t5/SAS-Procedures/IMPORTIG-TEXT-FILES-IN-OHTER-WAYS/m-p/48256#M13035 <HTML><HEAD></HEAD><BODY><P> I guess not. I have never heard of that. Have you heard somewhere?</P></BODY></HTML> Thu, 29 Mar 2012 10:07:47 GMT https://communities.sas.com/t5/SAS-Procedures/IMPORTIG-TEXT-FILES-IN-OHTER-WAYS/m-p/48256#M13035 manojinpec 2012-03-29T10:07:47Z IMPORTIG TEXT FILES IN OHTER WAYS.... https://communities.sas.com/t5/SAS-Procedures/IMPORTIG-TEXT-FILES-IN-OHTER-WAYS/m-p/48257#M13036 <HTML><HEAD></HEAD><BODY><P>YES..</P><P></P><P>i had faced this this question in&nbsp; one interview..... </P></BODY></HTML> Thu, 29 Mar 2012 10:09:55 GMT https://communities.sas.com/t5/SAS-Procedures/IMPORTIG-TEXT-FILES-IN-OHTER-WAYS/m-p/48257#M13036 kuridisanjeev 2012-03-29T10:09:55Z IMPORTIG TEXT FILES IN OHTER WAYS.... https://communities.sas.com/t5/SAS-Procedures/IMPORTIG-TEXT-FILES-IN-OHTER-WAYS/m-p/48258#M13037 <HTML><HEAD></HEAD><BODY><P> Well, then it must a misunderstanding, or the interviewers bad.</P><P>There is no support in SAS SQL to import external files. </P><P>SQL can however read data that is available via an ACCESS engine, such as Excel.</P><P>You use the data step or PROC IMPORT for importing, then use SQL for whatever you want to do with the data.</P><P>I believe that other RDBMS does support some kind of extensions to SQL for importing external data.</P></BODY></HTML> Thu, 29 Mar 2012 10:15:37 GMT https://communities.sas.com/t5/SAS-Procedures/IMPORTIG-TEXT-FILES-IN-OHTER-WAYS/m-p/48258#M13037 LinusH 2012-03-29T10:15:37Z IMPORTIG TEXT FILES IN OHTER WAYS.... https://communities.sas.com/t5/SAS-Procedures/IMPORTIG-TEXT-FILES-IN-OHTER-WAYS/m-p/48259#M13038 <HTML><HEAD></HEAD><BODY><P> How about proc sql pass through?</P></BODY></HTML> Thu, 29 Mar 2012 14:18:51 GMT https://communities.sas.com/t5/SAS-Procedures/IMPORTIG-TEXT-FILES-IN-OHTER-WAYS/m-p/48259#M13038 sassharp 2012-03-29T14:18:51Z