topic How to read a external file in SAS Programming https://communities.sas.com/t5/SAS-Programming/How-to-read-a-external-file/m-p/116636#M24079 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>How to read a external file in 'Macro's &amp; SQL' ?</P><P></P><P>Thanks,</P><P>Suresh</P></BODY></HTML> Wed, 16 May 2012 13:22:59 GMT Grandhi4 2012-05-16T13:22:59Z How to read a external file https://communities.sas.com/t5/SAS-Programming/How-to-read-a-external-file/m-p/116636#M24079 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>How to read a external file in 'Macro's &amp; SQL' ?</P><P></P><P>Thanks,</P><P>Suresh</P></BODY></HTML> Wed, 16 May 2012 13:22:59 GMT https://communities.sas.com/t5/SAS-Programming/How-to-read-a-external-file/m-p/116636#M24079 Grandhi4 2012-05-16T13:22:59Z Re: How to read a external file https://communities.sas.com/t5/SAS-Programming/How-to-read-a-external-file/m-p/116637#M24080 <HTML><HEAD></HEAD><BODY><P>Your question is too general to be sufficiently answered. This is my try:</P><P></P><P>1. I don't think Proc SQL has the capacity to directly read any external file, (with the exception of pass-through, as I am not so sure if you can call it external file)</P><P></P><P>2. Depending on what types of external file and whether you have SAS/ACCESS, for data step, please search 'filename' , 'infile' and libname statement using SAS online help. Each of them, if to be explained thoroughly, will take hundreds of pages.</P><P></P><P>3. for proc, please check out 'proc import'.</P><P></P><P>And you can wrap up 2,3 inside a macro at your will.</P><P></P><P>Regards,</P><P>Haikuo</P></BODY></HTML> Wed, 16 May 2012 13:31:07 GMT https://communities.sas.com/t5/SAS-Programming/How-to-read-a-external-file/m-p/116637#M24080 Haikuo 2012-05-16T13:31:07Z