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 🙂 

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

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!

Register Now

Discussion stats
  • 20 replies
  • 3200 views
  • 3 likes
  • 4 in conversation