SPSSX Discussion

Value & Lables display on data

Classic

List

Threaded

8 messages Options

Peter Omondi

Value & Lables display on data

Hi All,

Please do assist me and show me if we have any SPSS syntax which can
display both values & lables on the SPSS data itself?.

Thanks,

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

John F Hall

Re: Value & Lables display on data

They should both be in your data editor. If you want both displayed in
output, click on:

Edit > Options [opens a pane with several tabs]

Click on "Output Labels" and change "Labels" to "Values and Labels" in one
or both panes.

John F Hall (Mr)

Email: [hidden email]
Website: www.surveyresearch.weebly.com
Skype: surveyresearcher1
Phone: (+33) (0) 2.33.45.91.47

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Peter Omondi
Sent: 17 April 2012 08:46
To: [hidden email]
Subject: Value & Lables display on data

Hi All,

Please do assist me and show me if we have any SPSS syntax which can display
both values & lables on the SPSS data itself?.

Thanks,

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

Mohd Aayed

Re: Value & Lables display on data

In reply to this post by Peter Omondi

Hi Peter
From the top menu select view>value labels
This to switch one or all variable to their value labels
U can also save it to XLS or other types in this format by selecting File>save as
Then select the file type and tick the box beside "save value labels where defined instead of data values"

Regards
Aayed

On Tuesday, April 17, 2012, Peter Omondi <[hidden email]> wrote:
> Hi All,
>
> Please do assist me and show me if we have any SPSS syntax which can
> display both values & lables on the SPSS data itself?.
>
> Thanks,
>
> =====================
> 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
>

Mark Andrews (Mark.Andrews@synovate.com)

Re: Value & Lables display on data

In reply to this post by Peter Omondi

The problem with the display dictionary function is that it provides the variable labels and value labels in different tables. I have often had to use excel lookup functions to bring it all together into a proper data dictionary.

If you are looking for syntax, you can use this for a full list:

Display dictionary.

If you want to just to look at one or select variables:

Display dictionary
/Variables= variable1.

Mark

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Peter Omondi
Sent: Tuesday, April 17, 2012 2:46 AM
To: [hidden email]
Subject: Value & Lables display on data

Hi All,

Please do assist me and show me if we have any SPSS syntax which can display both values & lables on the SPSS data itself?.

Thanks,

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

John F Hall

Re: Value & Lables display on data

In reply to this post by John F Hall

Yes, I think so. From the data editor click on:

Data > Define Variable Properties

Drag a variable across to the Variables to scan pane, click Continue, and
you get a useful little menu displaying values, labels and much else
besides. I'd never use this for defining data, but it's a handy check all
the same.

John F Hall (Mr)

Email: [hidden email]
Website: www.surveyresearch.weebly.com
Skype: surveyresearcher1
Phone: (+33) (0) 2.33.45.91.47

-----Original Message-----
From: Peter Omondi [mailto:[hidden email]]
Sent: 17 April 2012 09:36
To: John F Hall
Subject: Re: Value & Lables display on data

Thanks John,

But is there a way you can be able to see both your values and labels on the
SPSS data view?

On 4/17/12, John F Hall <[hidden email]> wrote:

> They should both be in your data editor. If you want both displayed
> in output, click on:
>
> Edit > Options [opens a pane with several tabs]
>
> Click on "Output Labels" and change "Labels" to "Values and Labels" in
> one or both panes.
>
>
> John F Hall (Mr)
>
> Email: [hidden email]
> Website: www.surveyresearch.weebly.com
> Skype: surveyresearcher1
> Phone: (+33) (0) 2.33.45.91.47
>
>
>
>
> -----Original Message-----
> From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf
> Of Peter Omondi
> Sent: 17 April 2012 08:46
> To: [hidden email]
> Subject: Value & Lables display on data
>
> Hi All,
>
> Please do assist me and show me if we have any SPSS syntax which can
> display both values & lables on the SPSS data itself?.
>
> Thanks,
>
> =====================
> 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

Robin M. Marr

Re: Value & Lables display on data

In reply to this post by Mark Andrews (Mark.Andrews@synovate.com)

Mark Andrews (Mark.Andrews@synovate.com) wrote

The problem with the display dictionary function is that it provides the variable labels and value labels in different tables. I have often had to use excel lookup functions to bring it all together into a proper data dictionary.

If you are looking for syntax, you can use this for a full list:

Display dictionary.

If you want to just to look at one or select variables:

Display dictionary
/Variables= variable1.

Mark

Hi Mark,

I had been doing the same thing to get around the variables/values table problem.

We've got this metadata management app called "Datamagnet Dictionary" installed on the computers at my workplace. It puts the variables and values in the same table by default, so recently I've just been using that to get a pdf or word doc. I just checked their website and they have a free trial if you want to give it try.

Here's the link: http://www.datamagnet.ca/dictionary/overview

Regards,
Robin

Rick Oliver-3

Re: Value & Lables display on data

You might want to look at the CODEBOOK command.

Rick Oliver
Senior Information Developer
IBM Business Analytics (SPSS)
E-mail: [hidden email]
Phone: 312.893.4922 | T/L: 206-4922

From: "Robin M. Marr" <[hidden email]>
To: [hidden email]
Date: 05/03/2012 03:31 PM
Subject: Re: Value & Lables display on data
Sent by: "SPSSX(r) Discussion" <[hidden email]>

Mark Andrews ([hidden email]) wrote > > The problem with the display dictionary function is that it provides the > variable labels and value labels in different tables. I have often had to > use excel lookup functions to bring it all together into a proper data > dictionary. > > If you are looking for syntax, you can use this for a full list: > > Display dictionary. > > If you want to just to look at one or select variables: > > Display dictionary > /Variables= variable1. > > Mark > > Hi Mark, I had been doing the same thing to get around the variables/values table problem. We've got this metadata management app called "Datamagnet Dictionary" installed on the computers at my workplace. It puts the variables and values in the same table by default, so recently I've just been using that to get a pdf or word doc. I just checked their website and they have a free trial if you want to give it try. Here's the link: http://www.datamagnet.ca/dictionary/overviewhttp://www.datamagnet.ca/dictionary/overviewRegards, Robin -- View this message in context:http://spssx-discussion.1045642.n5.nabble.com/Value-Lables-display-on-data-tp5645806p5684227.htmlSent from the SPSSX Discussion mailing list archive at Nabble.com. ===================== 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

Jon K Peck

Re: Value & Labels display on data

In reply to this post by Robin M. Marr

You might find the CODEBOOK command (Analyze>Reports>Codebook) useful. It shows selected variable properties in a single table and can include summary statistics as well.

Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
new phone: 720-342-5621

From: "Robin M. Marr" <[hidden email]>
To: [hidden email]
Date: 05/03/2012 02:33 PM
Subject: Re: [SPSSX-L] Value & Lables display on data
Sent by: "SPSSX(r) Discussion" <[hidden email]>