topic Re: Importing filenames w/o use of a pipe in SAS Procedures

Importing filenames w/o use of a pipe

LB — Tue, 24 Apr 2012 19:23:55 GMT

Hello all-

I am well acquainted the use of pipes-

However is there an alt method of importing filenames?

I ask due to the fact that at some point I will have to port a program to EG.

Yes I know that I can change the registry however I don't have such permissions and even if I do-I may not have the permissions on the server.

Thanks.

Lawrence

Re: Importing filenames w/o use of a pipe

data_null__ — Tue, 24 Apr 2012 19:35:53 GMT

See function category External Files

Re: Importing filenames w/o use of a pipe

Patrick — Tue, 24 Apr 2012 23:41:38 GMT

Allowing shell escape (xcmd) is a simple tick in a box using SMC. The tick-box is "hidden" in the Workspace Server Properties under "Options/Advanced Options".

So it's a SAS Metadata change and not some client sided change of registry information.

Else: What data _null_; suggests. I recall several discussions and solutions around this question here in these forums. Searching with keywords "directory list" will bring up some of them.

May be this sample code will help: http://support.sas.com/kb/25/074.html

Re: Importing filenames w/o use of a pipe

FloydNevseta — Wed, 25 Apr 2012 11:51:34 GMT

To build on data_null_'s reply, here's something to get you started.

data _null_;

rc = filename( 'mydir', 'c:\temp' );

did = dopen( 'mydir' );

count = dnum( did );

do i = 1 to count;

filenm = dread( did, i );

putlog filenm;

end;

run;

Note that the dread function returns not only file names but directories too. You'll have to account for that.

Re: Importing filenames w/o use of a pipe

LB — Wed, 25 Apr 2012 16:57:24 GMT

Thanks all!

Esp SAS Bigot-Answer helped immensely.

Lawrence