Proc contents should give the structure, but it shouldn't take much time. The other stats isn't available in contents nor datasets procedure. For those i sugest that you use SQL. But it requires a full table scan given the nature of your requirement. Just be sure that the SQL is sent to Hive. Try with a small table first, and use Options msglevel = I sastrace = ',,,d' SASTRACELOC = saslog; for verification.
... View more