Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

RE: st: Transformations

From   "Jason Payne" <[email protected]>
To   <[email protected]>
Subject   RE: st: Transformations
Date   Thu, 12 Feb 2004 09:55:49 +1100

Thank you for your help,

Is there a way to list multiple cases that dont fit a standard expression in the replace command. for example:

replace var1=1 if var2==1 or 3

I want cases 1 and 3 to have value 1 for var1, but not case 2 and rather than writing the whole syntax twice, i would like to shorten it: 

replace var1=1 if caseid==1
replace var1=1 if caseid==3

Any clues?


Jason Payne
Jason Payne
Violence, Property Crime and Drugs
Australian Institute of Criminology
GPO Box 2944 Canberra ACT 2601

E-mail: [email protected]
Tel +61 2 6260 9283 Fax +61 2 6260 9201

Visit the AIC homepage

-----Original Message-----
From: Richard Williams [mailto:[email protected]]
Sent: Wednesday, 11 February 2004 12:53 PM
To: [email protected]; [email protected]
Subject: Re: st: Transformations

At 11:43 AM 2/11/2004 +1100, Jason Payne wrote:
>Dear STATAlistservers
>I am trying to transform data in variables.  What is the equivalent STATA>
 syntax for this SPSS command
>if (var1=2) var2=1.

Stata does things kind of backwards from SPSS:

gen var2 = 1 if var1==2

Note the ==

If var2 already exists, instead say

replace var2 = 1 if var1==2

But, what do you want when var1 does not equal 2?  Missing?  A 0-1 
dichotomy? There may be some other ways to approach this, depending on whaty
 our ultimate goal is.

>This syntax only works if you want to create a new variable, however in 
>some cases I might with to modify an existing variable for one case 
>only.  This is particularly useful in cleaning string variables where 
>there are spelling mistakes.  In SPSS I would just type:
>if (caseid=1) stringvar='SPSS'.
>if (caseid=2) stringvar='STATA'.

replace stringvar="SPSS" in 1
replace stringvar="STATA" in 2

I'm assuming these are the first and second cases in your data.  If not 
necessarily so, and caseid is a variable in your data set, then try

replace stringvar="SPSS" if caseid==1
replace stringvar="STATA" if caseid==2

Or, just go in to the data editor and do it!  Lot easier sometimes really.

Richard Williams, Notre Dame Dept of Sociology
OFFICE: (574)631-6668, (574)631-6463
FAX:    (574)288-4373
HOME:   (574)289-5227
EMAIL:  [email protected]
WWW (personal):
WWW (department):

*   For searches and help try:

This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

*   For searches and help try:

© Copyright 1996–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index