import an undifine-name file

[Mike_Davis]

Hello everyone!

When I try to  import a .txt file into SAS,I just know the partial characters of the file's name, that means I don't know the full name of the file.

I know the .txt file's name start with "my_txt". and location is c:\myfile .

Could anyone tell me is that possible I can import the .txt file?

data one;

infile "C:\myfile\my_txt???????.txt"; /*those ? denotes unknown characters*/

input x;

run;

Thanks!

Mike

[Reeza]

Will there be more than one file with that naming convention?
Have you tried a wildcard, * instead of multiple question marks?

[Mike_Davis]

only one file whose name start with "my_txt"

and the multiple question mark is just for show you  that place missing lots of character,I don't know what to do with it.

Thanks

[Reeza]

Try the * then.

infile "C:\myfile\my_txt*.txt";

[Mike_Davis]

Thanks!

It works well!

and if there were more than one file start with it, SAS can read them into one dataset .

[GeorgeSAS]

got you