Data Dictionary in SPSS

[Courtney M. Cronley]

I am trying to create a data dictionary for a data set with over 2,000 variables. I want to export the dictionary from SPSS viewer to Word, but SPSS won't export all of the variables. I'm guessing it's because there are too many. Does anyone know of a workaround for this problem?

Thanks,

Courtney

Courtney Cronley, Ph.D.
Postdoctoral Fellow
Center of Alcohol Studies
Rutgers University

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Wilhelm Landerholm | Queue]

Hi Courtney!

When you say you want to export data dictionary, do you by that mean, you want to export variable labels and value labels to word?

All the best

Wilhelm (Wille) Landerholm

Queue/STATB
BOX 92
162 12 Vallingby
Sweden

[phone]
http://www.qsweden.com
http://www.statb.com

QUEUE/STATB - your partner in data analysis, data modeling and data mining.

2009/12/16 Courtney M. Cronley <[hidden email]>

I am trying to create a data dictionary for a data set with over 2,000 variables. I want to export the dictionary from SPSS viewer to Word, but SPSS won't export all of the variables. I'm guessing it's because there are too many. Does anyone know of a workaround for this problem?

Thanks,

Courtney

Courtney Cronley, Ph.D.
Postdoctoral Fellow
Center of Alcohol Studies
Rutgers University

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Albert-Jan Roskam]

Hi Courtney!

 

You could use OMS. I think in newer version exporting as .doc is possible. Here's the syntax for exporting to .html:

 

OMS
 /SELECT TABLES
 /IF COMMANDS = ["Sysfile Info"]
     SUBTYPES = ["File Information" "Value Labels" "Variable Information"]
 /DESTINATION FORMAT = HTML
  IMAGES = NO
  OUTFILE = "D:\TEMP\dict.htm".
SYSFILE INFO FILE='c:/program files/spss/employee data.sav'.
OMSEND.

Cheers!!
Albert-Jan

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
In the face of ambiguity, refuse the temptation to guess.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

--- On Wed, 12/16/09, Wilhelm Landerholm | Queue <[hidden email]> wrote:

From: Wilhelm Landerholm | Queue <[hidden email]>
Subject: Re: [SPSSX-L] Data Dictionary in SPSS
To: [hidden email]
Date: Wednesday, December 16, 2009, 4:36 PM

Hi Courtney!

When you say you want to export data dictionary, do you by that mean, you want to export variable labels and value labels to word?

All the best

Wilhelm (Wille) Landerholm

Queue/STATB
BOX 92
162 12 Vallingby
Sweden

[phone]
http://www.qsweden.com
http://www.statb.com

QUEUE/STATB - your partner in data analysis, data modeling and data mining.

2009/12/16 Courtney M. Cronley <cronley@...>

I am trying to create a data dictionary for a data set with over 2,000 variables. I want to export the dictionary from SPSS viewer to Word, but SPSS won't export all of the variables. I'm guessing it's because there are too many. Does anyone know of a workaround for this problem?

Thanks,

Courtney

Courtney Cronley, Ph.D.
Postdoctoral Fellow
Center of Alcohol Studies
Rutgers University

=====================
To manage your subscription to SPSSX-L, send a message to
LISTSERV@... (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD