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.
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 ;
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 ;
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
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 ;
Art:
Much better.
I'm not so up on these new fangled macro functions, but that works.
Thanks again.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.