Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Home
- /
- SAS Viya
- /
- Visual Analytics
- /
- Re: SAS VA - PERCENT

- RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

☑ This topic is **solved**.
Need further help from the community? Please
sign in and ask a **new** question.

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

Posted 02-08-2024 09:03 AM
(664 views)

Hi, I need help with creating a percentage.

The initial data, is created in SAS EG, in the following way

I've created a new one - Broj klijenata - FIL, in the following way:

Now that I'm trying to calculate the percentage of Broj klijenata - FIL / Broj klijenata, I'll get the following data.

Wich is not correct.

Can someone tell me what I'm doing wrong and what I should do?

Thank you.

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

hi

can you tell me how you calculated the % data

because when i try this percentage of Broj klijenata - FIL / Broj klijenat for MESEC 01-2024

"Broj klijenata - FIL" / Broj klijenat i get 0.1590460897463151 if i format it to percentage i get 15.90460897463151 which is not the matching with the output.

I am assuming the issue is with % calculation

5 REPLIES 5

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

hi

can you tell me how you calculated the % data

because when i try this percentage of Broj klijenata - FIL / Broj klijenat for MESEC 01-2024

"Broj klijenata - FIL" / Broj klijenat i get 0.1590460897463151 if i format it to percentage i get 15.90460897463151 which is not the matching with the output.

I am assuming the issue is with % calculation

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

I'm calculating the percentage in the following way:

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

Like this?

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

I believe you need to create the calculation as an aggregated measure so that you are calculating the percentage of the aggregated (summed) data for each date.

You can create the calculation like below. Replace MPG(City) and MPG(Highway) with your variables. Let me know if that works.

**Available on demand!**

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.