topic Re: Need help in a filename statement in SAS Programming

Need help in a filename statement

mnjtrana — Mon, 08 Oct 2012 16:53:58 GMT

I need helpnin a filename statement in sas.. I am using filename statement to read a file using filename statement with wildcards. Code... Filename `/dso/dsocln/hhhw/pers*.dat; However it can b poasible tht many file with same name so we want to.output the file name in sas output file. How to do.tbis? @ Alsi can we check d existence of the file matching the above naming pattern? need urgent help

Re: Need help in a filename statement

PGStats — Mon, 08 Oct 2012 17:03:57 GMT

C FILENAME=myFile optn in INFILE stmt.

Re: Need help in a filename statement

mnjtrana — Tue, 09 Oct 2012 13:30:14 GMT

Hi,

I am using filename statement to read a file using filename statement with wildcards. However it can be possible tht many file with same name so we want to.output the file name in sas output/list file. How to do this? Also can we check d existence of a file matching the naming pattern?

The Filename=variable doesn't provide any option to print the input file name in sas output/list file.

Can you please elaborate?

Here is the sample code:

FILENAME PUA "/dso/dsocln/&srce./el/out/p_pers_uug*_F201201_*.txt" ;

data PERS ;

retain

PSTYRMO "201201";

infile PUA recfm=v lrecl=413 truncover ;

input

@1 BLOCK $char387.

;

run ;

Re: Need help in a filename statement

Haikuo — Tue, 09 Oct 2012 13:54:26 GMT

Hi,

Personally I prefer to using 'pipe' plus 'filevar=' to tackle the problems like this. For infile statement and wildcard, please refer to this papter:

http://www2.sas.com/proceedings/forum2008/166-2008.pdf

and go to the section:

"ACCESSING FILE NAMES WITH ‘WILD CARDS’

HTH,

Haikuo