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-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

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