topic Re: Import multiple XML files with "bad" names into one SAS dataset in New SAS User

Import multiple XML files with "bad" names into one SAS dataset

fordcr2 — Wed, 06 Feb 2019 14:11:42 GMT

Hello,

I am trying to import multiple text files into one SAS file from a server. I figured I needed to use a macro to do so, but the filenames are formatted like this: test-20181002-170338-230. So what I need to do is import hundreds of these files names in this format but with different numbers (ex. test-xxxxxxxx-xxxxxx-xxx) all at once.

Does anyone have any ideas on how I could do this?

Thanks!

Re: Import multiple XML files with "bad" names into one SAS dataset

RW9 — Wed, 06 Feb 2019 14:20:43 GMT

There are several options. Do a search on here and you will find lots of posts on the subject, "importing multiple csv files" is a good term to search for.

One simple option: Get a list from os using pie, then call execute a macro call or code to import the file from a datastep.

Re: Import multiple XML files with "bad" names into one SAS dataset

fordcr2 — Wed, 06 Feb 2019 14:24:16 GMT

I've found some options for importing the files but my issue is with the filenames as SAS does not like files with -'s in them. Is there an additional macro I need to use to solve this?

Re: Import multiple XML files with "bad" names into one SAS dataset

fordcr2 — Wed, 06 Feb 2019 14:25:08 GMT

I am also importing xml files, not csv.

Re: Import multiple XML files with "bad" names into one SAS dataset

RW9 — Wed, 06 Feb 2019 14:32:54 GMT

SAS has no problems importing files with "-" in at all. Just ran this fine:

data want;
  length tmp $200;
  infile "&_sasws_./temp-2010101.txt";
  input tmp $;
run;

No issues at all.

"I am also importing xml files, not csv."

Irrelevant. You are importing a text file, setup is exactly the same, just different call/engine used to read the data. Its still both text files.

Re: Import multiple XML files with "bad" names into one SAS dataset

ballardw — Wed, 06 Feb 2019 16:07:37 GMT

@fordcr2 wrote:

I've found some options for importing the files but my issue is with the filenames as SAS does not like files with -'s in them. Is there an additional macro I need to use to solve this?

Once you have string with the original name to read with you can modify that string to something SAS will accept for SAS dataset names. The example code below shows changing all of the dash to underscores which are valid in SAS dataset names.

data example;
   x='test-20181002-170338-230';
   y=translate(x,'_','-');
run;