topic Proc report in SAS Procedures

Proc report

Mudassir68 — Mon, 23 Dec 2019 12:13:08 GMT

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

Re: Proc report

Kalind_Patel — Mon, 23 Dec 2019 12:52:58 GMT

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.

Re: Proc report

ballardw — Tue, 24 Dec 2019 15:13:27 GMT

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?'