Re: By statement

From: GRIGNOLA, FERNANDO E [AG/6042] <fernando.e.grignola_at_MONSANTO.COM>
Date: Wed, 19 Aug 2009 22:36:25 +0200

Hi Yoon,

To convert the outputs into excel my suggestion would be to use, for
example, Spreadsheet::WriteExcel in Perl. It's not user friendly, but
you can generate multiple workbooks with different worksheets, etc. If
you want, I can provide you some sample code.

Also, depending on the content of the file you want to process, you may
consider using simpler but very powerful Unix tools like sed/awk, or a
combination, to create a txt file that can then be read by Excel.






From: ASReml users discussion group [mailto:ASREML-L_at_DPI.NSW.GOV.AU] On
Behalf Of maize92
Sent: Wednesday, August 19, 2009 9:42 PM
Subject: By statement



Is there any option in ASReml-W similar to the "By" statement in proc
mixed of SAS? I would want to fit a few models to a simulated data set
in which
each of say 1000 simulated data is coded with id number under variable
name "ID". I do not want to make 1000 seperate data sets and run the
models 1000 times manually. if there's no such options available, I
would like to be
advised how to go around for this type of simulation study done with
ASReml. Also how to convert outputs from 1000 runs into excel or sas
data table less manually.




-------------------- m2f --------------------

Sent using Mail2Forum (

Read this topic online here:

-------------------- m2f --------------------


This message is intended for the addressee named and may contain
confidential information. If you are not the intended recipient, please
delete it and notify the sender. Views expressed in this message are
those of the individual sender, and are not necessarily the views of
their organisation.


This e-mail message may contain privileged and/or confidential information, and is intended to be received only by persons entitled to receive such information. If you have received this e-mail in error, please notify the sender immediately. Please delete it and all attachments from any servers, hard drives or any other media. Other use of this e-mail by you is strictly prohibited.

All e-mails and attachments sent and received are subject to monitoring, reading and archival by Monsanto, including its subsidiaries. The recipient of this e-mail is solely responsible for checking for the presence of "Viruses" or other "Malware". Monsanto, along with its subsidiaries, accepts no liability for any damage caused by any such code transmitted by or accompanying this e-mail or any attachment.
Received on Thu Aug 19 2009 - 22:36:25 EST

This webpage is part of the ASReml-l discussion list archives 2004-2010. More information on ASReml can be found at the VSN website. This discussion list is now deprecated - please use the VSN forum for discussion on ASReml. (These online archives were generated using the hypermail package.)