topic Re: SAS Import File in SAS Programming

SAS Import File

newbi — Thu, 31 Mar 2011 13:48:16 GMT

I have following SAS code that looks for "DailySales" files and import daily sales data into SAS data set. What i would like to do is the code to search for the "DailySales" files and if it doesn't find the "DailySales" files then use the "DailyImport" file.

[pre]
Data work.DailySales ;
INFILE "C:\DailySales"
LRECL=143
ENCODING="WLATIN1"
TERMSTR=CRLF
TRUNCOVER ;
.....
[/pre]

Re: SAS Import File

Peter_C — Sun, 03 Apr 2011 02:04:37 GMT

the infile option FILEVAR= allows you to define the physical file name at runtime ( so, after you check that the file exists).
The FILEEXIST() function allows your data step to decide which to read

Re: SAS Import File

Ksharp — Wed, 06 Apr 2011 09:44:24 GMT

Hi.Another choice is to use filename + pipe.

[pre]
filename file pipe 'dir C:\DailySales /B';

data temp;
infile file truncover;
input fname $20.;
fname=coalesce(fname,'DailyImport');
......
[/pre]

Ksharp

Re: SAS Import File

newbi — Wed, 06 Apr 2011 16:39:13 GMT

Thanks for all reply. I will try both methods.

Re: SAS Import File

Ksharp — Thu, 07 Apr 2011 01:00:29 GMT

Hi.
Sorry.My code is wrong.
It is my fault that not test it. Please ignore me.

Ksharp

Re: SAS Import File

Ksharp — Mon, 11 Apr 2011 01:27:49 GMT

OK.I will give you a solution.The following code is right. I test it by myself.
[pre]
%let path=c:\;
filename fname pipe "dir &path.dailysales.txt &path.dailyimport.txt /B";
data want;
infile fname truncover;
input fname $20.;
fname="&path"||fname;
infile dummy filevar=fname end=last length=len;
do until( last);
input row $varying200. len;
output;
if last then stop;
end;
run;
[/pre]

Ksharp

Re: SAS Import File

newbi — Tue, 07 Jun 2011 14:40:34 GMT

Ksharp,

I'm using unix and getting error for using pipe:

ERROR: Insufficient authorization to access PIPE.

%let path="/mnt/data/";
filename fname pipe "/mnt/data/ &path.dailysales.txt &path.dailyimport.txt /B";

Re: SAS Import File

RMP — Tue, 07 Jun 2011 14:50:30 GMT

There could be a number of reasons. From where are you running this code? Base SAS, EGuide?

If you are running it from Eguide, it may be that the object spawner is not allowed to execute external OS commands. You will need to add a NONOXCMD to the object spawner startup command.

Just looked again at your code. What exactly are you trying to do in the PIPE statement? You are missing the DIR in the filename statement.

Message was edited by: RMP Message was edited by: RMP

Re: SAS Import File

sbb — Tue, 07 Jun 2011 17:21:54 GMT

Suggest the OP search the SAS support website for additional info.

Scott Barry
SBBWorks, Inc.

Suggested Google advanced search argument, this topic / post:

ERROR: Insufficient authorization to access PIPE site:sas.com

Re: SAS Import File

Ksharp — Wed, 08 Jun 2011 02:41:31 GMT

Under Unix, you should use ' ls ' command to check the list of directory.
But from your log, it is to say you do not have right to use PIPE functionality.
If you can ,contact with SAS Administrator, to see whether to open it for you.
If you can not ,can refer to the SAS code which used fopen() function written by SASKiWi at previous post.

Ksharp

Re: SAS Import File

Ksharp — Wed, 08 Jun 2011 03:08:49 GMT

Or you can code like this.But need to change the path into unix (/mnt/data/trans.txt)

[pre]
filename a 'c:\trans.txt';

%let a=%sysfunc(fexist(a) );

%macro imp;
%if &a=1 %then %do;
proc import datafile='c:\trans.txt' out=want dbms=tab replace;
getnames=yes;
run;
%end;
%else %do;
proc import datafile='c:\dailysales.txt' out=want dbms=tab replace;
getnames=yes;
run;
%end;
%mend imp;

%imp
[/pre]

Ksharp