Software

Ask Software Development Questions and Get Answers ASAp

Ask a Computer Expert,
Get an Answer ASAP!

Software

I am trying to use the concat function in SPSS to merge 3

Customer Question
variables and I have not...
I am trying to use the concat function in SPSS to merge 3 variables and I have not been able to get it to work
JA: What kind of computer do you have?
Customer: an ASUS laptop---a PC
JA: Have you installed any updates recently?
Customer: no
JA: Anything else you want the software expert to know before I connect you?
Customer: no
Submitted: 3 months ago.Category: Software
Show More
Show Less
Ask Your Own Software Question
Answered in 43 minutes by:
7/28/2017
Software technician: Jess M., Computer Support Specialist replied 3 months ago
Jess M.
Jess M., Computer Support Specialist
Category: Software
Satisfied Customers: 659
Experience: Computer Software Support specialist for more that 10 years
Verified

Hi, welcome and thank you for your question. My name is ***** ***** I will be glad to assist you today.

Are your 3 variables that you are trying to concatenate of String data type? The concatenate function only takes string variables.

Please let me know by replying to me in the box below

Thank you.

Best regards,

Jess

Ask Your Own Software Question
Customer reply replied 3 months ago
THEY ARE
Customer reply replied 3 months ago
WHERE IS MY ANSWER
Customer reply replied 3 months ago
do i have to actually give you more money to get a real answer to my question?
Software technician: Jess M., Computer Support Specialist replied 3 months ago
Thank you for writing back with that information. Are you getting any error with the function results? Or is it not showing any results at all?
Ask Your Own Software Question
Customer reply replied 3 months ago
I just get an error telling me the syntax is incorrect. DO YOU ACTUALLY HAVE A REAL ANSWER TO MY QUESTION?
Software technician: Jess M., Computer Support Specialist replied 3 months ago

Yes, I am here to answer your question and help you make that function work. How exactly did you use the function? What was your exact declaration there? Please describe since I'm not seeing what you see on your screen.

Ask Your Own Software Question
Customer reply replied 3 months ago
I have three sting variables that I would like to concatenate in SPSS ver. 24. Are you familiar with how to do this or not? All you have done is ask me questions and provide absolutely no guidance or assistance with the syntax suggesting to me that you are not familiar with SPSS or the concat function. You clearly want me to pay you more money without any assistance being provided. All of this makes me wonder if you are not simply a sham organization.
Software technician: Jess M., Computer Support Specialist replied 3 months ago

I'm trying to help you that is why I was asking those question since I want to understand your scenario. Please tell me HOW you actually used that function and we can take it from there.

Ask Your Own Software Question
Customer reply replied 3 months ago
This is the syntax I used
CONCAT (LTRIM (HHX,F9)), "_", LTRIM (FMX,F5)), "_" LTRIM (FPX,F5))).
Customer reply replied 3 months ago
please opted out will look for another expert
Software technician: Jess M., Computer Support Specialist replied 3 months ago

I'm trying to post an answer but I got an error

Ask Your Own Software Question
Customer reply replied 3 months ago
what? how is this an answer to my question?
Software technician: Jess M., Computer Support Specialist replied 3 months ago

You are not understanding. I said, I was trying to post an answer but I got an error.

Ask Your Own Software Question
Software technician: Jess M., Computer Support Specialist replied 3 months ago

I am on mobile right now and I typed a lengthy reply. I copied it before hitting Send. When I hit send, I got an error, so it is not posted. I tried pasting again, same error. Let me try one more time.

Ask Your Own Software Question
Customer reply replied 3 months ago
How is your statement about getting an error my issue. I am looking for an answer to the question I have asked. SO far you have given me nothing. I clearly understood that your statement about getting an error did not answer my question about concatenating variables in SPSS.
Software technician: Jess M., Computer Support Specialist replied 3 months ago

So if I confused you. I know you just want your answer.

Please check this private note, I was able to paste it there:

https://privnote.com/agLD1fOL#dD6YXH5TF

Ask Your Own Software Question
Software technician: Jess M., Computer Support Specialist replied 3 months ago

Were you able to visit the link to read my note?

