The DHS Program User Forum: Dataset use in Stata

Home » Data » Dataset use in Stata » Multiple rows same person (Layout when inporting excel data to Stata)

Show: Today's Messages :: Show Polls :: Message Navigator

Multiple rows same person [message #22445]

Fri, 12 March 2021 12:29

Joshua Lister
Messages: 1
Registered: March 2021

Member

Hi,

I ran a survey where each respondent answered 18 questions. I have it in excel so that each 18 rows of data describes the responses of 1 person (which is what I want). As I put the first column as the 'Response_ID', is it important to have all 18 questions associated with the same person with the same 'response ID', or is it better that each row has a different response ID despite being the same person? (When importing into Stata) thanks.

Report message to a moderator

Re: Multiple rows same person [message #22446 is a reply to message #22445]

Fri, 12 March 2021 12:50

waqas
Messages: 35
Registered: June 2015
Location: Islamabad, Pakistan

Member

On my understanding of IDs making.

IDs are important to produce to identify respondents of questionnaire modules.

For each person the ID remains same in respondent ID column but for multiple questions the name of variable are mostly differentiated by putting $ symbol and then option number.

According to your description, forate of your data file seems verticle. But f=generally these are in horizontal formate.

If your expain more on your research question, i may be able to assist you better.

Regards.

Waqas Imran

Report message to a moderator

Previous Topic:	HIV and Household Data
Next Topic:	Myers blended index

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Dec 19 08:06:47 Coordinated Universal Time 2024