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
C FILENAME=myFile optn in INFILE stmt.
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 ;
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.