Ask Your Own Software Question
Customer reply replied 3 months ago
your suggestion doesn't work
Customer reply replied 3 months ago
i originally used that approach and then used it again and it does not work
Software technician: Jess M., Computer Support Specialist replied 3 months ago

It will not work if you did not convert the numeric data to strings first. Concat function only allows strings

Ask Your Own Software Question
Customer reply replied 3 months ago
THEY ARE STRING VARIABLES
Customer reply replied 3 months ago
I HAVE ALREADY TOLD YOU THAT THEY ARE STRING VARIABLES
Software technician: Jess M., Computer Support Specialist replied 3 months ago

OK, but you declared them as Numeric in your syntax, F9, and F5! They should be A9 and A5 respectively in your given code.

Ask Your Own Software Question
Customer reply replied 3 months ago
DO YOUR JOB AND TELL ME WHAT CODE TO USE IN ORDER TO MAKE THIS WORK
Software technician: Jess M., Computer Support Specialist replied 3 months ago

Please change your code, the one you gave me, replace F9 with A9 and F5 with A5. Test if it works this time.

Ask Your Own Software Question
Customer reply replied 3 months ago
WRITE THE CODE OUT FOR ME SO I CAN SEE WHAT YOU ARE TALKING ABOUT
Software technician: Jess M., Computer Support Specialist replied 3 months ago

OK.

Ask Your Own Software Question
Software technician: Jess M., Computer Support Specialist replied 3 months ago

This is your code revised:

CONCAT (LTRIM (HHX,A9)), "_", LTRIM (FMX,A5)), "_" LTRIM (FPX,A5)))

You need to use the COMPUTE command assigning the concat results to a variable, like COMPUTE varname = your concat formula above.

Ask Your Own Software Question
Customer reply replied 3 months ago
this did not work
Customer reply replied 3 months ago
i need a real answer that will really work
Software technician: Jess M., Computer Support Specialist replied 3 months ago

OK, in your code, it lacks a comma after the second "-".

Ask Your Own Software Question
Software technician: Jess M., Computer Support Specialist replied 3 months ago

CONCAT (LTRIM (HHX,A9)), "_", LTRIM (FMX,A5)), "_", LTRIM (FPX,A5)))

Are you still getting the syntax error?

Ask Your Own Software Question
Customer reply replied 3 months ago
i get the error message incorrect variable name
Customer reply replied 3 months ago
incorrect variable name
Software technician: Jess M., Computer Support Specialist replied 3 months ago

After changing the F to A you are getting unknown varname error?

Pls try to restore your original code, then just add the missing comma, like below:

CONCAT (LTRIM (HHX,F9)), "_", LTRIM (FMX,F5)), "_", LTRIM (FPX,F5)))

Ask Your Own Software Question
Customer reply replied 3 months ago
IT DOES NOT WORK--I GET THE ERROR MESSAGE INCORRECT VARIABLE NAME
Software technician: Jess M., Computer Support Specialist replied 3 months ago

Tell me if you are still getting an error. If you are, then please do the changing of F to A, add the missing comma, but make sure that you decade the variable that holds the COMPUTE results first, and then the compute command

Ask Your Own Software Question
Customer reply replied 3 months ago
IT DOESN'T WORK IT DOESN'T WORK IT DOESN'T WORK
Software technician: Jess M., Computer Support Specialist replied 3 months ago

Like this:

String fullname(A22)

Compute full name = CONCAT (LTRIM (HHX,A9)), "_", LTRIM (FMX,A5)), "_", LTRIM (FPX,A5)))

Ask Your Own Software Question
Software technician: Jess M., Computer Support Specialist replied 3 months ago

full name in COMPUTE command should be fullname, must be the same as the declared variable

Ask Your Own Software Question
Customer reply replied 3 months ago
THIS ISN'T WORKING
Software technician: Jess M., Computer Support Specialist replied 3 months ago

What error are you getting this time?

Ask Your Own Software Question
Customer reply replied 3 months ago
THE SAME ERROR
Customer reply replied 3 months ago
how would you make this work using the gui interface in SPSS
Software technician: Jess M., Computer Support Specialist replied 3 months ago

