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
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.