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 🙂
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!