SPSSX Discussion

GET DATA/TYPE=XLS: where do the variable labels come from?

Classic

List

Threaded

2 messages Options

Ruben Geert van den Berg

GET DATA/TYPE=XLS: where do the variable labels come from?

Dear all,

This morning I read an xls file containing raw data as strings. I was surprised to find variable labels in the SPSS dataset. Under what circumstances are variable labels applied and how can SPSS 'know' which cells contain these labels?

TIA!

Ruben

New Windows 7: Simplify what you do everyday. Find the right PC for you.

Bruce Weaver

Re: GET DATA/TYPE=XLS: where do the variable labels come from?

Administrator

Ruben van den Berg wrote

Dear all,

This morning I read an xls file containing raw data as strings. I was surprised to find variable labels in the SPSS dataset. Under what circumstances are variable labels applied and how can SPSS 'know' which cells contain these labels?

TIA!

Ruben

Hi Ruben. IIRC, I've seen this happen when the variable names in Excel were not legal variable names in SPSS--e.g., if the Excel variable name includes spaces.

--
Bruce Weaver
bweaver@lakeheadu.ca
http://sites.google.com/a/lakeheadu.ca/bweaver/

"When all else fails, RTFM."

PLEASE NOTE THE FOLLOWING:
1. My Hotmail account is not monitored regularly. To send me an e-mail, please use the address shown above.
2. The SPSSX Discussion forum on Nabble is no longer linked to the SPSSX-L listserv administered by UGA (https://listserv.uga.edu/).