topic Re: Count the available measures in VA in SAS Visual Analytics

Count the available measures in VA

sh904 — Sat, 23 Oct 2021 09:57:28 GMT

Hi. Could someone please let me know how do I count the number of measures in my dataset? I am using the PVA data and I can physically count them but is there a function or anywhere where it shows how many measures are in the data? Thank you.

Re: Count the mesaures

Kurt_Bremser — Sat, 23 Oct 2021 07:07:55 GMT

Do you mean to count the non-missing values in a variable/column?

If yes, procedures SUMMARY, FREQ, TABULATE, REPORT can all calculate counts. In SQL, use count(var).

For more detailed help, post example data in usable form (data step with datalines, posted in a code box), and show what you expect to get out of it (report or new dataset).

Re: Count the available measures in VA

sh904 — Sat, 23 Oct 2021 09:58:50 GMT

Hi. No, I mean how do I know the ocunt of measures that show up in the Data tab when I go in "explore and visualize".
For example, this image (https://imgur.com/a/0o85ahl) has 6 measures that I can count on my fingers. Is there a formula that tells me that there are 6?

Re: Count the available measures in VA

Kurt_Bremser — Sat, 23 Oct 2021 09:58:22 GMT

So this is a Visual Analytics question?

Re: Count the available measures in VA

sh904 — Sat, 23 Oct 2021 09:57:55 GMT

Yes, it is.

Re: Count the available measures in VA

Kurt_Bremser — Sat, 23 Oct 2021 10:01:57 GMT

I moved this to the VA community and edited the subject lines. Since I don't use VA, someone else will need to chime in. Calling @Madelyn_SAS @Sam_SAS

Re: Count the available measures in VA

Sam_SAS — Mon, 25 Oct 2021 13:42:42 GMT

Hello,

What do you want to do with the count value? If you want to use it in calculations / filters, I believe you would need to precalculate the value in the data preparation stage by using PROC SQL or another of the procedures mentioned earlier.

If you only need to display the value in your report and you have a very recent version of VA (2021.1.1 or later) you could use the Job Content object to display the results of a SAS language job (using the same procedures such as PROC SQL.)

I am actually not completely sure if you can programmatically make the distinction between measures (numeric variables) and categories (character variables). I'm not sure if that is a requirement for you, or if a count of all columns in the data would be sufficient.

Sam

Re: Count the available measures in VA

sh904 — Tue, 26 Oct 2021 06:21:44 GMT

Thank you for your response. I just wanted to know if there is somewhere where it is shown visually, without calculations. For example, the way it shows the count of records against each category. From exploring SAS and the forums, I think it is not possible.