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 🙂 

sas-innovate-white.png

Our biggest data and AI event of the year.

Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.

Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.

 

Register now!

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