BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Khaladdin
Quartz | Level 8
Surely. So, I have a datasets that time period is one year. Each group represents each second for this datasets.
Rick_SAS
SAS Super FREQ

How many observations in each BY group? What do you hope to learn from your analysis?

 

Khaladdin
Quartz | Level 8
It works very well. Thanks a lot.
Khaladdin
Quartz | Level 8
each group has at least 10 observations. I will just apply state space model for a variable that I want to examine.
Rick_SAS
SAS Super FREQ

Can you summarize the improvement? Run time went from three months to ... what? Three hours?

Khaladdin
Quartz | Level 8

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 🙂