Importing Labels and Values

[Parag]

How may I import Labels and Values which are stored in a separate data
files to the primary data I've imported?

I assume this would need the use of a script?

I am aware you can copy/paste Labels & Values from say an Excel file,
but this assumes two things:

1. The row (or columns are equal)
2. For every single variable there is only 1 label or value.

In my case, we have for example, a 1-10 likert scale for one variable
and say a Yes/No for another variable.

Accordingly, I have a file which is structured like this:

Variable1 Label1 Value1
Variable1 Label2 Value2
Variable1 Label3 Value3
Variable2 Label1 Value1
Variable3 Label1 Value1
Variable3 Label2 Value2

I would be appreciative of any help. I am unsure why its so difficult
to import labels and values into SPSS when this is something you'd be
able to simply import to?

For large data sets, are SPSS users seriously entering these in
manually?

[JKPeck]

Look at the APPLY DICTIONARY command. It allows you to copy various
variable and data file properties from one SAV file to the active
file.

HTH,
Jon Peck

[Bruce Weaver]

This did not strike me as an APPLY DICTIONARY problem--i.e., I didn't
see anything that made me think there was an existing .SAV file with
all of the desired labels. Rather, I understood the OP to be saying
that they have one Excel file (or worksheet) that contains the actual
data, and another Excel file/worksheet that contains value labels. So
the question is how to convert

Variable1 Label1 Value1
Variable1 Label2 Value2
Variable1 Label3 Value3
Variable2 Label1 Value1
Variable3 Label1 Value1
Variable3 Label2 Value2

into:

VALUE LABELS
Variable1 {value1} "Label1"
{value2} "Label2"
{value3} "Label3" /
Variable2 {value1} "Label1" /
Variable3 {value1} "Label1"
{value2} "Label2"
.

--
Bruce Weaver
bwe...@lakeheadu.ca
http://sites.google.com/a/lakeheadu.ca/bweaver/Home
"When all else fails, RTFM."

[JKPeck]

> bwea...@lakeheadu.cahttp://sites.google.com/a/lakeheadu.ca/bweaver/Home

> "When all else fails, RTFM."

If you are right, Bruce, my approach would be to read in the Excel
label file as an SPSS dataset and then build the labels. This would
require a program, but it would be pretty simple. I can work out
details if we have confirmation

Regards,
Jon

[fred....@lsc.gov.uk]

Don't you just need a formula in excel that adds all the info
together, something like

=IF(A2=A1," "&C2&" @"&B2&"@"," /"&A1&" "&C2&" @"&B2&"@")

then copy the results into a syntax file and find and replace the @
with quotes, something goes screwy when you transfer quotes from excel
to spss

> Jon- Hide quoted text -
>
> - Show quoted text -

[nrst...@gmail.com]

I see this is an old thread, but I was wondering if anyone figured this issue out.

I have an excel worksheet with variable names, codes, and labels just as Parag originally described. This is a separate worksheet to my database.

I used ODK to create a survey form on mobile phones using an excel format which lists out variable codes and labels. The data is exported in XLS or CSV and when I move that into SPSS I'd love to save myself the effort of entering all of the variable codes and labels manually.

Any help would be great.
Thanks!
Nick

[lars.o...@gmail.com]

I think I found a solution:
http://stackoverflow.com/questions/26596644/how-to-load-csv-files-into-spss-variable-and-value-labels