SPSSisFun: Converting Text (string) data to Numeric data

[@sandraire]

This video is a blessing to me. I was having serious issues with my project work and was almost giving up but watching your video has solved the issue, I tried what I learnt from your video and it worked immediately. I'm so grateful to have come across your page. Thank you so much for helping me.

[@elroz18]

I would hit million of like button if i could. You save my day on this christmas. I have to skip my christmas because i was stuck in this area to get the string transform into numeric... Many thanksssss. Merry christmas everyone

[@spssisfun2270]

Thanks! Merry Christmas to you too!

[@trinirastawoman]

OMG!!! Thank you so much for this video!!! I used google forms for my survey and when I downloaded the results it was all in string format. Praise and thanks you have saved me from hours of work!!!

[@spssisfun2270]

That is great to hear!

[@Runsheeg53633]

Only God knows how much I was frustrated. imagine I was thinking of editing the excel spreadsheet data and then making SPSS entry again from scratch. God bless you, bro. I was even ready to pay for this wallahi. Some KZbinrs are really life and energy saving.

[@DaneSchneider-y2r]

You are seriously a life saver my friend, I was going nuts trying to figure this out. THANK YOU

[@leme686]

You saved my grad student ass. Thank you!

[@rafli7907]

Bless this video, i hope your information will be useful for future student that might see this video

[@shanyo2k832]

You might have just saved my thesis

[@spssisfun2270]

Thanks and all the best!

[@shanyo2k832]

I can confirm right now that you indeed helped me get my degree. Thank you so much.

[@katyHH4983]

You saved me too! I have more questions, though. For instance, do I now change the "measure" from nominal to ordinal? Another, how do I set up matrix survey question data with multi-q and multi-answer? It keeps running stats on each separate variable and I want to look at them together... Thanks.

[@hessness]

Did you ever get the answer? I need it

[@samourcastillo]

This was the best video on this !

[@spssisfun2270]

Thanks Shelby! :):):)

[@sarahsafawi5173]

Thank you for being a lifesaver 🙏🙏🙏

[@dorischinelo4178]

Thank youuuu..... You just made it so easy

[@obasioluchukwu8529]

Thanks a lot. Mine has worked. I didn't notice earlier because it was a really large spreadsheet

[@d24-j6m]

Thanks a lot.. But can you help me to know which test to apply for Multiple choice grid questions.

[@AnaBenavidesLahnstein]

Love your vibe!

[@msrukmanithakur4243]

Thanks for video I had my exam of computers today

[@skotkirkpatrick]

This was very helpful, now I can run reports and make graphs with my categorical data. I have a question though: When I make a histogram or other chart, how do I show the value labels? With 20 or more values and only seeing the number and not an actual name it's difficult to interpret. Hope you see this, thanks.

[@PatricioDiazRomo]

You saved me, THANK YOU!!! 🙏🏻

[@AwsYahya]

Thanks a lot for the informative video. I have done the manual record yet the OK option is grayed out (unclickable). I don't know where my mistake is.

[@ebarrago]

Thank you for your video!! It was very helpful! I do have a query... When I imported the first answers from xls it came as a string (text) and I created different variables and applied all values. I have imported more data from another xls spreadsheet and I do have to turn it all again in numerical values. How can apply my values to the new string data without double-clicking when on reply??? It's driving me mental....

[@christianhume7618]

VERY, VERY HELPFUL!! Thank you so much!!

[@spssisfun2270]

Much obliged :)

[@aishaosman6765]

Veeery helpful video,Thank youuuu very much

[@chih-fang-hsu]

What do I do if I want to recode multiple variables? For example if there's 10 questions with 3 options(high, medium,low), how do I recode them to 3, 2, 1 all at once?

[@dr.hanawamin6294]

Hello, it is so easy, but I have problem in downloading the program... if you record such video about the downloading steps is very good...

[@kanwalgeethans7389]

Thanks for providing this video...truly helpful! I have a question though. I’m engaged in healthcare research and am utilizing ICD 10 codes to select cases from a large database. There are 35 different diagnoses columns for each respective patient. All diagnoses columns are designated as string variables due to their respective ICD 10 classifications having both letters and numbers. If I wanted to find specific diagnoses, could I use the “recode in different variables” option, recode the string variables with their ICD 10 codes into numeric values, and set everything else as 0 to capture just those cases I’m interested in examining?

[@spssisfun2270]

Yes this would work!

[@jonesprofit3153]

Thanks alot. It's really helpful.

[@munyaradzidamson5052]

Very useful. Thanks so much

[@SubhashiJayasekara]

Thank you soo much. You saved me!!!

[@theyaodenfamily4679]

OMG I hope I already found this video when I was making my last project on university 😭.

[@AllieinSK]

Great vid, thanks!

[@estherdejong9999]

Thanks for this video! I only have one question. Is it possible to delete the string data after converting the data into numeric data? Or will your numeric data then also be deleted? I am looking forward to recieve an answer.

[@norafiqah3309]

i have a question. after we change the variable do we need to delete the old variable?

[@Vibesfrom98]

saved my life🙂😫

[@molm-sry7773]

Thank you so much sir ❤

[@teodorakoleva171]

Your Content I uploaded a .xlsx file to SPSS. In the Variable View screen, I changed the data type from String to Numeric. After making it, in Data View screen, I find that entries for that variable have been deleted completely. How I can fix it?

[@drvahealthtips9345]

Never do it !! Once u done ur data is gone !! When all are there , create a new variable using this technique with new name !!

[@Theysayeef]

Hi, do you also know how to convert your string data to multiple numeric data?Because the respondent gave two answers that each stand for a different outcome. For example, 1 respondent answered with: Yes, I have been to the supermarket and to the park. And supermarket has been coded '1' en park has been coded '2'. Is it possible to Give two codes to 1 respondent? And if so, how? I hope this makes sense.

[@spssisfun2270]

Hey Evelien. The situation you describe is more similar to 'open coding' with 'multiple responses allowed'. There is a text analysis feature in SPSS which you can look into, but the method I have described in this video is more useful for simple string to numeric recording and may not be useful for text analysis.

[@Nur78900]

thank you, thank you and thank you.

[@kanwalgeethans7389]

Thanks for sharing this video! It was super informative. Through the transform into different variables command, I changed a string code into a numeric one, designating it as 1000 to identify it. I want to select that case to create my desired dataset. I know I need to convert this string code to a numeric one to select the cases I’m interested in examining on SPSS but do I need to designate a value to it in the variable view window since I’ve already designated it as 1000 during the transform into different variables command?

[@getanehtewabe-v1t]

thanks brother

[@edogankent7047]

wonderful thax

[@oana-mariasava7745]

Thank you!

[@anitatony2773]

THANKS ALOT!

[@Haziqah-ue5tr]

Why the method no.3 not working on me

[@maiden5427]

😂😂😂 Perfect

[@happydude211]

i love you

[@kennethwest780]

"AUTO - MAT - IC RE - CODE"