SPSSX Discussion

mysterious gpl question

Classic

List

Threaded

4 messages Options

mpirritano

mysterious gpl question

gpellers

Since I can never find an answer to my gpl questions from any manual. My data for “Office Visits” doesn’t start at the same time as the rest of the data. I want my regression line to start with it’s data, not before.

I’m guessing I need to use the missing.gap function. Within the missing.gap() apostrophes what are the possible arguments. Here’s my syntax:

OMS

/SELECT CHARTS WARNINGS

/DESTINATION FORMAT=XLS

OUTFILE='D:/Data/Utilization/ute_pos_20091021.xls'.

GGRAPH

/GRAPHDATASET NAME="graphdataset"

VARIABLES=month_year ed_1000 office_1000 outpatient_1000 in_days_1000

MISSING=VARIABLEWISE REPORTMISSING=NO

/GRAPHSPEC SOURCE=INLINE.

BEGIN GPL

PAGE: begin(scale(1000px,500px)) SOURCE: s=userSource(id("graphdataset"))

DATA: month_year=col(source(s), name("month_year"))

DATA: ed_1000=col(source(s), name("ed_1000"))

DATA: office_1000=col(source(s), name("office_1000"))

DATA: outpatient_1000=col(source(s), name("outpatient_1000"))

DATA: in_days_1000=col(source(s), name("in_days_1000"))

TRANS: month_year_ed_1000=eval("ED visits per 1000")

TRANS: month_year_office_1000=eval("Office visits per 1000")

TRANS: month_year_outpatient_1000=eval("Outpatient visits per 1000")

TRANS: month_year_in_days_1000=eval("Inpatient days per 1000")

SCALE: cat(aesthetic(aesthetic.color), map(("ED visits per 1000", color.forestgreen),

("Office visits per 1000", color.orange), ("Outpatient visits per 1000", color.mediumvioletred),

("Inpatient days per 1000", color.blue)))

GUIDE: text.title(label("Utilization per 1000 Members by Place of Service"))

GUIDE: axis(dim(1), label("Time"))

GUIDE: axis(dim(2), label("Visits/ Days(for Inpatient Days) per 1000"))

ELEMENT: point(position(month_year*ed_1000), color(color.forestgreen))

ELEMENT: point(position(month_year*office_1000), color(color.orange))

ELEMENT: point(position(month_year*outpatient_1000), color(color.mediumvioletred))

ELEMENT: point(position(month_year*in_days_1000), color(color.blue))

ELEMENT: line(position(smooth.linear(month_year*ed_1000)), color.interior("ED visits per 1000"), size(size."2%"))

ELEMENT: line(position(smooth.linear(month_year*office_1000)), color.interior("Office visits per 1000"), size(size."2%"))

ELEMENT: line(position(smooth.linear(month_year*outpatient_1000)), color.interior("Outpatient visits per 1000"), size(size."2%"))

ELEMENT: line(position(smooth.linear(month_year*in_days_1000)), color.interior("Inpatient days per 1000"), size(size."2%"))

PAGE: end()

END GPL.

OMSEND.

Any help much appreciated!

Thanks

matt

Matthew Pirritano, Ph.D.

Research Analyst IV

Medical Services Initiative (MSI)

Orange County Health Care Agency

(714) 568-5648

ViAnn Beadle

Re: mysterious gpl question

Here’s the definition of missing.gap:

Specifies that the graphic element ends at a valid value and does not continue until the next valid value. There is a gap between valid values.

Note that missing.gap takes no arguments at all. It only affects what happens with gaps within the variable, not across variables.

If I understand what you’re saying here is that some of variables have values earlier on the X axis than your Office Visits variable and that you want all values to start at that time? Depending upon the data structure you might try using listwise missing value deletion or filter the data before passing it to GGRAPH. Otherwise, give us a small sample dataset to look at.

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Pirritano, Matthew
Sent: Wednesday, October 21, 2009 10:51 AM
To: [hidden email]
Subject: mysterious gpl question