Count the available measures in VA

[sh904]

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.

[Kurt_Bremser]

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).

[sh904]

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?

[Kurt_Bremser]

So this is a Visual Analytics question?

[sh904]

Yes, it is.

[Kurt_Bremser]

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 

[Sam_SAS]

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

[sh904]

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.