SAS Enterprise Guide

Desktop productivity for business analysts and programmers
BookmarkSubscribeRSS Feed
NEHI
Calcite | Level 5

I am trying to mimic a pivot table from Excel into SAS VA, excel gives an option to show values as % of parent total, now SAS VA does not give that option so I would have to create a calculated column in SAS EG using proc sql code. My data does not have a unique identifier so I have to group by using mulitple columns. Attached is the screenshot of excel I am trying to mimic. Also I don't want this values as static they should change depending on the filters. EXCELCALC.png

4 REPLIES 4
jimbarbour
Meteorite | Level 14

This is the Enterprise Guide forum.  I wonder if it might be better to post this question in the Visual Analytics forum.

 

Jim

jimbarbour_0-1602116677466.png

 

NEHI
Calcite | Level 5

Hi, I am doing coding in SAS EG via proc sql tho, so shouldn't any coding related be in here? If not I can move it to get more answers

jimbarbour
Meteorite | Level 14

Ah, I see.  In that case, you're in the right place.

 

What do you need to do with your SQL?  Can you share your SQL?  And your Libname if there are any special parameters.  And your log if you're getting any errors or warnings.

 

Please use the "Insert SAS code" button; it's much easier to read.

jimbarbour_0-1602121732082.png

 

Jim

Reeza
Super User
1. You're absolutely positive that SAS VA doesn't provide an option for percentages? That seems like a large oversight IMO but it's possible.

2. If you're looking to prep your data, PROC FREQ will generate the percentages but it won't be dynamic as you've mentioned.

sas-innovate-white.png

Our biggest data and AI event of the year.

Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.

Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.

 

Register now!

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 1153 views
  • 1 like
  • 3 in conversation