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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.