The DHS Program User Forum: India » Column labels missing in excel file after converting from SAS file

Home » Countries » India » Column labels missing in excel file after converting from SAS file (NFHS-5 Individual Recode dataset)

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

Column labels missing in excel file after converting from SAS file [message #26196]

Wed, 15 February 2023 16:12

KP
Messages: 4
Registered: February 2023

Member

Hi,

I am working on the "Individual Recode" SAS file from NFHS-5, which has 5,972 columns. I am trying to understand what each column name stands for. I tried to convert this file to an excel file (for just one observation), but in the conversion, only the column names show up, and not the column descriptions (labels). Please see images attached for how the file looks in R, and the converted version on excel. I have tried adjusting row and column widths in excel. Can anyone please help with this?

Thank you

Attachment: Excel file.png
(Size: 204.49KB, Downloaded 68 times)
Attachment: SAS file on R.png
(Size: 91.75KB, Downloaded 70 times)

Report message to a moderator

Re: Column labels missing in excel file after converting from SAS file [message #26206 is a reply to message #26196]

Thu, 16 February 2023 08:32

Bridgette-DHS
Messages: 3034
Registered: February 2013

Senior Member

Following is a response from Senior DHS staff member, Tom Pullum:

The "columns" are variables. If you import the Stata or SAS or SPSS versions of the standard recode files into R, the variables, including labels, should come through. You should not have to use Excel to view the data. There are other R users on the forum--perhaps they can help.

Report message to a moderator

Previous Topic:	Questions "wife beating": Missing values and district level info: NFHS 4 and 5 v/s NFHS 3
Next Topic:	NFHS-5 dataset interpretation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Apr 18 10:52:38 Coordinated Universal Time 2024