hi
i have the following information in two variables
0 250
0 250
1 12000
1 12000
1 12000
what is would like is to take the info from the second variables where the frst variable is 1 and assign the value to the rows where the first variable is coded 0 as below
0 250 12000
0 250 12000
1 12000
1 12000
1 12000
i need to use syntax ot do this , i do not want just say compye third variable = 12000 as this value will change between datasets
regards
ann
Ann E Fitzmaurice
Medical Statistician
Immpact ,University of Aberdeen
Health Sciences Building
Foresterhill
Aberdeen, AB25 2ZD
Scotland
Tel: +44 (0)1224 553876
Fax: +44 (0)1224 555704
Email: <mailto:[log in to unmask] <mailto:[log in to unmask]> > [log in to unmask]
|