Denton benchmarking method (xlpbm) ?

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

Denton benchmarking method (xlpbm) ?

fatmayuliana
This post has NOT been accepted by the mailing list yet.
Hello.
I want to ask you about denton method.

In Ms. Excel, there is a formula (xlpbm) to do a denton method.

Is in SPSS provide syntax or package to access denton method?

Thank you for your concern.

Best regards,


Fatma
Reply | Threaded
Open this post in threaded view
|

Re: Denton benchmarking method (xlpbm) ?

Bruce Weaver
Administrator
I'm replying mainly because Fatma's post to Nabble has apparently not yet
been circulated to the mailing list.  While I'm at it, though, here are a
couple links that may be helpful to others who have never heard of the
Denton method.

https://www.imf.org/external/pubs/ft/wp/2012/wp12169.pdf
https://www.imf.org/external/pubs/ft/qna/pdf/Benchmarking-Reconciliation_C6_Draft.pdf
https://cran.r-project.org/web/packages/tempdisagg/tempdisagg.pdf



fatmayuliana wrote

> Hello.
> I want to ask you about denton method.
>
> In Ms. Excel, there is a formula (xlpbm) to do a denton method.
>
> Is in SPSS provide syntax or package to access denton method?
>
> Thank you for your concern.
>
> Best regards,
>
>
> Fatma





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

Re: Denton benchmarking method (xlpbm) ?

Jon Peck
The STATS DISAGG extension command available via the Utilities or Extensions menu depending on the Statistics version disaggregates a time series into higher frequencies using one of several methods.  From the syntax help:

CONVERSIONTYPE (optional) specifies the relationship of the disaggregated values to the original. SUM and AVERAGE specify that the sum or average of the entire disaggregated series equals the corresponding statistic for the low frequency series. FIRST and LAST specify that the first or last value of the disaggregated series equals the corresponding value of the low frequency series.

CONVERSIONMETHOD (optional) specifies the conversion algorithm. The Chow-Lin, Litterman, and Fernandez methods (with variations) use generalized least squares of the low frequency variable on the aggregated values of the high frequency series and then distribute the differences in the result across the quarterly values. The estimated relationship between the low frequency series (actual and aggregated) is assumed to hold also for the high frequency series. The GLS estimators include estimation of an autoregression parameter, rho. The OLS method does ordinary least squares (with no autocorrelation parameter). These methods all require at least one high frequency indicator.

The remaining methods (Denton type) can be used with or without an indicator variable and minimize the sum of squared deviations of the low and high frequency series using two additional parameters. Only one indicator variable is allowed.


STATS DISAGG requires the R Essentials.


On Sun, Sep 17, 2017 at 7:02 PM, Bruce Weaver <[hidden email]> wrote:
I'm replying mainly because Fatma's post to Nabble has apparently not yet
been circulated to the mailing list.  While I'm at it, though, here are a
couple links that may be helpful to others who have never heard of the
Denton method.

https://www.imf.org/external/pubs/ft/wp/2012/wp12169.pdf
https://www.imf.org/external/pubs/ft/qna/pdf/Benchmarking-Reconciliation_C6_Draft.pdf
https://cran.r-project.org/web/packages/tempdisagg/tempdisagg.pdf



fatmayuliana wrote
> Hello.
> I want to ask you about denton method.
>
> In Ms. Excel, there is a formula (xlpbm) to do a denton method.
>
> Is in SPSS provide syntax or package to access denton method?
>
> Thank you for your concern.
>
> Best regards,
>
>
> Fatma





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



--
Jon K Peck
[hidden email]

===================== 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: Denton benchmarking method (xlpbm) ?

fatmayuliana
This post has NOT been accepted by the mailing list yet.
"STATS DISAGG requires the R Essentials"

What does it mean?

Does it mean that i should have R? And install R? And operate it on R?

Or i must install R but operate in on SPSS?
Reply | Threaded
Open this post in threaded view
|

Re: Denton benchmarking method (xlpbm) ?

Bruce Weaver
Administrator
R may be installed already--when I installed v25 recently, it was an option
in the installation dialog.  Jon can probably tell you how to check quickly.  

