In reply to jianlong.

Jianlong,

Regarding the "Input" issue, I've seen other processes manage this by using PROC IMPORT, which does not need to know the data schema ahead of time. Here's an example with the John Hopkins COVID data, which has periodically changed schemas over time. (No ZIP files here, just daily files for all COVID cases.)

The SAS statements don't allow for a single statement to handle a batch of files. You would need to use macro or CALL EXECUTE perhaps to iterate over a set of files, unzipping each in turn.