Convert String to Numeric Variable in SPSS (Without Losing Data)

In this video, I demonstrated how to convert String variables to Numeric variables in SPSS without losing data. If the data you have loaded into SPSS from excel spreadsheet is entered as String variable, perhaps because the data is Nominal or Ordinal variable, there is appropriate way of converting the strings to numeric type, and this video demonstrates in details how to do that conversion step-by-step.
So, I encourage you to watch the demonstrations in this video to the end so that you would be able to learn and replicate the procedure as demonstrated in this video to transform the String variables of your own data to Numeric Variables type in SPSS.
If you wish to contact me directly for business purposes, such as SPSS Tutorial, or data analysis, please use this address: [e-mail]
The following videos may also be useful to you. Please, click on the link to see the videos:
Test of Multicollinearity of Data in SPSS: • Test of Multicollinear...
Regression Analysis in SPSS Part-2: • Regression Analysis in...
Regression Analysis in SPSS Part-1: • Regression Analysis in...
Introduction to SPSS Software for Beginners Part-1: • Introduction to SPSS S...
Introduction to SPSS Software for Beginners Part-2: • Introduction to SPSS S...
Merge Two Data Files in SPSS (Part-2): • Merge Two Data Files i...
Merge Two Data Files in SPSS (Part-1): • Merge Two Data Files i...
Introduction to SPSS Software for Beginners (Part-3): • Introduction to SPSS S...
Analysis of Variance in SPSS (Effect size and Interpretations): • Analysis of Variance i...
Test of Normality of Data in SPSS: • Test of Normality of D...
Identify Outliers using Tukey's Hinges Approach in SPSS: • Identify Outliers usin...
Identifying Outliers in Dataset using Stem-and-leaf Plot and Boxplots in SPSS: • Identify Outliers usin...
Identify Outliers using Scattered Plots in SPSS: • Identify Outliers usin...
How to Perform and Interpret One Sample T-Test in SPSS: • One Sample T-Test in S...
Paired Sample T-Test in SPSS and Interpretations: • Paired Sample T Test i...
How to Perform Descriptive Statistics in SPSS: • Descriptive Statistics...
How to Perform Pearson’s Correlation Analysis: • How to Perform Pearson...
How to Calculate Pearson’s Correlation Coefficient by Hand, Interpret and Report Results in APA style: • How to Calculate Pears...
Titocan Mark Solutions (TMS) is a RUclips Channel that improves the knowledge of how to do things in many endeavours, Please, encourage education and learning by liking and kindly subscribing to this channel, and so that we begin to send you notifications every time I publish new video content. Thank you.
To Subscribe, Please, click on the red SUBSCRIBE button above or on the video to do so.

[@onyinyechiossai1128]

I almost cried trying to figure this out, this video was really helpful, thank you so much

[@SofiaDanceeys]

Thank you!!! I searched around the internet for 3 hours and still didn't understand anything until I scroll through your video!!

[@catherines1571]

A big thank you from Scandinavia for this video!

[@user-dv5om9li7s]

Thank you so much sir. This video is really helpful for me. Respect from Bangladesh

[@ranchsauce3232]

You are a legend and a lifesaver. Also you have a very soothing voice, very good for us frustrated SPSS users.

[@lathayogesh3668]

Thank you so Much , If I did not find it, I would be waste my precious time

[@mimimim5267]

Thank you sm . I have been looking for this for hours

[@bruderus]

U saved my 6 hours :) thank you brother

[@helentitocan5314]

Keep moving forward, good work 👍

[@dalitsodickson6934]

You are a life saver

[@CsengeHorvath000]

This was so helpful 🎉

[@imranali-ue7xc]

Excellnt workdone by you....

[@ellyo7082]

Thanks a lot Sir

[@Joji1068Bht]

Simple and effective

[@zeinabab6802]

Thank you very much for your detailed explanation. I am looking for more tutorials in SPSS.

[@TitocanMarkSolutions]

You are welcome!

[@kookoronald2699]

Nice work

[@AlexLiu-rr7wp]

Thank you!!!!! Totaly living saving for my final project!! this method is good but for ordinal data we still need to manually edit the value at automatic recoding page

[@nibalabusamaan70]

Use the automatic recording.
Then use the recode into the same variable

[@Bellanegn]

Thanks bro

[@aridotcomtech]

Thanks sir

[@BoraMi24]

I am experiencing an issue while doing this. for age, i have five categories. but the responses from the questionnaire do not contain the first category; that is, none of the respondents were aged 18 to 24 years. so at the end of this automatic recode, the spss is not coding for the first category. please help.

[@TitocanMarkSolutions]

Try doing this. Fill in zeros in the column for Age 18-24 and resources the automatic recode. If you could do it, then you can send your data to me via [e-mail] for me to take a good look and fix the problem for you. Thank you.

[@ThePavethira]

I can only do once that method. The second item i cant do

[@tundeegbewole3761]

Great
So educative
Pls, do you do multivariate analysis..canonical correlation, discriminant analysis..
If you have done that, can we have your link to it
Thanks

[@titocanimhansoloeva1341]

Thanks for your useful and encouraging comment. I have now added those topics you mentioned to my agenda of tutorials to make and as soon as I publish the video I shall inform you, as you will also be automatically notified as a subscriber. Thanks for finding my work useful.

[@oshinidevindi5400]

What to do if the data is lost?

[@TitocanMarkSolutions]

Use undo to recover your original data...

[@cassandraopiari9937]

That you so much for the thorough tutorial! 🫡

[@peterrusselbrooks5423]

Thanks so much for your educative videos...i will send you an email. thanks

[@wikumsusantha8976]

thank you. can i have u r email please for more clarification abt spss

[@TitocanMarkSolutions]

Thanks for your request. This is my email: [e-mail].