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

  GenStat  ~  spreadsheet pointers

Linc Schmitt
Posted: Tue Aug 14, 2018 1:11 am Reply with quote
Joined: 24 Jun 2011 Posts: 536
Hi David,

Thanks for this – and especially pointing out the different behaviour according to how the spreadsheet is accessed. Apologies for the last word in my original enquiry, which must have been cryptic to any reader - “replaced” should have been “reloaded”!

I noticed, when trying to solve this problem, the OUTOPTIONS option of EXPORT and IMPORT. Is there more documentation on these other than what is given in the description of IMPORT?

Regards,

Linc


From: GENSTAT-Request <GENSTAT@jiscmail.ac.uk> On Behalf Of David Baird
Sent: Tuesday, 14 August 2018 7:59 AM
To: GENSTAT@JISCMAIL.AC.UK
Subject: Re: spreadsheet pointers



Dear Guillermo,

I assumed that Linc’s spreadsheet is likely to have more rows than columns
in the pointer, and thus the bottom cells of the text column giving the
pointer names will be empty. The SUBSET is required to remove these empty cells,
otherwise FPOINTER will fault. I just set up some example data that will mimic
the sort of data in the text column in the spreadsheet.

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 (GENSTAT@jiscmail.ac.uk)> On Behalf Of Guillermo Hough
Sent: 14 August 2018 10:25 AM
To: GENSTAT@JISCMAIL.AC.UK (GENSTAT@JISCMAIL.AC.UK)
Subject: Re: spreadsheet pointers



David,
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,
Guillermo

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 (GENSTAT@jiscmail.ac.uk)] En nombre de David Baird
Enviado el: lunes, 13 de agosto de 2018 05:04 p.m.
Para: GENSTAT@JISCMAIL.AC.UK (GENSTAT@JISCMAIL.AC.UK)
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 (GENSTAT@jiscmail.ac.uk)> On Behalf Of Linc Schmitt
Sent: 13 August 2018 11:52 PM
To: GENSTAT@JISCMAIL.AC.UK (GENSTAT@JISCMAIL.AC.UK)
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.

Thanks,

Linc Schmitt



To unsubscribe from the GENSTAT list, click the following link:
https://www.jiscmail.ac.uk/cgi-bin/webadmin?SUBED1=GENSTAT&A=1


To unsubscribe from the GENSTAT list, click the following link:
https://www.jiscmail.ac.uk/cgi-bin/webadmin?SUBED1=GENSTAT&A=1


To unsubscribe from the GENSTAT list, click the following link:
https://www.jiscmail.ac.uk/cgi-bin/webadmin?SUBED1=GENSTAT&A=1

Post generated using Mail2Forum (http://www.mail2forum.com)
View user's profile Send private message

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