Data append one-to-many

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Steve, EViews Moderator, EViews Jason

adrian_d
Posts: 44
Joined: Wed Jan 29, 2014 6:08 am

Data append one-to-many

Postby adrian_d » Fri Sep 11, 2015 6:31 am

Dear Eviews masters :)

I need your help in such a case (see attachment, Eviews 8.1):
- I want my final dataset to be structured by id variable called conversionid. In the same Eviews page I have userid which indicates which user did a conversion - in the example I left one case where there is one user who made two conversions.
- In the other Eviews page, I have information what a user was doing - in the example I left just time of event (eventdate variable).
- And now the problem - how to append the eventdate to the final dataset such that eventdate is repeated for each conversion of the same user? I did it manually to explain you what I mean precisely (page "should_look_like").
So when I just append one page to the other, I will have two rows of conversion and userid values, and 3 rows of appended eventdate. But I am interested in conversion paths, not user paths, so I need 3 rows to append to each conversion.

thanks in advance :)
adrian
Attachments
append question.wf1
(27.04 KiB) Downloaded 347 times

Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 2 guests