system missing values in CTABLE

[jagadishpchary]

Hi,

I would like to know, is there any way where i can display system missing
values in CTABLES? or any other alternate way to get them dispalyed in the
table.

i am attaching the data file and also providing the syntax

data.sav


Ctables
/VLABELS VARIABLES=Q3r3_1,Q5r3c1_1,TOTAL DISPLAY=label
/TABLE (Q8r7)[C] [COUNT] by (Q3r3_1+Q5r3c1_1)
/SLABELS POSITION=COLUMN VISIBLE=NO
/CATEGORIES VARIABLES=Q3r3_1,Q5r3c1_1  TOTAL=no
/CATEGORIES VARIABLES=Q8r7  TOTAL=Yes POSITION=BEFORE .  


Actually there are 40 respondents - there is 1 system missing. therefore  i need to generate the table on 40 respondents and in the table 1 respondent should be shown as sysmis.

Kindly let me know.

Regards,
Jagadish



--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

=====================
To manage your subscription to SPSSX-L, send a message to
[e-mail] (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 Peck]

Procedures never include sysmis values, but you can use COMPUTE or RECODE to map them to some other value, presumably declared as missing.

On Wed, Nov 27, 2019 at 6:02 AM jagadishpchary <[hidden email]> wrote:

Hi,

I would like to know, is there any way where i can display system missing
values in CTABLES? or any other alternate way to get them dispalyed in the
table.

Kindly let me know.

Regards,
Jagadish



--
Sent from: http://spssx-discussion.1045642.n5.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

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

* Untested.

IF (SYSMIS(var)) var = -99.

ADD VALUE LABELS -99 'System Missing'.

MISSING VALUES var (-99).

Am Mittwoch, 27. November 2019, 14:02:31 MEZ hat jagadishpchary <[hidden email]> Folgendes geschrieben:

Hi,

I would like to know, is there any way where i can display system missing

values in CTABLES? or any other alternate way to get them dispalyed in the

table.

Kindly let me know.

Regards,

Jagadish

--

Sent from: http://spssx-discussion.1045642.n5.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

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

[Art Kendall]

Why does your data contain any sysmis values?



Good practice would be to clean out all sysmis values before doing any
analysis.  Reserve sysmis for the situation where the software cannot obey
your commands.  The occurrence of sysmis is a flag that you need to improve
your syntax.

You can have many kinds of user missing data with labeled values.  One could
be "I have no idea why missing"

Understanding why there are missing values is crucial to interpretation and
reasoning with any results.



-----
Art Kendall
Social Research Consultants
--
Sent from: http://spssx-discussion.1045642.n5.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