[vsni.co.uk] Contact us
Author Message
Post new topic

  GenStat  ~  spreadsheet pointers

Posted: Mon Aug 13, 2018 10:25 pm Reply with quote
Joined: 25 Aug 2008 Posts: 28 Location: Nueve de Julio- Argentina
I don’t see the point of the 4(‘’) in the following statement of your code:

TEXT TPointer; VALUES=!T(A,B,C,D,4(''))

Thank you,

Dr. Guillermo Hough
Investigador Emrito
Comisin de Investigaciones Cientficas de la Provincia de Buenos Aires
9 de Julio- Buenos Aires- Argentina
Telfono: 02317 524140

De: GENSTAT-Request [mailto:GENSTAT@jiscmail.ac.uk] En nombre de David Baird
Enviado el: lunes, 13 de agosto de 2018 05:04 p.m.
Asunto: Re: spreadsheet pointers

Dear Linc,

Sorry you cannot do this by commands. The client can add pointers interactively
to a spreadsheet file with the Spread | Sheet | Pointers menu. This can be to any
set of columns if you make a column selection first. However, these pointers are
only created when you open the spreadsheet in the client, rather loading it
directly to the server with SPLOAD. But if you install the Biometris library
(from https://www.wur.nl/en/product/Biometris-GenStat-Procedure-Library-Edition-19.htm),
you could add a text column containing the names of the columns to be in the pointer
to the spreadsheet and convert it to a pointer with the FPOINTER command.
Here’s some code that demonstrates this:

VARIATE A,B,C,D; VALUES=!(1...9)+0,10,20,30
TEXT TPointer; VALUES=!T(A,B,C,D,4(''))
SUBSET [TPointer.ni.''] TPointer
FPOINTER TPointer; Pointer
PRINT Pointer[]; DEC=0

Regards, David.
Dr David Baird Statistical Consultant and GenStat Developer
VSN (NZ) Limited (David@VSN.CO.NZ (David@VSN.CO.NZ))
8 Mariposa Crescent, Aidanfield, Christchurch 8025, New Zealand
Ph +64 3 3350588 Cell +64 21 1160803

From: GENSTAT-Request <GENSTAT@jiscmail.ac.uk> On Behalf Of Linc Schmitt
Sent: 13 August 2018 11:52 PM
Subject: spreadsheet pointers

Just using the command language, is there a way to save pointers that contain subsets of vectors in a spreadsheet, as spreadsheet pointers? FSPREADSHEET can save a pointer to all the vectors in a spreadsheet via the POINTER option. I really want to save a series of pointers to various subgroups, that would then be available when the spreadsheet is replaced.


Linc Schmitt

To unsubscribe from the GENSTAT list, click the following link:

Post generated using Mail2Forum (http://www.mail2forum.com)

Guillermo Hough
View user's profile Send private message Send e-mail Visit poster's website

Display posts from previous:  

All times are GMT
Page 1 of 1
Post new topic

Jump to:  

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum