Problem on structuring panel data
Posted: Mon Jul 23, 2012 4:09 am
Hi,
I'm good with time series, but this is my first venture into cross-section and panel data.
I have series of logins and then transactions for a 6 month period. Naturally, the number of transactions on each login varies between logins. Login is text and numbers (Lnnnnnn). Transaction is a number and I've also made unique, so if there are two with value 1021, I've changed second to 1021.01 (fairly rare occurance)
To structure the data in Proc/Structure Resize current page (Undated with ID Series), I've entered Login and Transaction, but says "Illegal panel structure LOGIN is nested within TRANSACTION" but not sure how this can be the case, not least because Transaction is unique within whole range of workfile. Login and Transaction do uniquely identify each observation, but not quite sure what message is telling me.
Many thanks!
I'm good with time series, but this is my first venture into cross-section and panel data.
I have series of logins and then transactions for a 6 month period. Naturally, the number of transactions on each login varies between logins. Login is text and numbers (Lnnnnnn). Transaction is a number and I've also made unique, so if there are two with value 1021, I've changed second to 1021.01 (fairly rare occurance)
To structure the data in Proc/Structure Resize current page (Undated with ID Series), I've entered Login and Transaction, but says "Illegal panel structure LOGIN is nested within TRANSACTION" but not sure how this can be the case, not least because Transaction is unique within whole range of workfile. Login and Transaction do uniquely identify each observation, but not quite sure what message is telling me.
Many thanks!