UCLA Academic Technology Services HomeServicesClassesContactJobs
Stat Computing > SPSS > Code
 Search

SPSS Code Fragment
Converting string variables to numeric

This shows how to convert a string variable race to a numeric variable racen using two methods, the first a bit simpler but more cumbersome, the second method more streamlined but a bit trickier.

DATA LIST FREE / race (A10).
BEGIN DATA.
white
black
asian
hispanic
white
END DATA.

LIST CASES.

* make string to numeric, method 1 .
IF (race="white") racen=1.
IF (race="asian") racen=2.
IF (race="hispanic") racen=3.
IF (race="black") racen=4.

CROSSTAB /TABLES=race BY racen.

* make string to numeric, method 2 .
DO REPEAT A="white" "asian" "hispanic" "black" /B=1 2 3 4.
IF (race=A) racen=B.
END REPEAT print.
execute.

CROSSTAB /TABLES=race BY racen.

How to cite this page

Report an error on this page

UCLA Researchers are invited to our Statistical Consulting Services
We recommend others to our list of Other Resources for Statistical Computing Help
These pages are Copyrighted (c) by UCLA Academic Technology Services

The content of this web site should not be construed as an endorsement of any particular web site, book, or software product by the University of California