VALUES
Locked
 
|
Hello
was just wondering if there is some easy way to load values to a variable in SPSS instead of typing them or re-importing the whole dataset after adding the values? i had an open ended question in a survey, added new variable for the question but after coding the answer. now the codes are all there and i have the code list as well. what i exactly need is how to load this code list (containing the values of that variable) in the same SAV file ? appreciate your help in advance Regards, Aayed |
|
Hi,
I think, you should try some script.
VALUE LABEL variable_name 1 "label1"
2 "label2" 3 "label3" 4 "label4".
Regards, Gaurav 2012/4/8 Mohammed Aayed <[hidden email]>
|
|
In reply to this post by Mohammed Mustafa
Aayad It’s not clear exactly what you have already. Do your cases all have a unique ID (with a matching ID on each questionnaire)? Have you created a new variable in your sav file? Have you entered the codes for the new variable in your sav file? If so, have a look at section 1.4: Completing your data dictionary on my website, especially: http://surveyresearch.weebly.com/uploads/2/9/9/8/2998485/1.4.2__labelling_your_values_in_spss.pdf Otherwise go through the earlier sections and follow the steps carefully, using your own data. John Hall Email: [hidden email] Website: www.surveyresearch.weebly.com Skype: surveyresearcher1 Phone: (+33) (0) 2.33.45.91.47 From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Mohammed Aayed Hello |
Administrator
|
In reply to this post by Mohammed Mustafa
Please post yout question ONCE in a single thread rather than opening two threads with the same question.
BTW: Everyone seems to be confused by what exactly you want so you would do well to carefully rephrase your question or be clear about what you want.
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me. --- "Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis." Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?" |
|
|
i think i was not clear enough
what i mean is, i'm having an open-ended question
for this type of questions we convert the responses into codes
and then coding the data accordingly.
the data is already exported to SPSS but with no "VALUES"
meaning that i have the data for those responses in the SAV file
and i have the code list in xls format, example below
1: code 1
2: code 2
3; code 3
and so on.
now my questions is, how can i load this code list [consists of 50+ codes] into the SAV file as "VALUES" for this specific variable.
two ways i know for that, first is to type those codes and their descriptions. and the second is to have the codes in the proccessing files before before exporting the data to SPSS
is there another way that can convert this code list from an xls sheet to be in the "VALUS" of this specific variable??
hope its more clear now,
and thank you in advance for your support
regards,
Aayed
On Mon, Apr 9, 2012 at 2:28 PM, David Marso <[hidden email]> wrote: Please post yout question ONCE in a single thread rather than opening two |
|
|
I have a better idea of what you want but would you please report or make-up some example data. Five or six records that illustrate the patterns might be sufficient. Show what you have now and what you want to have when the problem has been solved. Gene Maguin From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Mohd Aayed i think i was not clear enough what i mean is, i'm having an open-ended question for this type of questions we convert the responses into codes and then coding the data accordingly. the data is already exported to SPSS but with no "VALUES" meaning that i have the data for those responses in the SAV file and i have the code list in xls format, example below 1: code 1 2: code 2 3; code 3 and so on. now my questions is, how can i load this code list [consists of 50+ codes] into the SAV file as "VALUES" for this specific variable. two ways i know for that, first is to type those codes and their descriptions. and the second is to have the codes in the proccessing files before before exporting the data to SPSS is there another way that can convert this code list from an xls sheet to be in the "VALUS" of this specific variable?? hope its more clear now, and thank you in advance for your support regards, Aayed On Mon, Apr 9, 2012 at 2:28 PM, David Marso <[hidden email]> wrote: Please post yout question ONCE in a single thread rather than opening two |
|
Administrator
|
In reply to this post by Mohd Aayed
OK! Your solution is to create SYNTAX for your *VALUE LABELS* and run it *AFTER* reading the 'raw data' into SPSS.
The syntax has the following structure. VALUE LABLES varlist value "label" value "label" ... One way to build this from Excel is Assume: A B ----- 1 label1 2 label2 ---- Create a formula in Column C: =A1 & " '" & B1 & "'" Drag this down and it will populate the column with 1 'label1' 2 'label2' .... Should be easy to go from there. ---
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me. --- "Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis." Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?" |
| Free forum by Nabble | Edit this page |