SPSSX Discussion

Developing a codebook from the SPSS dataset (value and value labels)

Classic

List

Threaded

4 messages Options

Deepa Bhat

Developing a codebook from the SPSS dataset (value and value labels)

Hi,

Is there a way in SPSS to develop a codebook from the value and value
labels?
I don't want frequencies of each variable. Is there a way to get each
value and value label for each variable listed in the output?

Thanks so much,
Deepa

=====================
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

necia

Re: Developing a codebook from the SPSS dataset (value and value labels)

Well sort of. There used to be a command used in syntax, (years ago),

DISPLAY DICTIONARY.

which was very nice and gave you a real "codebook". Doesn't seem to work
now. Under "File" there is a selection to "Display Data File Information"
which, I guess, is as close as you are going to get to a codebook" now.

If someone knows how to get the old output back as used to be generated by
DISPLAY DICTIONARY, I would surely appreciate it!
Cheers,

Necia A. Black, Ph.D. e-mail: [hidden email]
246 Computing Center Web URL:http://www.acsu.buffalo.edu/~black
SUNY-Buffalo
Buffalo, New York 14260

On Fri, 2 May 2008, Deepa Bhat wrote:

> Hi,
>
> Is there a way in SPSS to develop a codebook from the value and value
> labels?
> I don't want frequencies of each variable. Is there a way to get each
> value and value label for each variable listed in the output?
>
> Thanks so much,
> Deepa
>
> =====================
> 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
>
>
>

Peck, Jon

Re: Developing a codebook from the SPSS dataset (value and value labels)

DISPLAY DICTIONARY still exists. The output is now pivot tables, which required some reorganization of the output. If you only want values and value labels, that is contained in the Variable Values table in this output. You can even suppress the other output tables by using OMS if desired.

Some people prefer the older output text style and organization. Something similar but with some extra features and finer grained control, including frequency counts and other statistics is available using the DisplayDict programmability module downloadable from SPSS Developer Central (www.spss.com/devcentral). That requires at least SPSS 14 and the Python programmability plugin from Developer Central. With SPSS 16, it can be used as an extension command named, suggestively, CODEBOOK, which means it can be run using standard SPSS syntax.

HTH,
Jon Peck

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of necia
Sent: Friday, May 02, 2008 1:06 PM
To: [hidden email]
Subject: Re: [SPSSX-L] Developing a codebook from the SPSS dataset (value and value labels)

Well sort of. There used to be a command used in syntax, (years ago),

DISPLAY DICTIONARY.

which was very nice and gave you a real "codebook". Doesn't seem to work
now. Under "File" there is a selection to "Display Data File Information"
which, I guess, is as close as you are going to get to a codebook" now.

If someone knows how to get the old output back as used to be generated by
DISPLAY DICTIONARY, I would surely appreciate it!
Cheers,

Necia A. Black, Ph.D. e-mail: [hidden email]
246 Computing Center Web URL:http://www.acsu.buffalo.edu/~black
SUNY-Buffalo
Buffalo, New York 14260

On Fri, 2 May 2008, Deepa Bhat wrote:

=====================
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

=====================
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

Cleland, Patricia (EDU)

Re: Developing a codebook from the SPSS dataset (value and value labels)

In reply to this post by necia

It can now be done only thru python (Ain't progress grand!)

Below are 2 version that I use. They were developed by Jon Peck of SPSS.

Both versions print the name of the datafile, and the number of
variables in addition to the variable information.

Pat

-------------------------------------------------------------
* This version will print statistics for each variable.

* Print file name, number of vars in file and var information in file
order.
* Print statistics-counts for each value and means.
* To print the var info in alpha order change 'alphaorder=False' to
'alphaorder=True'.

BEGIN PROGRAM.
import spss, spssaux, DisplayDict
print ' '
print "Data Dictionary for:", spssaux.GetDatasetInfo()
print ' '
print "Number of Variables:", spss.GetVariableCount()
print ' '
DisplayDict.dictionary(alphaorder=False, stats='all')
END PROGRAM.

-------------------------------------------------

* This version does not print statistics for each variable.
.
* Print file name, number of vars in file and var information in file
order.
* To print the var info in alpha order change 'alphaorder=False' to
'alphaorder=True'.
* To print without the ODBC attributes add .'ttributes=False'.

BEGIN PROGRAM.
import spss, spssaux, DisplayDict
print ' '
print "Data Dictionary for:", spssaux.GetDatasetInfo()
print ' '
print "Number of Variables:", spss.GetVariableCount()
print ' '
DisplayDict.dictionary(attributes=False,alphaorder=False)
END PROGRAM.

------------------------------------------------------------

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
necia
Sent: May 2, 2008 3:06 PM
To: [hidden email]
Subject: Re: Developing a codebook from the SPSS dataset (value and
value labels)

Well sort of. There used to be a command used in syntax, (years ago),

DISPLAY DICTIONARY.

which was very nice and gave you a real "codebook". Doesn't seem to
work
now. Under "File" there is a selection to "Display Data File
Information"
which, I guess, is as close as you are going to get to a codebook" now.

If someone knows how to get the old output back as used to be generated
by
DISPLAY DICTIONARY, I would surely appreciate it!
Cheers,

Necia A. Black, Ph.D. e-mail: [hidden email]
246 Computing Center Web
URL:http://www.acsu.buffalo.edu/~black
SUNY-Buffalo
Buffalo, New York 14260

On Fri, 2 May 2008, Deepa Bhat wrote:

> Hi,
>
> Is there a way in SPSS to develop a codebook from the value and value
> labels?
> I don't want frequencies of each variable. Is there a way to get
each
> value and value label for each variable listed in the output?
>
> Thanks so much,
> Deepa
>
> =====================
> 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
>
>
>

=====================
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

=====================
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