topic Re: Reading Data in SAS Programming

Reading Data

ZosTa — Tue, 25 Sep 2018 12:52:30 GMT

Dear SAS Users

I'm asked to research on "how to read a text file in SAS when a folder name is known but the file name is unknown". I checked all my notes but nothing is coming from there.

Re: Reading Data

VDD — Tue, 25 Sep 2018 12:59:21 GMT

you could use members to create a SAS dataset list of files that are in the folder. Then use infile within a data step and read in all those text files into SAS datasets. You should request a record layout for the text files so that the information is consistence for interpretation.

Re: Reading Data

RW9 — Tue, 25 Sep 2018 12:59:47 GMT

Is this some sort of learning exercise? You can get a directory listing (assuming you have OS access):

filename tmp pipe 'dir "c:\path\*.txt" /b';

data want;
  length tmp $200;
  infile tmp;
  input tmp $;
run;

Will get you a list of files in that folder with .txt extension. Its really a very daft question however. If you don't know what to expect, how can you program for it? Is it a delimited file, a fixed format file, or something else. What structure will it be in? What if its xml or Json? What if its not .txt extension but csv? Its a bit of a daft question, you need to fix in certain paramters and such like before you even look at coding. I.e. file transfer specs, what file, when, what structure, via what medium etc. Process documentation, how is file to be read, to what structure, where to store etc. Once documentation is in place, then code.

If of course its a learning question...

Re: Reading Data

ZosTa — Tue, 25 Sep 2018 13:31:16 GMT

Thank you for the assistance

Re: Reading Data

ZosTa — Tue, 25 Sep 2018 13:42:43 GMT

This works in a way, it only displays the names of the files. I believe the next move is to write a code that imports the files and create datasets, am I correct? Please explain the "tmp" in the code.

Thank you for the response.

Re: Reading Data

RW9 — Tue, 25 Sep 2018 14:05:47 GMT

Tmp is just short for temporary, could be called anything you like. I was only answering your question:

"I'm asked to research on "how to read a text file in SAS when a folder name is known but the file name is unknown".

That is how you get a list of filenames, from there its up to you how you import them.

What I will say, again, is that you cannot base an process on something which is unknown, it will not work. Refer to my previous post on the reasons why.

Re: Reading Data

ZosTa — Tue, 25 Sep 2018 14:16:42 GMT

Thank you