LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (October 2002)Back to main SPSSX-L pageJoin or leave SPSSX-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Wed, 30 Oct 2002 18:59:30 -0500
Reply-To:     Art@DrKendall.org
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         "Arthur J. Kendall" <Arthur.Kendall@VERIZON.NET>
Subject:      Re: Syntax to fill blank data
Comments: To: Mahbub Khandoker <Mahbub_Khandoker@camh.net>
Content-Type: text/plain; charset=us-ascii; format=flowed

Try this syntax to see if it answers your question.

new file. data list fixed /ID 1-2 Age 9-10(A). begin data 01 31 02 32 03 04 33 05 65 06 07 60 end data. list.

missing values age(' '). value labels age ' ' 'unknown'. frequencies vars=age.

new file. data list fixed /ID 1-2 Age 9-10(A). begin data 01 31 02 32 03 04 33 05 65 06 07 60 end data. list. recode age(' '= '-1')(else=copy). missing values age('-1'). value labels age '-1' 'unknown'. frequencies vars=age.

Hope this helps.

Art Art@DrKendall.org Social Research Consultants University Park, MD USA

Mahbub Khandoker wrote:

>Thanks Arthur and it's work. >But when the variable is string than that syntax does not work. >Do you have any more way to do that for string variable? >Thanks. >Mahbub > >-----Original Message----- >From: Arthur J. Kendall >To: Mahbub Khandoker >Cc: SPSSX-L@VM.MARIST.EDU >Sent: 30/10/02 5:08 PM >Subject: Re: Syntax to fill blank data > >Does this address your question? cut and paste the following syntax and >observe the output. >*if you just read the data in via list or fixed format the blanks will >be system missing. >*you can then recode it to user missing and assign a value label. >new file. >data list list /ID Age. >begin data >01 31 >02 32 >03 >04 33 >05 65 >06 >07 60 >end data. >list. > >new file. >data list fixed /ID 1-2 Age 9-10. >begin data >01 31 >02 32 >03 >04 33 >05 65 >06 >07 60 >end data. >list. >recode age (sysmis = -1) (else=copy). >missing values age(-1). >value labels age -1 'unknown'. >list. > >* or you can tell SPSS to treat blank fields as as specific value >(commonly zero or -1) and define that value as user missing. >new file. >set blanks = -1. >data list fixed /ID 1-2 Age 9-10. >begin data >01 31 >02 32 >03 >04 33 >05 65 >06 >07 60 >end data. >missing values age(-1). >value labels age -1 'unknown'. >list. > >Hope this helps. > >Art >Art@DrKendall.org >Social Research Consultants >University Park, MD USA > >Mahbub Khandoker wrote: > > > >>Hi there, >>I have a SPSS data file with some data are missing. How can I fill the >>blank filed by syntax? >>For example, >> >>ID Age >>01 31 >>02 32 >>03 >>04 33 >>05 65 >>06 >>07 60 >> >>I want to fill this blank age as sysmiss or "Unknown". >>Thanks in advance. >>Mahbub Khandoker >> >> >> >> >> > > > > > >


Back to: Top of message | Previous page | Main SPSSX-L page