HDTenEightyP/NetNews huggingface dataset:
Newsgroups: bit.listserv.sas-l
Subject: date arithmatic
From: paed1@otago.ac.nz
Date: 3 Oct 92 20:04:07 +1300
Organization: University of Otago, Dunedin, New Zealand

	Does anyone know how to do date arithmatic
(e.g. number of days between 29 feb 1991 and 29 feb 1992)
with sas variables (that is simply ..)
	thanks

Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sas-l
Date:         Wed, 30 Sep 1992 09:01:00 PST
Reply-To:     Bert Cave <Bert_Cave@CCM.HF.INTEL.COM>
From:         Bert Cave <Bert_Cave@CCM.HF.INTEL.COM>
Subject:      Re: SAS on UNIX or SAS on PC
Comments: To: Thomas_M_Skinner@ccm.hf.intel.com,
              Ski_Taniguchi@ccm.hf.intel.com, SAS-L@uga.cc.uga.edu

<hello sasusers..i have just been introduced to this group by my
<guru, joe kelley, and am anxiously seeking insight.
<
<I am working with a small company which currently has an IBM RS6000
<with 2 400 mg disks and 1 670 mg disk and operates with 32 mg RAM.
<They run under a unix operating system.  I work with a small
<division of the company which is managing and beginning to analyze
<large, and growing, datasets.  This is the only division which will
<ever use
<SAS with a future maximum of three users at any one time.
<We have currently been running with PCSAS but have now been approached
<to move to the unix system.
<
<I will hopefullyy be running little sas programs such as
<factor analyses with over 1,000 people and 100 or so
<variables. I would love some insight about what I can expect
<to encounter
<when I try this in the PC environment as well as what will
<happen to the 34 or so word processing and accounting-type
<people who are currently working on the unix system when I do my
<act.
<
<I understand the power that can be gained if we move to the unix
<system but I have no control over that machine and would hate to
<have my access limited because I might irritate a smoothly running
<system.
<
<There is only one person responsible for the mainframe operations
<and she is unfamiliar with SAS.  As I'm sure many of you know,
<this is an expensive decision and I would like as much information
<as possible so that we don't bite off more than we can chew.  SAS
<has always been more than a mouthful for me and I've only been
<quiet, sas-loving, sas-hating, graduate student.  I never had to
<worry about system/hardware issues; those are joe's problems.
<
<I greatly appreciate any insights.  Thanks.
<
<Andee
===============================================================
At Intel, we have been alpha (now beta) testing SAS for Windows for many months.
It is a solid product, already.  With Windows being, pretty clearly, the market
winner for user interface, we think SAS for Windows is a very good bet.  With
DDE and OLE capabilities, SAS can exchange data with other Windows products,
including word processing, spreadsheet, ... software packages.  SAS Institute is
also working on an interface to Microsoft/Sybase SQL Server, which will allow
SAS to work in tandem with other front end tools which read/write SQL Server
data.
Bert Cave
SAS Product Manager
Intel Corp.
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
X-Envelope-to: SAS-L@AWIIMC12.BITNET
X-Mailer: ELM [version 2.2 PL0]
Newsgroups: bit.listserv.sas-l
Date:         Fri, 2 Oct 1992 13:15:09 EDT
Reply-To:     Daryl P Sawders <DARYL@PITTUNIX.BITNET>
From:         Daryl P Sawders <DARYL@PITTUNIX.BITNET>
Subject: ?? PROC FORMS w/ ByGroups ??

Hi All.

I've got a process that uses PROC FORMS to create labels.  It works
quite well but, now I'd like to improve the process.  Just before I use
PROC FORMS, I do some data manipulation that takes 25 minutes if I'm
doing it for the whole dataset or just a subset.  Herein lays the
problem...  What I'd like to do is have the PROC FORMS put out the
initial alignment forms whenever a BY GROUP variable changes.

Any ideas??

