10-03-2012 10:37 PM
The following might easily be down in several ways. But I was wondering if it can be done by using arrays specifically?
I have the following dataset:
I was hoping to keep one observation for each customer. The desired output is as follows:
I am relatively new to arrays so would greatly appreciate any suggestions.
10-03-2012 11:09 PM
Thanks for your reply. However it does not seem to work for me. I understand your point that the master and transaction dataset should be the same except that the master dataset is set to zero observations. However the output I get is the same as the initial output.
10-03-2012 11:39 PM
DN had a typo, you need to replace his 'set' with 'update' as he promoted:
update flat(obs=0) flat;
Need further help from the community? Please ask a new question.