| Date: | Fri, 5 Oct 2001 13:29:44 -0400 |
|---|
| Reply-To: | "Baker, Harley E,, DMDCWEST" <BAKERHE@OSD.PENTAGON.MIL> |
|---|
| Sender: | "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU> |
|---|
| From: | "Baker, Harley E,, DMDCWEST" <BAKERHE@OSD.PENTAGON.MIL> |
|---|
| Subject: | Re: Help |
|---|
|
| Content-Type: | text/plain |
|---|
Subhash,
Try this:
do if (sysmis(var001)).
compute var001 = lag(var001).
end if.
This will always assign the most recent non-missing value of var001 to the
current case if it is missing a value. If the current case has a value
already, it will not make a change.
Harley Baker
> -----Original Message-----
> From: Subhash Lonial [SMTP:lonial@LOUISVILLE.EDU]
> Sent: Friday, October 05, 2001 10:18 AM
> To: SPSSX-L@LISTSERV.UGA.EDU
> Subject: Help
>
> I have spss 10.0 data set , 50 variables and 60,000 observations. Two
> variables of interest are var001 (numerical) and var002 (four character
> string).
> var001 var002
> 1 abcd
> . abcd
> . abcd
> . abcd
> 13 azcb
> . azcb
> . azcb
> . .
> . .
> I need to assign value of 1 to var001 for the next three observations and
> a value of 13 to next set of observations till the value of var001 changes
> to some other value. var001 can go from 1 to 30 and var002 can have all
> combinations.
> I tried to use a select if command but it is time consuming. Is there a
> way to use macro. I do not know macro. Any suggestion.
> Thanks.
> Subhash C. Lonial
> Professor of Marketing
> College of Business & Public Administration
> University of Louisville
> Louisville, Kentucky 40292
> Tel. 502-852-4852
> Fax. 502-852-7672
|
