How many observations in each BY group? What do you hope to learn from your analysis?
Can you summarize the improvement? Run time went from three months to ... what? Three hours?
As you advised, I run the following codes:
proc printto log="F:\mylog\log.log";
run;
proc ucm data=work
noprint;
by group;
model price:
irregular;
level;
estimate outest=work1;
run;
proc transpose data=work1 (keep=group component estimate)
out=work2;
by group;
id component;
run;
And it takes just three hours 🙂
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!Learn how to run multiple linear regression models with and without interactions, presented by SAS user Alex Chaplin.
Find more tutorials on the SAS Users YouTube channel.