Display number of rows in SAS dataset - SAS Enterprise Guide (EG)

[bnawrocki]

In base PC SAS 9.4, I often open the Explorer window, right-click a SAS dataset, choose Properties to see the number of Rows and Columns in that dataset. But when I do the same thing in SAS EG the pop-up box doesn't show number of Rows and Columns. Why? So, is there another easy way (without running SAS code like PROC CONTENTS) to view the number of Rows and Columns in a SAS dataset in SAS Enterprise Guide?

[Kurt_Bremser]

In the Properties window, select Advanced, and you can see the number of observations.

[Reeza]

• If it's after you've created the table, the information is in the log.
• If you have the table open you can see it while you drag the slider to move down the rows (it appears as you drag the slider).
• In addition to PROC CONTENTS you could also query sashelp.vtable data set. 

---

@bnawrocki wrote:

In base PC SAS 9.4, I often open the Explorer window, right-click a SAS dataset, choose Properties to see the number of Rows and Columns in that dataset. But when I do the same thing in SAS EG the pop-up box doesn't show number of Rows and Columns. Why? So, is there another easy way (without running SAS code like PROC CONTENTS) to view the number of Rows and Columns in a SAS dataset in SAS Enterprise Guide?

---

[bnawrocki]

Thanks for your attempts at answering my question - but neither solution works for me. 

My Properties window doesn't have an "Advanced" option.

And I'm asking about datasets I haven't created - so the LOG won't help. Also, if I open the dataset in table view mode in SAS EG, I don't see the number of rows unless I scroll to the bottom, which is difficult with a large file.

I'm using SAS EG 8.3. As a specific example, I want to know how many records are in SASHELP.CARS. In PC/SAS 9.4, I can right-click SASHELP.CARS, choose Properties and see Number of Rows/Columns. But when I do the same in SAS EG 8.3, I see this, which is pretty useless. 

[jimbarbour · Accepted solution]

If you click on the Columns tab in the Properties pop up that you put a screen print of in your last post, you can see the columns but it won't give you a count.

However, if you open the dataset and click on the "Properties" icon there (1st screen shot, below), you'll see the "Advanced" option that @Kurt_Bremser mentioned (2nd screen shot, below).  If you click on Advanced, the number of rows and columns will be displayed (3rd screen shot, below).

Jim

[bnawrocki]

Ah, I see. Sorry I was so dense. I would never have guessed the "View and set properties" icon displays the number of rows (nor did I ever notice the icon itself!). It's an extra step or two, since I have to open the dataset first, but at least I can now see number of Rows. Thanks!

[Reeza]

Studio/Viya are the newer tools and are getting more user friendly every day 🙂
The standard Properties Pane in Studio is closer to what it was in Base and includes the # of rows/columns at least in SAS On Demand 🙂

[NataljaK]

Hi,
In the Properties open the Advanced
[cid:image001.png@01D78850.FD2A2D80]
Kind regards
Natalja

[Reeza]

FYI - Screenshots via email are not attached to posts.