SAS Procedures

Help using Base SAS procedures
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.

 

sas-innovate-white.png

Our biggest data and AI event of the year.

Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.

Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.

 

Register now!

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
  • 754 views
  • 0 likes
  • 2 in conversation