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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.