topic Re: PROC IMPORT Problem in SAS Procedures

PROC IMPORT Problem

OS2Rules — Mon, 27 Feb 2012 15:45:53 GMT

Hi All:

When I run the following code:

filename DIRLIST pipe "dir &dircmd";

data dirlist ;

length buffer $256 ;

infile dirlist length=reclen ;

input buffer $varying256. reclen ;

run ;

Where &dircmd resolves to "p:\sas\data\input lib\*.*"

the program fails on:

Stderr output:

The system cannot find the file specified.

NOTE: 0 records were read from the infile DIRLIST.

But - if I change the space in the name to an underscore - ( input_lib ) - then the program works OK.

Is it possible to get it to work with the space in the file name?

Thanks in advance.

PROC IMPORT Problem

art297 — Mon, 27 Feb 2012 16:04:26 GMT

The following works for me:

%let dircmd=c:\art\input lib\*.*;

filename DIRLIST pipe 'dir "&dircmd"';

data dirlist ;

length buffer $256 ;

infile dirlist length=reclen ;

input buffer $varying256. reclen ;

run ;

Re: PROC IMPORT Problem

OS2Rules — Mon, 27 Feb 2012 16:09:26 GMT

Art:

How on earth did you get that to work?

you have your macro variable within single quotes....

When I try it I get:

NOTE: The infile DIRLIST is:

Unnamed Pipe Access Device,

PROCESS=dir "&dircmd",RECFM=V,LRECL=256

Stderr output:

File Not Found

Re: PROC IMPORT Problem

art297 — Mon, 27 Feb 2012 16:34:05 GMT

I got it to work NOT. I didn't check the output file. However, the following DID work:

%let dircmd=c:\art\input lib\*.*;

filename DIRLIST pipe "dir %bquote("&dircmd.")";

data dirlist ;

length buffer $256 ;

infile dirlist length=reclen ;

input buffer $varying256. reclen ;

run ;

PROC IMPORT Problem

OS2Rules — Mon, 27 Feb 2012 16:38:30 GMT

Art:

Much better.

I'm not so up on these new fangled macro functions, but that works.

Thanks again.