TIA.

   - Daryl -
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sas-l
Date:         Fri, 2 Oct 1992 12:00:05 PST
Reply-To:     Bert Cave <Bert_Cave@CCM.HF.INTEL.COM>
From:         Bert Cave <Bert_Cave@CCM.HF.INTEL.COM>
Subject:      Re[2]: SAS on UNIX or SAS on PC
Comments: To: Ski_Taniguchi@ccm.hf.intel.com,
              Thomas_M_Skinner@ccm.hf.intel.com, SAS-L@uga.cc.uga.edu

To Jim at Notre Dame,
"Even at Intel," we think you might want to take a closer look at
Windows NT, which, from what we have seen is a pretty powerful base.
In fact, SAS Institute will be running SAS on NT at Comdex.  Given
SAS' portability, we also have some folks developing on OS/2 for
clients or servers which will be running Windows (in some variety).
The nice thing is that SAS runs on enough platforms that we can have
this argument, at all!
Bert Cave@CCM.HF.INTEL.COM
Intel Corp.
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sas-l
Date:         Tue, 29 Sep 1992 09:01:51 EDT
Reply-To:     "F.Joseph Kelley" <JKELLEY@UGA.BITNET>
From:         "F.Joseph Kelley" <JKELLEY@UGA.BITNET>
Subject:      (simulated) BY-variables in PROC REPORT

SAS Version 6.07   MVS

Hello Net,
I have been asked about a problem some of our users are having using
PROC REPORT:  they wish to produce reports interactively (actually
via ASSIST) and need certain information from the data to be a part
of the title.  In, say, PROC PRINT you could specify a BY-variable
and link that variable to a format that would print out a nice title
that would specify the department the figures corresponded to (History,
Electronics Shop, Physical Plant, whatever).  It seems REPORT does not
allow BY-variables except in batch jobs.  I have used REPORT only a
few times, and cannot claim any real familiarity with it, but this SEEMS
like something it could/should do.  For those who have read this far, I
will add that the request comes from our ADP folks who are moving
from QMF (accessing DB2 files) to using SAS/ACCESS to do the same
(as well as IMS files)....they say QMF will do this.  Anyone else
encountered this problem with REPORT?  Solutions, hints, suggestions
and related war stories are gratefully appreciated.
--Joe Kelley
  University Computing               BIT:   jkelley@uga
  University of Georgia              Int:   jkelley@uga.cc.uga.edu
  Athens, GA      30602
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sas-l
Date:         Sat, 26 Sep 1992 22:56:20 EST
Reply-To:     Evan Cooch <ECOOCH@PENNSAS.UPENN.EDU>
From:         Evan Cooch <ECOOCH@PENNSAS.UPENN.EDU>
Subject:      further on 6.07 under AIX / nohup
Comments: To: sas-l%marist.bitnet@cunyvm.cuny.edu

Further on my problem on shunting a SAS job into the background, and then
exiting the system without terminating the program. When I try

NOHUP SAS PRGNAME & <enter>

the job successfully goes into the background.

However, when I try to exit, the system responds with

Jobs are still running.

I presume this is a warning that dire things will happen to my running jobs
if, in fact, I continue with this foolish attempt to exit. :-)

Still searching for a solution.

Thanks again in advance...

           _///_              +----------------------------+
           -. .-              |       Evan G. Cooch        |
           ( L )    \////     |   Department of Biology    |
         --(\=/)--  (   )     | University of Pennsylvania |
        /         \ /  /      | Philadelphia, Pennsylvania |
        I          V  /       |   Phone: (215) 898-7129    |
        I            /        |     FAX: (215) 898-8780    |
        I           /         |  ECOOCH@PENNSAS.UPENN.EDU  |
                              +----------------------------+
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
X-Envelope-to: sas-l@ohstvma.bitnet
X-VMS-To: SASL
Content-transfer-encoding: 7BIT
Newsgroups: bit.listserv.sas-l
Date:         Tue, 6 Oct 1992 11:25:00 -0700
Reply-To:     "Gary Pfeifer, Research & Information,
              492-6743" <PFEIFER_G@CUBLDR.COLORADO.EDU>
From:         "Gary Pfeifer, Research & Information,
              492-6743" <PFEIFER_G@CUBLDR.COLORADO.EDU>
Subject:      Avoiding having OBS set to 0 after an error
Comments: To: sas-l@ohstvma.bitnet

----------------------------------------------------------------------
content:  query
SUMMARY:  how to avoid having obs set to 0 after a non-fatal error
REL/PLTF: SAS 6.07, MVS/ESA, IBM309x clone
E-ADDR:   pfeifer_g@cubldr.colorado.edu
NAME:     Gary Pfeifer
PH/ADDR:  303/492-6743   Univ of Colorado   CB 108   Boulder CO 80302
----------------------------------------------------------------------

I have a batch job which uses the VTOC data for a disk volume to make
a list of the SAS data libraries on that volume, and then uses that list
to do a proc contents on each one, so that I can get a report on unused
space in each library.  Under 6.06, if I ran the job while one of those
libraries was in use, the job simply stopped processing that step, did not
add any statistics for that library to the output dataset,
and went on to the next library on the list.

In 6.07 however, OBS is set to zero which means the rest
of the list is not processed at all, and nothing is printed out for the
libraries which were processed  correctly.

It seems like there is an option which controls whether obs is set to zero
in such cases, but I cannot find it.

If there is no such option, does it make any sense to try setting obs back
to MAX, if I get a nonzero return code from the PROC Contents?

Gary
From: macq@miguel.llnl.gov (Don MacQueen)
Newsgroups: bit.listserv.sas-l
Subject: Re: Random sample of dataset
Date: 1 Oct 92 14:22:28 GMT
Organization: Lawrence Livermore National Laboratory

All the solutions I've seen posted so far select
approximately some specified percentage of the 
dataset, and work very well for this.

However, what if one wants to randomly select, say, exactly
10 obs from a dataset. You can't use any of the example
codes given so far, and just keep the first 10, 
because then not all obs are equally likely to be chosen.

One solution would be like this:

data tmp;
  set old;
  rann=ranuni(123454321);
  run;
proc sort;
  by rann;
  run;
data sample;
  set tmp (obs=10);
  run;

I'm sure there are other, probably better, solutions.
For instance, this could be very expensive if the
dataset is large. Now that I think about it, I can
see a way to use the same principal as the above
example, but avoid sorting the dataset itself.

-- 
---------------------------------------------------
Don MacQueen                   macq@miguel.llnl.gov
Lawrence Livermore Nat. Lab.
7000 East Ave., L-307          (510) 423-1062
Livermore, CA 94550
---------------------------------------------------
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Return-Path: <phil@wubios>
X-Mailer: ELM [version 2.3 PL11]
Newsgroups: bit.listserv.sas-l
Date:         Mon, 28 Sep 1992 12:52:19 CDT
Reply-To:     "(J. Philip Miller)" <phil@WUBIOS.WUSTL.EDU>
From:         "(J. Philip Miller)" <phil@WUBIOS.WUSTL.EDU>
Subject:      write for Observations
Comments: To: "(SAS Mailing List)" <SAS-L@ohstvma.ircc.ohio-state.edu>

A recent editon of Authorline, the Newsletter for Authors from SAS Institute,
indicates that they are now accepting articles from users for Observations,
the SAS technical journal.  Contact the Observations Technical Editor at SI
for more information.  There are certainly a number of SAS-L subscribers who
could share some of their store of knowledge to others.

-phil

--
     J. Philip Miller, Professor, Division of Biostatistics, Box 8067
	 Washington University Medical School, St. Louis MO 63110
     phil@wubios.WUstl.edu - Internet  (314) 362-3617 [362-2694(FAX)]
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sas-l
Date:         Wed, 30 Sep 1992 13:09:37 PDT
Reply-To:     "(P. Oldenkamp 5-4481)" <oldenkmp@ESPRESSO.BOEING.COM>
From:         "(P. Oldenkamp 5-4481)" <oldenkmp@ESPRESSO.BOEING.COM>
Subject:      Attachmate HGO and SAS 6.07
Comments: To: SAS-L@uga.cc.uga.edu

----------------------------------------------------------------------
CONTENT:  INFORMATION
REL/PLTF: 6.07/MVS
E-ADDR:   oldenkmp@ESPRESSO.boeing.com
NAME:     Paul OldenKamp
PHONE:    206-865-4481
----------------------------------------------------------------------
Last week I commented on the Tom Frenkel's posting on strange behavior
he had encountered using SAS 6.07(MVS) and Attachmate's Extra with the
Host Graphics Option(HGO).

I have found that the software being used by SI that worked was beta
software of a version that Attachmate has just released.  Users of
Attachmate HGO should call the Attachmate tech. support to report their
problems and to get information on upgrading.
----------------------------------------------------------------------
	       //  Paul OldenKamp
	      //   BCS Research and Technology          .
	     //    P. O. Box 24346, MS 7L-21            |\
	    //     Seattle, WA   98124-0346             | \____oo_
	   //==========================================((__|  /___>
	  //       ___ ___ ___ ___     __                  | //
	 //       /__//  //__  /  /\ //  _                 |//
	//       /__//__//__ _/_ /  //__/                  ''
       //
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
X-Acknowledge-To: <KENHARDY@UNCVM1>
Newsgroups: bit.listserv.sas-l
Date:         Fri, 2 Oct 1992 13:47:09 EDT
Reply-To:     Ken Hardy <KENHARDY@UNCVM1.BITNET>
From:         Ken Hardy <KENHARDY@UNCVM1.BITNET>
Subject:      Sampling a dataset

There's a review of several methods for selecting random samples of data sets
in Muller, Hardy and Brown, "Getting It and Keeping It with SAS(r) Software" in
the Proceedings of the 17'th Annual SUGI (1992) for those still interested in
pursuing this topic.

+-------------------------------------------------------------------------+
| Kenneth A. Hardy                      |    KHARDY.IRSS@MHS.UNC.EDU      |
| Assoc. Dir. for Information Systems   |               or                |
| Inst. for Research in Social Science  |    KENHARDY@UNCVM1.BITNET       |
| University of North Carolina          |                                 |
| Manning Hall CB#3355                  |    Voice: 919-966-4791          |
| Chapel Hill, N.C.  27599-3355         |    FAX:   919-962-IRSS          |
+-------------------------------------------------------------------------+
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sas-l
Date:         Fri, 2 Oct 1992 18:20:01 PDT
Reply-To:     "(Mark Schildhauer)" <schild%alishaw@HUB.UCSB.EDU>
From:         "(Mark Schildhauer)" <schild%alishaw@HUB.UCSB.EDU>
Subject:      SAS/ACCESS under Unix
Comments: To: sas-l@ohstvma.ircc.ohio-state.edu
Comments: cc: schild@alishaw.ucsb.edu

Hi Folks,

   I just received my License Fee Schedule for the SAS System
under Unix/OpenVMS, effective Jan 1, 1993. I noticed that they describe:

SAS/ACCESS under Sun includes Interfaces to ORACLE,
INGRES, and SYBASE.

   Could this be true?  Either now or in the NEAR future?
If so, bravo SAS!!!  Anyone out there able to comment from
hands-on a beta?

Cheers,
Mark Schildhauer
SSCF
Univ. Calif., Santa Barbara
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sas-l
Date:         Wed, 30 Sep 1992 12:54:00 EDT
Reply-To:     "Philip Gallagher,(919)966-1065" <UPHILG@UNC.BITNET>
From:         "Philip Gallagher,(919)966-1065" <UPHILG@UNC.BITNET>
Subject:      RANUNI.&.random subsets, continued

Subject: RANUNI.&.random subsets, continued

    I can't resist pointing out that which is obvious to
    everyone who already understands, but undoubtedly opaque
    to those who don't.

    In response to a question w.r.t. taking a random subset of a
    large dataset a perfectly correct answer was posted by Arnold
    Schick which utilized an expression of the form

>             data selectio (drop=which);
>               set previo;
>               which = round(ranuni(0),1); /* reduces nearly 50 pct, uniform */
>               if which;
>             run;

  to which Ski Taniguchi asked:
