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

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

bnawrocki — Mon, 26 Jul 2021 14:30:24 GMT

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?

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

Kurt_Bremser — Mon, 26 Jul 2021 14:44:51 GMT

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

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

Reeza — Mon, 26 Jul 2021 15:05:02 GMT

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?

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

bnawrocki — Mon, 26 Jul 2021 15:46:49 GMT

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.

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

jimbarbour — Tue, 27 Jul 2021 06:01:22 GMT

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

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

bnawrocki — Thu, 29 Jul 2021 20:37:29 GMT

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!

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

Reeza — Thu, 29 Jul 2021 21:06:00 GMT

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 🙂

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

NataljaK — Tue, 03 Aug 2021 07:19:22 GMT

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

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

Reeza — Wed, 04 Aug 2021 19:19:01 GMT

FYI - Screenshots via email are not attached to posts.