topic Re: import an undifine-name file in SAS Procedures

import an undifine-name file

Mike_Davis — Mon, 29 Jul 2013 19:17:24 GMT

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 — Mon, 29 Jul 2013 19:21:33 GMT

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

Mike_Davis — Mon, 29 Jul 2013 19:27:17 GMT

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 — Mon, 29 Jul 2013 19:31:12 GMT

Try the * then.

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

Mike_Davis — Mon, 29 Jul 2013 19:41:35 GMT

Thanks!

It works well!

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

GeorgeSAS — Fri, 05 May 2017 22:06:01 GMT

got you