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

Join us for our biggest event of the year!

Four days of inspiring keynotes, product reveals, hands-on learning opportunities, deep-dive demos, and peer-led breakouts. Don't miss out, May 6-9, in Orlando, Florida.

 

View the full agenda.

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