Elaboration macro

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Elaboration macro

John F Hall

Bruce

I’ve been trying to modify the elaboration macro:

 

A straightforward CTABLES works:

 

 

ctables

/TABLE ExPrtFul > rsex BY rearnq [ROWPCT.COUNT f5.1 "%" totals [count "n= 100%"]]

/CATEGORIES VARIABLES= rearnq TOTAL=YES .

 

 

 

REarnQ Respondent earnings quartiles (dv)

1 Q1

2 Q2

3 Q3

4 Q4

Total

%

%

%

%

n= 100%

ExPrtFul Is your job full or part time?

1 ... full-time - that is, 30 or more hours per week,

RSex Person 1 SEX

1 Male

47.2

28.5

13.8

10.6

246

2 Female

61.1

22.9

9.2

6.9

262

2 or, part-time?

RSex Person 1 SEX

1 Male

38.9

27.8

22.2

11.1

36

2 Female

72.2

13.9

5.3

8.6

187

 

. . but my modified  macro doesn’t and I keep getting error messages.

 

Error # 1.  Command name: close

The first word in the line is not recognized as an SPSS Statistics command.

Execution of this command stops.

get file thedatafile.

 

Error # 61 in column 10.  Text: thedatafile

The filename is not valid.

Execution of this command stops.

Error # 105.  Command name: CTABLES

This command is not valid before a working file has been defined.

Execution of this command stops.

 

What am I doing wrong?

My shot at the macro is:

 

* Encoding: UTF-8.

*Elaboration 2.

DEFINE elaborate

( Y = !CHAREND('/') /

   RowVar = !CHAREND('/') /

   ColVar = !CMDEND )

  CTABLES

  /TABLE !RowVar  [C] >  !ColVar [C] by !Y [c] [ROWPCT.COUNT f5.1 "%" ] totals [count "n= 100%"]]

  /SLABELS POSITION=ROW VISIBLE=NO

  /CATEGORIES VARIABLES= !y  TOTAL=YES

  /TITLES CAPTION ='NOTE:  Cells show ROWPCT and Row COUNT'.

!ENDDEFINE.

 

* Read in some data to illustrate.

* Modify path on the FILE HANDLE command as needed.

FILE HANDLE TheDataFile /NAME='C:\Users\John\Desktop\gss_2016\babbie2019.sav'.

NEW FILE.

* Call the macro.

elaborate Y = abany / RowVar = postlife / ColVar = vote12.

 

DATASET ACTIVATE DataSet4.

GET

  FILE='H:\F drive backup\Research1a\4 Surveys\British Social Attitudes\2018\bsa2018a.sav'.

DATASET NAME DataSet5 WINDOW=FRONT.

GET

  FILE='H:\F drive backup\Research1a\4 Surveys\British Social Attitudes\2018\bsa2018_final_ukda.sav'.

 

Warning # 5281.  Command name: GET FILE

SPSS Statistics is running in Unicode encoding mode.  This file is encoded in

a locale-specific (code page) encoding.  The defined width of any string

variables are automatically tripled in order to avoid possible data loss.  You

can use ALTER TYPE to set the width of string variables to the width of the

longest observed value for each string variable.

DATASET NAME DataSet6 WINDOW=FRONT.

DATASET ACTIVATE DataSet4.

DEFINE elaborate

( Y = !CHAREND('/') /

   RowVar = !CHAREND('/') /

   ColVar = !CMDEND )

  CTABLES

  /TABLE !RowVar  [C] >  !ColVar [C] by !Y [c] [ROWPCT.COUNT f5.1 "%" ] totals [count "n= 100%"]]

  /SLABELS POSITION=ROW VISIBLE=NO

  /CATEGORIES VARIABLES= !y  TOTAL=YES

  /TITLES CAPTION ='NOTE:  Cells show ROWPCT and Row COUNT'.

!ENDDEFINE.

* Read in some data to illustrate.

* Modify path on the FILE HANDLE command as needed.