Please use the syntax:

display dictionary

to show all your variables on the file.

Please tell me if these 3 variables are indeed String or numeric.

Ask Your Own Software Question
Customer reply replied 3 months ago
how many times do i have to tell you they are string variable
Software technician: Jess M., Computer Support Specialist replied 3 months ago

Then why you are invoking them as F9 and F5 on your code? That is why I asked you to check.

Ask Your Own Software Question
Software technician: Jess M., Computer Support Specialist replied 3 months ago

Are you getting syntax error or unknown var error?

Ask Your Own Software Question
Customer reply replied 3 months ago
why are we back to this---you still haven't helped me
Software technician: Jess M., Computer Support Specialist replied 3 months ago

Please tell me the error

Ask Your Own Software Question
Customer reply replied 3 months ago
INCORRECT VARIABLE NAME
Software technician: Jess M., Computer Support Specialist replied 3 months ago

Well, that is the new error, not the syntax error that you first reported.

Can you tell me your whole code including the variable declaration part?

Ask Your Own Software Question
Customer reply replied 3 months ago
YOU ARE NOT EVEN FOLLOWING THIS CONVERSATION---I NEED SOMEONE WHO WILL ACTUALLY PAY ATTENTION AND SOLVE THIS PROBLEM IT IS CLEARLY NOT YOU SINCE YOU HAVEN'T EVEN FOLLOWED THE TRAIN
Customer reply replied 3 months ago
YOU HAVE WASTED TOO MUCH OF MY TIME TODAY FOR THIS TO BE EVEN FUNNY
Software technician: Jess M., Computer Support Specialist replied 3 months ago

You are not cooperating. In this chat mode of help, you need to describe your situation better for the tech support to help you better.

I am opting out. I'm very sorry if I was not able to help.

Ask Your Own Software Question
Ask Jess M. Your Own Question
Jess M.
Jess M.
Jess M., Computer Support Specialist
Category: Software
Satisfied Customers: 659
659 Satisfied Customers
Experience: Computer Software Support specialist for more that 10 years

Jess M. is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed.

One Happy CustomerNew York

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

< Previous | Next >

Meet the Experts:

Jess M.

Jess M.

Computer Support Specialist

659 satisfied customers

Computer Software Support specialist for more that 10 years

Chris L.

Chris L.

Support Specialist

500 satisfied customers

Certified Software expert with over 10 years experience.

IT Miro

IT Miro

Computer Scientist

497 satisfied customers

Bachelor's Degree in Information Technology, Microsoft Certified Professional

Jins M. N.

Jins M. N.

Computer Hardware Engineer

460 satisfied customers

12+ years experience. Expert in installing and problem fixing of softwares.

Kamil Anwar

Kamil Anwar

Software Specialist

447 satisfied customers

8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.

Steve Herrod

Steve Herrod

Computer Support Specialist

220 satisfied customers

Familiar with a wide variety of software and experienced in user training/support

Byron

Byron

Computer Support Specialist

160 satisfied customers

12 years in operations at a large law firm supporting both retail and specialty applications.

< Previous | Next >

