BookmarkSubscribeRSS Feed
Mudassir68
Calcite | Level 5

Hi I have a dataset with 29lakh rows and 8 variables.

can i use proc report for reading this dataset with 29lakh rows and 8 variables.

I mean does it support this many rows?

Thanks

2 REPLIES 2
Kalind_Patel
Lapis Lazuli | Level 10

Proc report or any other SAS reporting procedures doesn't have row limitations,

Only thing is, your query will take a while to get results compare to small datasets.

ballardw
Super User

Once upon a time I was taught that between 60 and 80 "rows" of text depending on font size were a page. So 10,000 rows would be roughly 125 to 150 pages. Which seems way too long for most "reports" to be useful. Since 1 lakh = 100,000 you are talking about roughly 36,250 PAGES of text.

 

Who is actually going to read that?

 

If you actually mean to summarize the data down to a useable amount then likely yes. But displaying that many rows as list output the real question might be 'Why?'

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
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
  • 2 replies
  • 716 views
  • 2 likes
  • 3 in conversation