FILE HANDLE TheDataFile /NAME='C:\Users\John\Desktop\gss_2016\babbie2019jfh.sav'.

new file.

close all.

 

Error # 1.  Command name: close

The first word in the line is not recognized as an SPSS Statistics command.

Execution of this command stops.

get file thedatafile.

 

Error # 61 in column 10.  Text: thedatafile

The filename is not valid.

Execution of this command stops.

 

* Call the macro.

elaborate Y = abany / RowVar = postlife / ColVar = vote12.

 

Error # 105.  Command name: CTABLES

This command is not valid before a working file has been defined.

Execution of this command stops.

DATASET ACTIVATE DataSet4.

FILE HANDLE TheDataFile /NAME='C:\Users\John\Desktop\gss_2016\babbie2019jfh.sav'.

new file.

dataset close all.

get file thedatafile.

 

Error # 61 in column 10.  Text: thedatafile

The filename is not valid.

Execution of this command stops.

 

* Call the macro.

elaborate Y = abany / RowVar = postlife / ColVar = vote12.

 

Error # 105.  Command name: CTABLES

This command is not valid before a working file has been defined.

Execution of this command stops.

GET

  FILE='H:\F drive backup\Research1a\4 Surveys\British Social Attitudes\2018\bsa2018b.sav'.

DATASET NAME DataSet7 WINDOW=FRONT.

FILE HANDLE TheDataFile /NAME='C:\Users\John\Desktop\gss_2016\bsa2018b.sav'.

new file.

dataset close all.

get file 'thedatafile'.

 

Error # 61 in column 10.  Text: thedatafile

The filename is not valid.

Execution of this command stops.

elaborate Y = abany / RowVar = postlife / ColVar = vote12.

 

Error # 105.  Command name: CTABLES

This command is not valid before a working file has been defined.

Execution of this command stops.

FILE HANDLE TheDataFile /NAME='C:\Users\John\Desktop\gss_2016\bsa2018b.sav'.

 

NEW FILE.

 

DATASET CLOSE all.

 

GET FILE = "TheDataFile".

 

Error # 61 in column 12.  Text: TheDataFile

The filename is not valid.

Execution of this command stops.

GET FILE = TheDataFile.

 

Error # 61 in column 12.  Text: TheDataFile

The filename is not valid.

Execution of this command stops.

* Read in some data to illustrate.

* Modify path on the FILE HANDLE command as needed.

FILE HANDLE TheDataFile /NAME='C:\Users\John\Desktop\gss_2016\babbie2019.sav'.

NEW FILE.

 

* Call the macro.

elaborate Y = abany / RowVar = postlife / ColVar = vote12.

 

Error # 105.  Command name: CTABLES

This command is not valid before a working file has been defined.

Execution of this command stops.

GET

  FILE='C:\Users\JohnPC\Desktop\GSS_2016\babbie2019jfh.sav'.

DATASET NAME DataSet8 WINDOW=FRONT.

 

 

 

 

John F Hall MA (Cantab) Dip Ed (Dunelm)

IBM-SPSS Academic Author 9900074

 

Email: [hidden email]

Website: Journeys in Survey Research

Course: Survey Analysis Workshop (SPSS)

 

===================== 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
Reply | Threaded
Open this post in threaded view
|

Re: Elaboration macro

Bruce Weaver
Administrator
John, where you wrote:

new file.
close all.

...change it to:

new file.
DATASET close all.



John F Hall wrote
> Bruce
> I've been trying to modify the elaboration macro:
>
> --- snip ---





-----
--
Bruce Weaver
[hidden email]
http://sites.google.com/a/lakeheadu.ca/bweaver/

"When all else fails, RTFM."

NOTE: My Hotmail account is not monitored regularly.
To send me an e-mail, please use the address shown above.

--
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
--
Bruce Weaver
bweaver@lakeheadu.ca
http://sites.google.com/a/lakeheadu.ca/bweaver/

"When all else fails, RTFM."

NOTE: My Hotmail account is not monitored regularly.
To send me an e-mail, please use the address shown above.