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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: