BookmarkSubscribeRSS Feed
krishray09
Calcite | Level 5

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

 

 

1 REPLY 1
ChrisNZ
Tourmaline | Level 20

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.

 

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 845 views
  • 0 likes
  • 2 in conversation