The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Dataset use in Stata » Multiple rows same person (Layout when inporting excel data to Stata)
Multiple rows same person [message #22445] Fri, 12 March 2021 12:29 Go to next message
Joshua Lister is currently offline  Joshua Lister
Messages: 1
Registered: March 2021

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.
Re: Multiple rows same person [message #22446 is a reply to message #22445] Fri, 12 March 2021 12:50 Go to previous message
waqas is currently offline  waqas
Messages: 35
Registered: June 2015
Location: Islamabad, Pakistan

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.


Waqas Imran
Previous Topic: HIV and Household Data
Next Topic: Myers blended index
Goto Forum:

Current Time: Thu Feb 22 22:41:09 Coordinated Universal Time 2024