> Could you have used:
>      DATA SELECTIO;
>           IF (ROUND(RANUNI90),1) ;

    I respond here because this approach conceals from those unfamiliar
    with this technique the well-known (i.e., in the manuals) use of
    RANUNI to obtain samples of (approx.) any fraction of the original.
    Since RANUNI returns with equal probability all numbers on the
    interval zero to one, one may evaluate RANUNI(some seed) for each
    case and conditionally OUTPUT a record depending on whether the
    evaluated value is less than some specified value between zero
    and one, thus obtaining a sample that (in probability) is
    whatever fraction of the original sample one desires.  For example,
    suppose one wanted a sample of about 2.8% of the original;  this
    code shoud work (if I don't leave out a semicolon, etc.):

    DATA libref.SUBSET;
        SET oldlibref.olddataset;
        IF (RANUNI(1234567) LT .028) THEN OUTPUT libref.SUBSET;
                                                 * 2.8% subset;
        *  I happen to prefer a nonzero seed - humor me, please;
    RUN;

    Supposing the original dataset were very large and one wanted
    subsets of varying fractions of the original, one can modify
    the above code to create several subsets simultaneously:

    DATA libref.SUBSET01 libref.SUBSET05 libref.SUBSET20;
        SET oldlibref.olddataset;
        RAN_VAL = RANUNI(1234567);
        IF (RAN_VAL LT .01 ) THEN OUTPUT libref.SUBSET01;
                                         *  a  1% subset;

        IF (RAN_VAL LT .05 ) THEN OUTPUT libref.SUBSET05;
                                         *  a  5% subset;

        IF (RAN_VAL LT .20 ) THEN OUTPUT libref.SUBSET20;
                                         *  a 20% subset;

    RUN; *  Clearly, one might wish to invoke RANUNI separately
            for each dataset.  Please be sure to read the Fine
            Manuals very carefully for a full discussion of the
            possible choices of a seed.;

                             Phil Gallagher
                             uphilg@unc
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Full-Name: Kevin Nechodom (Unix Wannabe)
Organization: U of U CSSRD/STACC
Plan: To get a CS degree before I die.
Censored-By: UofU Thought Police
Mailer: Elm [revision: 70.30]
Newsgroups: bit.listserv.sas-l
Date:         Tue, 6 Oct 1992 14:09:39 MDT
Reply-To:     knechod@stacc.med.utah.edu
From:         "Kevin Nechodom (Unix Wannabe)" <knechod@STACC.MED.UTAH.EDU>
Subject:      SQL Outer Joins, or How My Intuition was Shot to Hell
Comments: To: "(SAS Mailing List)" <sas-l@uga.cc.uga.edu>

SUBJECT:   Outer Joins don't keep key values across tables
SUMMARY:   Do I have to do a Data Step to clean up?
REL/PLTF:  6.07/HP730
E-ADDR:    knechod@stacc.med.utah.edu
NAME:      Kevin Nechodom
COMPANY:   University of Utah STACC
HOME:      (801) 581-6410

I am running PROC SQL to do an outer join on two tables.
Table1:                             Table2:
  DOC       DATE        COUNTS1       DOC       DATE        COUNTS2
  ---       --------    -------       ---       --------    -------
  ABC       10/5/92     1             ABC       10/5/92     3
  ABC       10/6/92     2             ABD       10/7/92     4

What I expected to get was:
NewTable:
  DOC       DATE        COUNTS1    COUNTS2
  ---       --------    -------    -------
  ABC       10/5/92     1          3
  ABC       10/6/92     2          .
  ABD       10/7/92     .          4

But instead, it first built:
  DOC       DATE        COUNTS1    DOC  DATE      COUNTS2
  ---       --------    -------    ---  --------  -------
  ABC       10/5/92     1          ABC  10/5/92   3
  ABC       10/6/92     2               .         .
            .           .          ABD  10/7/92   4

And getting rid of duplicate columns, it returned:
NewTable:
  DOC       DATE        COUNTS1    COUNTS2
  ---       --------    -------    -------
  ABC       10/5/92     1          3
  ABC       10/6/92     2          .
            .           .          4

So, I thought I could avoid the problem by saying:
SELECT
     (table1.doc  <> table2.doc ) as docname
   , (table1.date <> table2.date) as visdate
   , counts1
   , counts2    ...

but PROC SQL does not recognize the <> MAX operator.  It interprets it
like a "ne".  And the MAX function in SQL doesn't look like a normal
MAX.

Now, I'm stuck.  How do I keep the key values in a single column
without running a DATA STEP afterwards to clean up?  I'm I missing
something trivially easy?  Does this show that the idea of an outer
join is broken?
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
X-Envelope-to: SAS-L@AWIIMC12.BITNET
X-Mailer: ELM [version 2.2 PL0]
Newsgroups: bit.listserv.sas-l
Date:         Mon, 5 Oct 1992 15:33:28 EDT
Reply-To:     Daryl P Sawders <DARYL@PITTUNIX.BITNET>
From:         Daryl P Sawders <DARYL@PITTUNIX.BITNET>
Subject:      PROC FORMS ???

Well it seems I took back my question too soon...

When using a BY clause in a PROC Forms is there any way to get
it to repeat the ALIGN clause between BY groups ??

We need to be able to sepearate the various "chunks" such that
there will be an alignment section at the top of each.

TIA.

   - Daryl -
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
X-Envelope-to: SAS-L@AWIIMC12.BITNET
X-Mailer: ELM [version 2.2 PL0]
Newsgroups: bit.listserv.sas-l
Date:         Fri, 2 Oct 1992 13:45:11 EDT
Reply-To:     Daryl P Sawders <DARYL@PITTUNIX.BITNET>
From:         Daryl P Sawders <DARYL@PITTUNIX.BITNET>
Subject: Ooops.. please ignore my previous post :-}

