BookmarkSubscribeRSS Feed
Lopa2016
Fluorite | Level 6

Hi,

 

I have the following sample dataset

 

IDPurchase DateAgeSales
362190104/01/201021990
627101704/01/201029642
391467602/01/201026955
388816704/01/201032834
388816704/01/201030616
388816704/01/201038657
328915604/01/201033322
362190130/11/201127855
627101731/05/201240381
391467611/06/201229915
388816711/06/201240972
301514128/05/201226755
451824728/05/201231415
451824713/06/201230652

 

having 3 years of data for different customers & as seen the customers ids may repeat over 2 different point in time.How is it best possible to run a predictive model given there are different point of time involved with same customer ids?

 

Would be great if you can advice.

1 REPLY 1
Ksharp
Super User

It seems it is REPEATED measure model.

Check Generalize Linear Mixed Model.

PROC GLIMMIX + RANDOM year/subject=id residual ;

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is ANOVA?

ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 1182 views
  • 0 likes
  • 2 in conversation