The easy way to add single quotes for all the value labels in Excel is the Concatenate function. That plus this syntax shortcut has saved me countless hours. Thanks!
This was a great answer. Just a quick note: I have SPSS version 23 and I didn't need to put the quotation marks before and after each label for it to work (FYI, because it makes the already easy process you described even easier). Thanks again!
This is a really helpful video thank you. After following all your steps and hitting run, I'm getting this notification: "Attempt to connect to a remote server failed". I'm unable to save changes in my syntax or data editor and need to restart my computer to enable SPSS to operate. I'm using SPSS 26 on Mac Catalina. Any advice would be much appreciated. Thanks, Cassandra
Only way this could be improved would be if you had also demonstrated multiple variable labels in one go - which I am now experimenting with. Wish me luck!
Wasn't too hard. You simply use a comma and no space when adding the additional variables. I had to still perform a minor manual task of removing an unwanted label, but still saved a lot of time. HURRAY! :)
@@deadlypalms I managed to change the names in to values but as my data was originally text, it stays as 'String' data. Would it affect when running analysis on my data?
@how2stats Nice video👍 what if someone has replied austria and usa, and another person has chosen mexico and italy ... how would be the labeling in this case?? Can we label 2 countries for one value??
For the following, use "Right click copy" and "Right click paste", not fast key (ctrl+c or v). At Variable view Tab, COPY the Values that you have already label using syntax, HIGHLIGHT the other variables which don't have the value labels. Click PASTE. Voila
you can add quotes at once with microsoft word replace function to do that, copy entire column to the word hit CTRL + H, find what: ^p replace with: '^p' click replace all check first and last line that's it
Use a text editor that can do find and replace with regular expressions, then copy and paste the number and label names into it. Then: Find: \t Replace: \t' Find:
The easy way to add single quotes for all the value labels in Excel is the Concatenate function. That plus this syntax shortcut has saved me countless hours. Thanks!
Good to hear!
This was a great answer. Just a quick note: I have SPSS version 23 and I didn't need to put the quotation marks before and after each label for it to work (FYI, because it makes the already easy process you described even easier). Thanks again!
Thanks. I'll have to check that out.
You are my HERO!!!! I've been searching for the answer to this for years!!! Thank you!!!
Really very useful and clever trick. Some times is pain in ass to put so many labels. Thank you
Great trick! Please continue the channel, you improve my workflow immensely!
I really enjoyed this short video. Its so very useful
Thank you, thank you, thank you!! You've just saved me an afternoon! :D
You saved me so much time! Thank you!
Thank you, really saved my time
most important video..... Thank you
Glad you liked it.
Is there a way to add Value Labels to multiple variable at once?
THANK YOU!
Thanks for this! Genius
This is a really helpful video thank you.
After following all your steps and hitting run, I'm getting this notification: "Attempt to connect to a remote server failed". I'm unable to save changes in my syntax or data editor and need to restart my computer to enable SPSS to operate. I'm using SPSS 26 on Mac Catalina. Any advice would be much appreciated. Thanks, Cassandra
Only way this could be improved would be if you had also demonstrated multiple variable labels in one go - which I am now experimenting with. Wish me luck!
Wasn't too hard. You simply use a comma and no space when adding the additional variables. I had to still perform a minor manual task of removing an unwanted label, but still saved a lot of time. HURRAY! :)
@@deadlypalms I managed to change the names in to values but as my data was originally text, it stays as 'String' data. Would it affect when running analysis on my data?
Thank you very much.
@how2stats Nice video👍 what if someone has replied austria and usa, and another person has chosen mexico and italy ... how would be the labeling in this case?? Can we label 2 countries for one value??
What if you want to change a bunch of values of labels at the same time?
For the following, use "Right click copy" and "Right click paste", not fast key (ctrl+c or v).
At Variable view Tab, COPY the Values that you have already label using syntax, HIGHLIGHT the other variables which don't have the value labels. Click PASTE. Voila
There should be a double like button! So helpful
Thanks for the video!
How do you copy Values & labels OUT of the variable properties, though?
Thanks :)
you can add quotes at once with microsoft word replace function
to do that, copy entire column to the word
hit CTRL + H,
find what: ^p
replace with: '^p'
click replace all
check first and last line
that's it
Use a text editor that can do find and replace with regular expressions, then copy and paste the number and label names into it.
Then:
Find: \t
Replace: \t'
Find:
Replace: '
Are you still taking questions
Yep in excel use this
lenashore.com/2012/04/how-to-add-quotes-to-your-cells-in-excel-automatically/