topic Re: import of a tab delimited file in SAS Studio is not working? in SAS Programming

import of a tab delimited file in SAS Studio is not working?

MaryA_Marion — Fri, 29 Oct 2021 14:53:00 GMT

hypertension exists. SAS Studio can't find it? WHy?


libname mylib '/home/u50158717/Stat.775.data';
filename hyperten 'hypertension.txt';
data hp;
infile "mylib.hyperten" DLM='09'X DSD TRUNCOVER;
input group $ NaCl;
run;

error messge in log

Re: import of a tab delimited file in SAS Studio is not working?

ChrisHemedinger — Fri, 29 Oct 2021 14:59:27 GMT

You need to include the complete path to the file in the filename statement. If you see the file in your file list, right-click and check the Properties, and copy the path from there, then add to your code:

filename hyper '/u/myfolder/hypertension.txt';

Then use the fileref in your INFILE:

infile hyper DLM='09'X DSD TRUNCOVER;

Re: import of a tab delimited file in SAS Studio is not working?

Tom — Fri, 29 Oct 2021 16:15:34 GMT

So your code has a LIBNAME statement and a FILENAME statement at the top, but your data step is not using either the libref (MYLIB) or the fileref (HYPERTEN) they defined. Instead you are looking for a file named 'mylib.hyperten' in the current working directory.

If you want to use the libref then use it in specifying the output dataset name in the DATA statement.

data mylib.hp;

If you want to use the fileref then either point it to the actual file you want and then reference the fileref in your INFILE statement. So perhaps something like:

filename hyperten '/home/u50158717/Stat.775.data/hypertension.txt';
....
infile hyperten DLM='09'X DSD TRUNCOVER;

Or you could point the fileref to a folder and then name the specific file from that folder in the INFILE statement.

filename hyperten '/home/u50158717/Stat.775.data/';
....
infile hyperten('hypertension.txt') DLM='09'X DSD TRUNCOVER;

Or skip the FILENAME statement completely and just list the full filename in the INFILE statement.

infile '/home/u50158717/Stat.775.data/hypertension.txt' DLM='09'X DSD TRUNCOVER;

Re: import of a tab delimited file in SAS Studio is not working?

Reeza — Fri, 29 Oct 2021 16:41:50 GMT

You're mixing and matching concepts here.
Libraries are for referencing SAS data sets not text files. Filename is correct for text files but you have to provide the full path.

Re: import of a tab delimited file in SAS Studio is not working?

MaryA_Marion — Fri, 29 Oct 2021 19:02:11 GMT

Two good explanations today. Thanks. I need to study your solution.

Re: import of a tab delimited file in SAS Studio is not working?

MaryA_Marion — Fri, 29 Oct 2021 19:04:20 GMT

I keep thinking that with the libname location specified that the filename will be automatically be placed in mylib. Thank you. MM