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
Will there be more than one file with that naming convention?
Have you tried a wildcard, * instead of multiple question marks?
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
Try the * then.
infile "C:\myfile\my_txt*.txt";
Thanks!
It works well!
and if there were more than one file start with it, SAS can read them into one dataset .
got you
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 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.