If the R Essentials have not been installed, here are some instructions:

https://www.ibm.com/support/knowledgecenter/en/SSFUEU_7.2.0/com.ibm.swg.ba.cognos.op_capmod_ig.7.2.0.doc/t_essentials_for_r_statistics.html

HTH.



fatmayuliana wrote
> "STATS DISAGG requires the R Essentials"
>
> What does it mean?
>
> Does it mean that i should have R? And install R? And operate it on R?
>
> Or i must install R but operate in on SPSS?





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

Re: Denton benchmarking method (xlpbm) ?

Jon Peck
Here are details on setting up for procedures implemented in R as STATS DISAGG is.


Since this is an extension command, it works just like regular Statistics built-in commands, but it needs the correct version of R and the R Essentials to be installed first, after which you can add any of 50 or so R-based extension commands via the Extensions > Extension Hub menu (v24 and later) or the Utilities menu in V22-23.

Bruce,
Was installing R itself really an option when you installed Statistics 25?  It's an option for Python, but I didn't think R was treated that way.  There is now an extension command for installing the R Essentials, though.

On Mon, Sep 18, 2017 at 12:28 PM, Bruce Weaver <[hidden email]> wrote:
R may be installed already--when I installed v25 recently, it was an option
in the installation dialog.  Jon can probably tell you how to check quickly.

If the R Essentials have not been installed, here are some instructions:

https://www.ibm.com/support/knowledgecenter/en/SSFUEU_7.2.0/com.ibm.swg.ba.cognos.op_capmod_ig.7.2.0.doc/t_essentials_for_r_statistics.html

HTH.



fatmayuliana wrote
> "STATS DISAGG requires the R Essentials"
>
> What does it mean?
>
> Does it mean that i should have R? And install R? And operate it on R?
>
> Or i must install R but operate in on SPSS?





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



--
Jon K Peck
[hidden email]

===================== 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: Denton benchmarking method (xlpbm) ?

Bruce Weaver
Administrator
Hi Jon.  I can't remember for certain, but I thought it was there.  

HOWEVER, when I now click on Extensions > Extension Hub, and try to install
any extension command that uses R, the "Get extension" check-box is
inactive, and I cannot install anything.  I suppose that means I do *not*
have the R Essentials installed.  I must be thinking of the option to
install Python automatically.  (I do have R installed, by the way, but
probably not the version required to match my SPSS.)

You wrote:  "There is now an extension command for installing the R
Essentials, though."

What's it called?  STATS_R33_CONFIGURATION?

Bruce




Jon Peck wrote
> Bruce,
> Was installing R itself really an option when you installed Statistics 25?
> It's an option for Python, but I didn't think R was treated that way.
> There is now an extension command for installing the R Essentials, though.
>
> On Mon, Sep 18, 2017 at 12:28 PM, Bruce Weaver &lt;

> bruce.weaver@

> &gt;
> wrote:
>
>> R may be installed already--when I installed v25 recently, it was an
>> option
>> in the installation dialog.  Jon can probably tell you how to check
>> quickly.
>>
>> If the R Essentials have not been installed, here are some instructions:
>>
>> https://www.ibm.com/support/knowledgecenter/en/SSFUEU_7.2.
>> 0/com.ibm.swg.ba.cognos.op_capmod_ig.7.2.0.doc/t_
>> essentials_for_r_statistics.html
>>
>> HTH.
>>
>>
>>
>> fatmayuliana wrote
>> > "STATS DISAGG requires the R Essentials"
>> >
>> > What does it mean?
>> >
>> > Does it mean that i should have R? And install R? And operate it on R?
>> >
>> > Or i must install R but operate in on SPSS?
>>
>>
>>
>>
>>
>> -----
>> --
>> Bruce Weaver
>>

> bweaver@

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

> LISTSERV@.UGA

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

> jkpeck@

>
> =====================
> To manage your subscription to SPSSX-L, send a message to

> LISTSERV@.UGA

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

Re: Denton benchmarking method (xlpbm) ?

Bruce Weaver
Administrator
Okay, I answered my own question.  After I installed R 3.3.3 (the version
required for SPSS 25), I was able to execute STATS_R33_CONFIGURATION:

STATS R33 CONFIGURATION R_HOME="C:\Program Files\R\R-3.3.3\".

And after that, I was able to install some R-dependent extension commands.

In case others are looking, old R-versions (for Windows) can be found here:  

   https://cran.r-project.org/bin/windows/base/old/



Bruce Weaver wrote

> Hi Jon.  I can't remember for certain, but I thought it was there.  
>
> HOWEVER, when I now click on Extensions > Extension Hub, and try to
> install
> any extension command that uses R, the "Get extension" check-box is
> inactive, and I cannot install anything.  I suppose that means I do *not*
> have the R Essentials installed.  I must be thinking of the option to
> install Python automatically.  (I do have R installed, by the way, but
> probably not the version required to match my SPSS.)
>
> You wrote:  "There is now an extension command for installing the R
> Essentials, though."
>
> What's it called?  STATS_R33_CONFIGURATION?
>
> Bruce
>
>
>
>
> Jon Peck wrote
>> Bruce,
>> Was installing R itself really an option when you installed Statistics
>> 25?
>> It's an option for Python, but I didn't think R was treated that way.
>> There is now an extension command for installing the R Essentials,
>> though.
>>
>> On Mon, Sep 18, 2017 at 12:28 PM, Bruce Weaver &lt;
>
>> bruce.weaver@
>
>> &gt;
>> wrote:
>>
>>> R may be installed already--when I installed v25 recently, it was an
>>> option
>>> in the installation dialog.  Jon can probably tell you how to check
>>> quickly.
>>>
>>> If the R Essentials have not been installed, here are some instructions:
>>>
>>> https://www.ibm.com/support/knowledgecenter/en/SSFUEU_7.2.
>>> 0/com.ibm.swg.ba.cognos.op_capmod_ig.7.2.0.doc/t_
>>> essentials_for_r_statistics.html
>>>
>>> HTH.
>>>
>>>
>>>
>>> fatmayuliana wrote
>>> > "STATS DISAGG requires the R Essentials"
>>> >
>>> > What does it mean?
>>> >
>>> > Does it mean that i should have R? And install R? And operate it on R?
>>> >
>>> > Or i must install R but operate in on SPSS?
>>>
>>>
>>>
>>>
>>>
>>> -----
>>> --
>>> Bruce Weaver
>>>
>
>> bweaver@
>
>>> 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
>>>
>
>> LISTSERV@.UGA
>
>>  (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
>
>> jkpeck@
>
>>
>> =====================
>> To manage your subscription to SPSSX-L, send a message to
>
>> LISTSERV@.UGA
>
>>  (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@

> 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

> LISTSERV@.UGA

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

Re: Denton benchmarking method (xlpbm) ?

fatmayuliana
This post has NOT been accepted by the mailing list yet.
Wow. Thank you Mr. Jon and Mr. Bruce.

But, i think firstly i have to learn R and how it works on SPSS. So that i can doing STATS_DISAGG clearly.
I'll read that instructions and what packages should i have first.

Best Regards,


Fatma
Reply | Threaded
Open this post in threaded view
|

Re: Denton benchmarking method (xlpbm) ?

David Marso
Administrator
You really don't need to learn R to use the extensions.
It basically operates behind the scenes.


fatmayuliana wrote

> Wow. Thank you Mr. Jon and Mr. Bruce.
>
> But, i think firstly i have to learn R and how it works on SPSS. So that i
> can doing STATS_DISAGG clearly.
> I'll read that instructions and what packages should i have first.
>
> Best Regards,
>
>
> Fatma





-----
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me.
---
"Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis."
Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?"
--
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
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me.
---
"Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis."
Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?"
Reply | Threaded
Open this post in threaded view
|

Re: Denton benchmarking method (xlpbm) ?

fatmayuliana
This post has NOT been accepted by the mailing list yet.
Really?

Okay, i'll try it through the instructions.

Thank you for your help Mr. David.