BookmarkSubscribeRSS Feed
Mike_Davis
Fluorite | Level 6

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

5 REPLIES 5
Reeza
Super User

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

Mike_Davis
Fluorite | Level 6

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
Super User

Try the * then.

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

Mike_Davis
Fluorite | Level 6

Thanks!

It works well!

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

GeorgeSAS
Lapis Lazuli | Level 10

got you

sas-innovate-2024.png

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.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 5 replies
  • 1008 views
  • 3 likes
  • 3 in conversation