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

  GenStat  ~  spreadsheet pointers

guillermohough
Posted: Mon Aug 13, 2018 10:25 pm Reply with quote
Joined: 25 Aug 2008 Posts: 28 Location: Nueve de Julio- Argentina
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] En nombre de David Baird
Enviado el: lunes, 13 de agosto de 2018 05:04 p.m.
Para: 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> On Behalf Of Linc Schmitt
Sent: 13 August 2018 11:52 PM
To: 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

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

_________________
Guillermo Hough
Argentina
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