Related Software Questions
I just bought date for my hallmark card studio. It was not
It was not able download because is states "unable to locate a valid installation f Hallmark Card Studio I have bought the computer in Jan. I have bought several programs before the only one I had trouble with was last year because the did not set up correctly. i … read more
Jess M.
Jess M.
Computer Support Specialist
659 satisfied customers
I have a Mac Book Pro OS X Ell Capitan 19.11.6. What
I have a Mac Book Pro OS X Ell Capitan 19.11.6. What versions of Adobe Illustrator will work on my instrument? I want to have the software on a CD … read more
Jon
Jon
Bachelors Degree
400 satisfied customers
Assuming there is a way to make a recording that keeps
Assuming there is a way to make a recording that keeps separate two tracks, one a click track and the other a string quartet, is there software and a device (ideally an Android phone, but not much cha… read more
Pete
Pete
Engineer
Bachelor\u0027s Degree
1,109 satisfied customers
I am trying to enter my Knitting, Ravelry, but I can not
I am trying to enter my Knitting , Ravelry, but I can not even when I use the password!!! … read more
Jess M.
Jess M.
Computer Support Specialist
659 satisfied customers
I purchased a card for PSE from Leading Edge Computers at
I purchased a card for PSE from Leading Edge Computers at Port Macquarie, they and activated the card, but when I inserted the code, I could not get a serial number … read more
Jess M.
Jess M.
Computer Support Specialist
659 satisfied customers
MY PDF ICONS ON MY DESKTOP SHOW UP AS ALL INSTEAD OF THE RED
MY PDF ICONS ON MY DESKTOP SHOW UP AS ALL WHITE INSTEAD OF THE RED ICONS I USUALLY HAVE. … read more
Viet - Computer Tech
Viet - Computer Tech
Computer Technican
Bachelor\u0027s Degree
952 satisfied customers
In word i have a copy of my book to publish and the pages
in word i have a copy of my book to publish and the pages moved need to correct but it won't let me correctit … read more
Jess M.
Jess M.
Computer Support Specialist
659 satisfied customers
Purchased hallmark 2018 Have Used car studio for more than
purchased hallmark 2018 Have Used car studio for more than 12 years When 18 was installed event planer was transferred from 13 to 18 The address book in 13 was erased but not transfers to 18 I have lo… read more
Kris R
Kris R
IT Manager
Computing
2,311 satisfied customers
I have an ch341a that only uses bin files, asus uses cap. is
I have an ch341a that only uses bin files, asus uses cap. is there any to convert the cap file so i can use the ch341a to program a chip … read more
caraleneK
caraleneK
Service Manager
1,648 satisfied customers
Just downloaded office 365 home. My old employer system
hi just downloaded office 365 home. My old employer system expired. I keep getting messages stating outlook expired and skype business cannot log in. I need help … read more
Jess M.
Jess M.
Computer Support Specialist
659 satisfied customers
I am hoping someone can help with an issue in Lightroom?
Hi. I am hoping someone can help with an issue in Lightroom? Thanks for your time, Shem. … read more
Jess M.
Jess M.
Computer Support Specialist
659 satisfied customers
I opened a new face book page and facebook locked it down
I opened a new face book page and facebook locked it down now I can't use it why … read more
Kris R
Kris R
IT Manager
Computing
2,311 satisfied customers
I HAVEN'T USED SKYPE IN AWHILE. i HAVE PAID FOR AN ACCOUNT
i HAVEN'T USED SKYPE IN AWHILE. i HAVE PAID FOR AN ACCOUNT WHICH i HAVE HAD FOR YEARS. i HAD THE ICON AND ALL i HAD TO DO WAS CLICK ON IT AND mY CONTACTS TO PHONE CAME UP. nOW THE ICON IS GONE AND i C… read more
Jins M. N.
Jins M. N.
Computer Hardware Engineer
Diplom
460 satisfied customers
How do I recover my ticker on facebook. I don't have a clue.
just going through the steps on youtube, etc. my icon to refresh ticker doesn't exist any more … read more
Donna French
Donna French
Bachelor of Science
14 satisfied customers
I can not log into my email account. It does not recognize
I can not log into my email account. It does not recognize my password … read more
Jason Jones
Jason Jones
AAS Information Technology
6,316 satisfied customers
Cant purchase in app store with store credits. I phone 7.
I got a bad I tunes card and ever since I have had trouble… read more
Pete
Pete
Engineer
Bachelor\u0027s Degree
1,109 satisfied customers
I received a message on my computer saying if was hacked and
I received a message on my computer saying if was hacked and I need to call microsoft at(###) ###-####… read more
ChrisC
ChrisC
PC Technician
Associate Degree
659 satisfied customers
I'm trying to get my AutoCAD 2018 installed on my work
I'm trying to get my AutoCAD 2018 installed on my work station. it was running fine until the company is putting everything on a server. we uninstalled it on my original workstation so it wouldn't look like we were cheating. I can not get it running on my new workstation. an error code of*****m pops up I work for Mattessich iron and all programs have been purchased. but my work is piling up. … read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,214 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x