Oh, one more option is to switch from a long data set to a wide dataset to reduce the number of rows if possible.
jen123, Your story of all that downloads and spreadsheetwork does me remember of the way it was done when lotus123 was the tool.
No dwh ideas where in place as the ict was happy they got rid of those obstinate guys wanting to do work on their data 😉 This was 30 years ago.
Nothing has changed....
Agreed Jaap. Spreadsheet Anarchy is rife in most organisations because it is the only BI tool people know. The problem with anarchy is there is no discipline or control to ensure spreadsheets are used appropriately.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.
Ready to level-up your skills? Choose your own adventure.