Need help in a filename statement

Reply
Contributor
Posts: 52

Need help in a filename statement

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


Cheers from India!

Manjeet
Respected Advisor
Posts: 4,640

Re: Need help in a filename statement

C FILENAME=myFile optn in INFILE stmt.

PG
Contributor
Posts: 52

Re: Need help in a filename statement

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 ;


Cheers from India!

Manjeet
Respected Advisor
Posts: 3,124

Re: Need help in a filename statement

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

Ask a Question
Discussion stats
  • 3 replies
  • 223 views
  • 0 likes
  • 3 in conversation