topic Re: Reading Raw Data File with Column Headings in SAS Programming

Reading Raw Data File with Column Headings

huikeng_sas — Thu, 11 Mar 2010 02:28:03 GMT

Hi,

If my raw data file (csv or fixed length file) contains column headings in the first row, can I use a infile, input statement to read in the column headings as my sas variable names?

Thanks!

Re: Reading Raw Data File with Column Headings

Doc_Duke — Thu, 11 Mar 2010 02:51:03 GMT

You can in EGuide. I'm not sure if it is easy to do in base SAS.

Re: Reading Raw Data File with Column Headings

sbb — Thu, 11 Mar 2010 03:13:24 GMT

What OS is SAS running under - can you use PROC IMPORT?

Scott Barry
SBBWorks, Inc.

Re: Reading Raw Data File with Column Headings

huikeng_sas — Thu, 11 Mar 2010 03:20:51 GMT

If customer didnt license Acc to PC File Formats, he will not be able to use proc import. So, is there a way that he can work around using infile, input statements without specifying the column names in the input statements?

Thanks!

Re: Reading Raw Data File with Column Headings

Peter_C — Thu, 11 Mar 2010 20:13:53 GMT

Nicole

except on zOS MVS-type mainframes

for a raw file, the SAS EFI accessed on the main SAS File-menu option Import-Data (aka "Import wizard" which uses proc import when needed) can help, even without licensing SAS/ACCESS to PC file formats.
I prefer a data step (simple example at http://support.sas.com/forums/thread.jspa?messageID=13449㒉 ), but you get more support and prompting from EFI.

If you need prompt support, SAS Enterprise Guide is even better. See that forum at http://support.sas.com/forums/forum.jspa?forumID=10 .

Because of the restrictions that apply to variable names, I don't dynamically load these names, just paste the list from the file into my program and use the editor to "clean up" the problems

PeterC Message was edited by: Peter.C (who forgot not all platforms have SAS EFI and proc import)