Bill, I've done somewhat similar work in the cotton sector. It's been a few years and my analytical/data-modeling skills are better (hopefully, my (self-)management capabilities are better as well). Anyway, if you'd like, we could carry on this thread intermittently, either by direct e-mail or via the listserv, if there is the possibility f/mutually beneficial sharing of info. I've picked up experience and ideas on data-entry versus interviewing versus statistics versus SQL ...
Anyway, if you'd like, I can give you an example of what I'm talking about. I'm only "cagey" about this because I think I've come up w/a (data) model that's pretty good, if not fully mature/evolved, and I flatter myself to think that nobody else has arrived at something similar. It is this model which makes me very interested in the column-to-row/matrix-transformation capabilities of SQL/SAS/SPSS. Also, there's another regular listserv member who manages crab population counts in Alaska. No insult to him, but, although we've had meaningful dialogue, I can't recollect his name - I'm bad w/names, but very good w/faces, so you "see" my problem w/e-mail is that I can't see! He apparently does something similar to what y'all are doing. Anyway, let me know. Thanks, Steve in Memphis > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > Behalf Of Bill Niehaus > Sent: Thursday, June 27, 2002 8:10 AM > To: [EMAIL PROTECTED] > Subject: RE: Export from Rbase Win 6.5++ to SAS > > > I am in charge of our variety trial testing system which evaluates > hybrids from seed companies prior to their being grown by our commercial > growers. We collect data from 7 or 8 locations for a commercial growing > region of about 200 miles by 50 miles. We have utilized lattice field > designs for a number of years in an attempt to reduce environmental > error effects on our evaluations. I believe we use fairly straight > forward classical statistical analysis for our data analysis. > > Bill > > > > >>> [EMAIL PROTECTED] 6/26/2002 3:56:00 PM >>> > Bill, if I may ask, what type of work does this/your organization do? > I ask > because we do lots of survey research as well as data analysis in my > group. > This issue of de-normalized data f/the researchers vs normalized data > f/acquisition (interviewing/data-entry) is one we haven't had to cross > yet, > but the time is drawing nigh. We use SPSS f/the most part, but we also > use > SAS. I have a G/A who's pretty well-versed there, so I can bounce the > Q off > her. > > I'll be watching this thread closely. > > Later, > Steve in Memphis > > ... okay, where in Memphis ... > > Bureau of Business & Economic Research/Center for Manpower > Studies > (BBER/CMS) > University of Memphis > > SW > > > -----Original Message----- > > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On > > Behalf Of Bill Niehaus > > Sent: Wednesday, June 26, 2002 3:18 PM > > To: [EMAIL PROTECTED] > > Subject: Export from Rbase Win 6.5++ to SAS > > > > > > I am converting a database to Rbase (from a compiled basic program) > and > > one of it's features is to send data to SAS. In the past, > exporting > > involved creating an ASCII file with column specified output. SAS > > would read it as follows: > > > > data BEETS01;infile BEETS01 lrecl=228 pad; > > input trial $ 3-8 year 3-4 plot $ 13-16 rep ccode 30-32 entryskip$ > > 33-48 > > stand 49 cr1 cr2 cr3 cr4 cr5 cr6 cr; > > > > > > Is there an option to get SAS to read information from Rbase which > > would avoid issues of having to get data into specific columns from > > Rbase for SAS to read (eg. CSV, XLS, DBF) ? I haven't had SAS read > > other file formats, so I am not certain which combination may be > easier > > for transferring from Rbase to SAS. > > > > Thanks. Bill > > > > > > ================================================ > > TO SEE MESSAGE POSTING GUIDELINES: > > Send a plain text email to [EMAIL PROTECTED] > > In the message body, put just two words: INTRO rbase-l > > ================================================ > > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > > In the message body, put just two words: UNSUBSCRIBE rbase-l > > ================================================ > > TO SEARCH ARCHIVES: > > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