It seems that PROC FORMS has a BY clause...

I was at home (no manuals).... and I couldn't find it on-line...

Sorry.

   - Daryl -
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sas-l
Date:         Mon, 28 Sep 1992 09:44:00 EDT
Reply-To:     Sally Muller <UNCSM1@UNC.BITNET>
From:         Sally Muller <UNCSM1@UNC.BITNET>
Subject:      Last word online vs. paper

----------------------------------------------------------------------
SUMMARY:  High tech paper alternative
REL/PLTF: 6.06 MVS/ESA  6.06 VM/XA
E-ADDR:   uncsm1@unc.bitnet
NAME:     Sally Muller
PH/ADDR:  919-962-6501  OIT CB#3455, UNC, Chapel Hill NC 27514
----------------------------------------------------------------------

Speaking of Phil, his was the last response that came after I posted
summary....

in original post:
> PS -  In writing this I logged all your message in a e-mail
> notebook and then PRINTED OFF.  I read the printoff in the bus,
> waiting in line at store, eating, soaking in tub....I highlighted
> it in two colors and there are water and food spots all over it.
> Theres something to be said for paper documentation......
>

Well, there are technology solutions to that as well.  Go shopping for
"Walkman" like products and you will find some that you can take to
the beach, the whirlpool and breakfast table.  If you are lucky you
will also see the first of the new products from Sony - the electronic
book.  It uses a CD type storage media and gives you lots of display
options.  Now it is not environmentally robust, but if it catches on
watch out!

     J. Philip Miller, Professor, Division of Biostatistics, Box 8067
	 Washington University Medical School, St. Louis MO 63110
     phil@wubios.WUstl.edu - Internet  (314) 362-3617 [362-2694(FAX)]
From: jjmorris@gandalf.rutgers.edu (Joyce Morris)
Newsgroups: bit.listserv.sas-l
Subject: simple problem
Date: 6 Oct 92 19:42:13 GMT
Organization: Rutgers Univ., New Brunswick, N.J.

Thanks to all who responded to what I thought was a simple problem.
I will summarize when I get through my backlog of mail from being out
sick.

Joyce Morris  jjmorris@gandalf.rutgers.edu
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU