@prakash8813 wrote:
Thanks... dbms=xlsx is working in SAS studio.
But i can't see its aletrnate infile statement. i.e. whenever we run proc import , sas automatically generate its aletrnate infile data step code.
But in this case there is no such infile datastep in log. why so?
The .xlsx format is basically XML (stored with zip compression). SAS can treat that (with the right XML map) like a database, while OTOH directly reading with a datastep would render very complex code (the data has to be read like a stream, and the tags need to be resolved as they come; the data step is best suited for text files that deliver data one line per item)
So, proc import here works as if you defined a libname on the Excel file and read from that, leaving data conversion to the XLSX libname engine.
... View more