SAS proc contents all to view data in mainframe SMF record via SAS-MXG

krishray09 — Tue, 26 Oct 2021 12:02:52 GMT

Hello everyone,

I'm from Mainframe performance team and I need a basic syntax/template on how to read contents from a SAS dataset (PDB) including all fields and rows maybe for first 10 rows. For example:

Columns: Jobname Jobid system cpu wait-time etc...

Rows: xxxx ....

1. Next can we export this data to excel directly.

2. Can you share self-learning sites (free) for SAS-MXG to learn & explore.

Thank you

Re: SAS proc contents all to view data in mainframe SMF record via SAS-MXG

ChrisNZ — Wed, 17 Nov 2021 05:37:22 GMT

Use:

proc contents to see the metadata

proc print to see the data. Use data set option obs= to limit the number of rows.

proc export to send to excel.

topic SAS proc contents all to view data in mainframe SMF record via SAS-MXG in SAS Procedures

SAS proc contents all to view data in mainframe SMF record via SAS-MXG

Re: SAS proc contents all to view data in mainframe SMF record via SAS-MXG