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 112 times)
Attachment: SAS file on R.png
(Size: 91.75KB, Downloaded 114 times)

Report message to a moderator

[Message index]

		Column labels missing in excel file after converting from SAS file By: KP on Wed, 15 February 2023 16:12
		Re: Column labels missing in excel file after converting from SAS file By: Bridgette-DHS on Thu, 16 February 2023 08:32

Previous Topic:	STATA Code for NMR
Next Topic:	NFHS-5 dataset interpretation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Mon Dec 2 17:42:22 Coordinated Universal Time 2024