Hi All, I understand there is an abundance of tutorials and guides for SAS, so I apologise for this question as I'm sure if I kept digging that I'd find a solution. Unfortunately, I am a first-time user of SAS on a very tight timeline, and I would really appreciate some feedback on this request: I have 75,000 .xml files located in a few folders and subfolders. Nothing is zipped. Each file has been created/structured in the same way – a large number of columns (100+) and a lot of rows (500+). Each file only uses 1 sheet in Excel. I need to use SAS to sort the data into something more understandable. Right now, it’s all chopped up into these 75,000 files so I can’t isolate, for example, one column to see what’s happening with it because that would mean opening 75,000 files independently. I have no knowledge in SAS, so even importing the files appears challenging. I have SAS 9.4 installed. After attempting to import even one file, SAS doesn’t seem to accept .xml files (through the File, Import method). I then changed the extension of a file to .xls and that also didn’t work (because I assume that I actually didn’t change the file type by simply changing the extension). Do you have any ideas as to how I can import data from 75,000 files that are in .xml format without individually importing each one? After reading, I realised this is useful for importing a single .xml file: SAS(R) 9.4 XML LIBNAME Engine: User's Guid However, I obviously cannot do that for 75,000 files in the short time I have. I would really appreciate some help in hopefully simple terms! Cheers!
... View more