HDTenEightyP/NetNews huggingface dataset:
From: POPPE@SWOV.NL (Frank Poppe)
Newsgroups: bit.listserv.sas-l
Subject: Re: legend
Date: 19 Aug 92 19:53:00 GMT
Reply-To: Frank Poppe <POPPE@SWOV.NL>
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
X-Organization: stichting wetenschappelijk onderzoek verkeersveiligheid SWOV
X-Envelope-to: sas-l@AWIIMC12.BITNET
X-VMS-To: IN%SAS
X-VMS-Cc: POPPE

>From: IMAD.GHANDOUR%MAIL.ADMIN.WISC.EDU@AWIIMC12.IMC.UNIVIE.AC.AT
.
>Platfotm: IBM MVS
>Product : SAS/GRAPH
>From : Imad Ghandour
>Contact : imad.ghandour@mail.admin.wisc.edu
>
>I am trying to customize the legend when using PROC GPLOT so that
>instead of the standard numerical legend I will have some
>meaningful text. The following code is used:
>
>PROC GPLOT DATA=FINAL;
>BY GROUP;
>PLOT MBYTES * DATE = CAT / CAXIS=MDBLACK CTEXT=MDBLACK;
>SYMBOL1 I=JOIN C=LTBLACK V=NONE W=2;
>SYMBOL2 I=SPLINE C=MDBLACK V=NONE W=2;
>SYMBOL3 I=RLCLM CV=MBBLACK CO=LTBLACK V=NONE;
>LEGEND LABEL=NONE VALUE=(T=1 'ACTUAL' T=2 'SMOOTHED' T=3 'LIN.REG.');
>TITLE1 'HISTORICAL DASD INFORMATION';
>
>The legend part is not working. Instead of having the customized
>legend entry labels, I am getting numbers. Anyone has any idea what
>I am doing wrong ?????
>
>
>Imad Ghandour
>University of Wisconsin - Madison

My idea is that you never tell GPLOT to *use* your legend-statement.
So I'dd add an option to your plot-statement:
 PLOT MBYTES * DATE = CAT / CAXIS=MDBLACK CTEXT=MDBLACK
                legend=legend1 ;

_____________________________________________________________________________
 Frank Poppe             <poppe@swov.nl>                tel:   +31 70 3209323
 Institute for Road Safety Research SWOV                fax:   +31 70 3201261
    ,,,  ,, ,, ,,  .... ,, ,,                           mail:      PO Box 170
   ||,,, || || || :: :: || ||                            2260 AD Leidschendam
   ,,,|~ ||,'|,~  :: :' ||,~                                  the Netherlands
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Subject: (no subject given)
Newsgroups: bit.listserv.sas-l
Date:         Wed, 19 Aug 1992 15:18:28 ECT
Reply-To:     IR0007@BINGVMB.BITNET
From:         IR0007@BINGVMB.BITNET

NOACK
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Encoding: 18 TEXT
X-Mailer: Network Courier V2.1b
X-Charset: ASCII
X-Char-Esc: 29
Newsgroups: bit.listserv.sas-l
Date:         Wed, 19 Aug 1992 11:21:00 PDT
Reply-To:     okoks@PC.IBT.DK
From:         okoks@PC.IBT.DK
Subject:      SAS/Map data

Hello,
I have a question concerning SAS/Map data.
Just after East- and West Germany got united, I made a dataset for the 'new'
country - it was a lot of work to delete the border.
Does anybody know if datasets exists for all the new East-European countries,
or do you have to make them yourself?
I am using SAS ver. 6.04 and 6.07, under DOS and OS/2.

TIA

Karsten Strobek

Institute of Economics                              Phone: +45 33 91 21 66/377
University of Copenhagen                                  Fax: +45 33 12 00 01
Studiestraede 6                                      Internet: okoks@pc.ibt.dk
DK-1455 Copenhagen K
Denmark
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sas-l
Date:         Mon, 17 Aug 1992 08:47:34 EDT
Reply-To:     Howard Schreier <HIS@NIHCU.BITNET>
From:         Howard Schreier <HIS@NIHCU.BITNET>
Subject: RE: MEANS/SUMMARY and Weight Statement in 6.07

CONTENT:  Follow-up
SUMMARY:  Additional points on SUMMARY & SQL approaches
REL/PLTF: 6.07

> > In 5.18, if you wanted to create a summary file that contains a
> > weighted average and a non weighted sum, you have to run PROC SUMMARY
> > twice, and then merge the results in a DATA step:
> >
> > Is there a shortcut in 6.07 ? How would you do that in SQL ?
>
> I don't know about a shortcut in 6.07.  If you could add the variable
> "usage/myweight" to the original data set, you could cut your three
> steps down to 1.  This is illustrated below.
>
>   data mydata2;
>     set mydata;
>     usage2 = usage / myweight;
>   run;
>
>   proc summary data=mydata2;
>    class myclass;
>    var usage usage2;
>    weight myweight;
>    output out=final  mean=usage __junk1   sum=__junk2 count;
>   run;

A shortcut would be to create MYDATA2 as a DATA step *view*.
The  DATA  step would still be necessary to define the view,
but a complete processing pass through  the  file  would  be
saved.   This  is a shortcut in terms of execution time, not
coding.

Using the "STATNAME(VARNAME)=RESULT" construct in the OUTPUT
statement,  creation of the unwanted __JUNK variables can be
avoided.

> /*** SQL approach...
>       note: to save to a data set, add:  CREATE TABLE FINAL AS
>       note: would have to add more code to get _type_=0 stats ***/

Same SELECT statement, but without the GROUP BY and ORDER BY
clauses,   should   do  it.   Also,  there  is  an  unstated
assumption that there are no negative MYWEIGHT values  (PROC
SUMMARY automatically maps these to zero).

>   proc sql;
>     select myclass,
>        sum( myweight*usage ) / sum(myweight) as usage,
>        sum(usage) as count
>     from mydata
>     group by myclass
>     order by myclass
>   ;

/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\
\   Howard Schreier, U.S. Dept. of Commerce, Washington    /
/                     MVS 5.18 & 6.07                      \
\   Voice: (202) 377-4180        BITNET: HIS@NIHCU         /
/   Fax:   (202) 377-4614      INTERNET: HIS@CU.NIH.GOV    \
\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/
From: DAN@UMDD.BITNET (Dan Jacobs)
Newsgroups: bit.listserv.sas-l
Subject: SAS/PC 6.04 --> SAS/CMS 6.06
Date: 12 Aug 92 20:17:55 GMT
Reply-To: Dan Jacobs <DAN@UMDD.BITNET>
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU

I have been sent a large number of SAS data sets created using SAS/PC
Version 6.04.  The files will be uploaded onto an IBM mainframe and
analyzed using Version 6.06 under CMS.  What is the best way to convert
the SAS data sets so they can be used with Version 6.06?

Dan Jacobs, Ph.D.                 BITNET: DAN@UMDC
Ecologist/Biometrician
Maryland Sea Grant College
University of Maryland           Ben Hay-Hay taught:
1115 Taliaferro Building         The reward is proportionate
College Park, MD  20742          to the suffering.
(301) 405-6379                              Pirkei Avot V:25
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
X-Mailer: ELM [version 2.2 PL16]
Newsgroups: bit.listserv.sas-l
Date:         Fri, 14 Aug 1992 17:39:04 CDT
Reply-To:     "R. Snyder" <rsnyder@LOBBY.TI.COM>
From:         "R. Snyder" <rsnyder@LOBBY.TI.COM>
Subject:      Re: PMENU and SCL /MVS - 6.07
Comments: To: 0005400191@MCIMAIL.COM
Comments: cc: sas-l@uga.cc.uga.edu
              92 6:26 pm

Willy Waks writes:
>
> I've created my own PMENU, and I would like to have them in effect accross an
> entire application. In 6.06 under OS2, I can start my application with
> DM 'PMENU ON; SET PMENU=MYLIB.MYCAT.MYMENU';
> In 6.07 under MVS, the DM 'SET ...' is interpreted as SETINIT and opens the
> SETINIT window, which is the last thing you want to do to a user.
> I know of RC=PMENU('MYLIB.MYCAT.MYMENU'), but it seems that I need to repeat
> that for every screen, as opposed to make it the default for the entire
> application. Any clue ? Thanks
> Willy Waks, 2W Systems Co., Inc. Dallas TX
> PS: I've also got a logo:
> Errare humanum est... sed perseverare diabolicum !
>
Willy,

I know it's of no help but I've looked the general documentation and our UNIX
specific documentation to no avail. It appears that the capability you have
referenced has been removed in order to protect SI's PMENUs in the main
 windows.Please let me know if someone else is able to be more helpful.

Bob Snyder, Texas Instruments, Sherman, TX
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
X-Envelope-to: SAS-L@VTVM2.BITNET
X-VMS-To: IN%"SAS-L@VTVM2.BITNET"
Newsgroups: bit.listserv.sas-l
Date:         Mon, 17 Aug 1992 12:27:00 EST
Reply-To:     WHITMIR1@NIEHS.BITNET
From:         WHITMIR1@NIEHS.BITNET
Subject:      Re: Including macros into SAS program

Thank you for the response to my question on using macro inside my program.
It gave me a good start on how to learn macro.
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
X-Vmsmail-To: SMTP%"sas-l@uga.uga.edu"
Newsgroups: bit.listserv.sas-l
Date:         Fri, 21 Aug 1992 10:56:47 -0700
Reply-To:     JAMES@UCRAC1.UCR.EDU
From:         JAMES@UCRAC1.UCR.EDU
Subject:      Proc Tabulate on the NeXT
Comments: To: sas-l@uga.cc.uga.edu

This is a long message that contains a compelete program. The program possibly
applies to a wide variety of printers.

I would like to get professional looking tables from proc tabulate on the NeXT
using a NeXT printer. I want to chnge the borders of the table via the formchar
following the approach of O'Sullivan 1985. A Laser printer can enhance the
appearance of SAS procedures. SUGI 10:762-767. Below is the program I have used
to try to discover the characters that do the borders. I have failed and do not
have access to a PostScript book for reference. It looks as though the NeXT
only uses 7 bits since I get nothing beyond DECIMAL 127 (HEX 7E). To compound
matters the NeXT printer seems to have the intelligence of a rock. It merely
regurgitates out whatever is sent to it.

I would be infinitely grateful (for the next couple of seconds anyway) if you
could assist me solve this seemingly simple problem (actually, I'd even pay a
small fortune -- at least $0.05, don't snicker, there is no more gold in the
Golden State). Feel free to direct me to a manual (I've alread RTFMed the SAS
Guide to TABULATE processing, 1987 Edition -- which is apparently
pre-PostScript -- to no avail ...)

James Ssemakula
University of California, Riverside.
james@ucrac1.ucr.edu

------------------------- program ----------------------------------------------
options ps=256 ls=80 ;

/*program to discover the characters used to make borders of tables in tabulate.
 see O'Sullivan 1985. SUGI 10:762-767. HEX codes from Table 1.c:ASCII Table in
 Turbo Pascal:Reference Guide,Appendix C PP 421-423 (1989). Note: Appendix C in
 DOS 4.00 manual also gives the same codes in a slightly different format. */

data one ;
	input hex $ @@;
	ascii=input(hex,$hex2.) ;
datalines ; * cards in pre-6.07 ;
00 01 02 03 04 05 06 07 08 09
 A  B  C  D  E  F 10 11 12 13 14 15 16 17 18 19
1A 1B 1C 1D 1E 1F 20 21 22 23 24 25 26 27 28 29
2A 2B 2C 2D 2E 2F 30 31 32 33 34 35 36 37 38 39
3A 3B 3C 3D 3E 3F 40 41 42 43 44 45 46 47 48 49
4A 4B 4C 4D 4E 4F 50 51 52 53 54 55 56 57 58 59
5A 5B 5C 5D 5E 5F 60 61 62 63 64 65 66 67 68 69
6A 6B 6C 6D 6E 6F 70 71 72 73 74 75 76 77 78 79
7A 7B 7C 7D 7E 7F 80 81 82 83 84 85 86 87 88 89
8A 8B 8C 8D 8E 8F 90 91 92 93 94 95 96 97 98 99
9A 9B 9C 9D 9E 9F
A0 A1 A2 A3 A4 A5 A6 A7 A8 A9 AA AB AC AD AE AF
B0 B1 B2 B3 B4 B5 B6 B7 B8 B9 BA BB BC BD BE BF
C0 C1 C2 C3 C4 C5 C6 C7 C8 C9 CA CB CC CD CE CF
D0 D1 D2 D3 D4 D5 D6 D7 D8 D9 DA DB DC DD DE DF
E0 E1 E2 E3 E4 E5 E6 E7 E8 E9 EA EB EC ED EE EF
F0 F1 F2 F3 F4 F5 F6 F7 F8 F9 F1 FB FC FD FE FF
;
proc print ;
title1 'Results are operating system specific' ;
title2 'Check HEX B3 thru DA' ;
run;
* obs should be the decimal equivalent (minus one) ;
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sas-l
Date:         Tue, 18 Aug 1992 10:18:59 -0500
Reply-To:     Kernon Gibes <gibes@SWIRL.MONSANTO.COM>
From:         Kernon Gibes <gibes@SWIRL.MONSANTO.COM>
Subject:      RE: SQL delete statement
Comments: To: SAS-L@uga.cc.uga.edu@tin.monsanto.com
Comments: cc: GIBES@tin.monsanto.com

 CONTENT:   F/U on SQL delete statement thread
 SUMMARY:   SQL statement "DELETE FROM table1, table2" - not valid
 REL/PLTF:  6.06+/ VMS
 E-ADDR:    gibes@swirl.monsanto.com
 NAME:      Kernon Gibes
 DATE:      18 August 1992

Don has his problem solved I guessed, but just to wrap up the SQL DELETE
statement thread...

Don writes:

>I tried your version and I believe it deleted everything.
>I have trouble believing this, as it is counter to the
>SQL manual. I think maybe I had a goof, such as my
>deletions set being incorrect. Anyway, Howard's method
>was much to complex for me to understand in the time I
>have available, so I have switched to an entirely different
>rather brute force approach.

where Bob's version was:

 proc sql;
   delete from big, dels
     where big.area=dels.area and big.analyte=dels.analyte;

according to the manual that I have, the syntax for the DELETE statement
does not indicate that a "from-list" is allowed, but just a
"table-name".  And, in fact, on VMS an attempt to run this code yields a
syntax error; thus, nothing was deleted from BIG or from DELS.

I assume (hope?) that Don, as he suggests, incorrectly ran Bob's
version.
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sas-l
Date:         Fri, 14 Aug 1992 08:57:30 EST
Reply-To:     Steve Marcus <SCM@HARVARDA.BITNET>
From:         Steve Marcus <SCM@HARVARDA.BITNET>
Subject:      Job posting for Epidemiologist in Boston

If anyone knows somebody who might be interested in the position below,
please email me or call the numbers below. It is a unique opportunity
and a great job for the right person. I know it is not an official
SAS question but I hope some SAS-L person might be able to pass it along
to a qualified candidate.

Thanks.
-------------------------------------------------------------------------

PART-TIME RESEARCH ASSOCIATE

PROGRAM ON HUMAN DEVELOPMENT
AND CRIMINAL BEHAVIOR

HARVARD SCHOOL OF PUBLIC HEALTH - BOSTON, MA

10-20 HOURS PER WEEK

   The Program on Human Development is seeking a part-time research
associate (Ph.D., Ph.D. candidate, or equivalent) to assist in the
preparation of a grant application on the longitudinal study of substance
use and abuse (birth to age 32). Familiarity with the research literature on
longitudinal studies of substance use and excellent writing skills required;
research and grant writing experience desirable.

    Tasks include meeting with senior investigators around the country,
conducting literature reviews on the etiology of substance use, compiling
and reviewing available measures, and assisting with grant writing.

    Office space will be provided at the Harvard School of Public Health
but much of the work can be conducted off-site. This position will run
through mid-October and may be extended.

Inquires to: Dr. Stephen Buka
              Assistant Director
              Program on Human Development and Criminal Behavior
              Harvard School of Public Health
              677 Huntington Avenue
              Boston, MA 02115

              617-432-3870 (phone)
              617-432-3892 (fax)
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Date:         Thu, 13 Aug 1992 17:17:17 PDT
Reply-To:     Melvin Klassen <KLASSEN@UVVM.BITNET>
Comments:     Warning -- original Sender: tag was NETNEWS@UVVM.UVIC.CA
From:         Melvin Klassen <KLASSEN@UVVM.BITNET>
Subject:      Re: LIMDEP (info. request)

Douglas Baer, Department of Sociology <baer@UWOVAX.UWO.CA> writes:
>I believe there was a posting a couple of weeks ago mentioning the
>e-mail address of William Greene, the author of LIMDEP.
That note about LIMDEP was cross-posted from the STAT-L@MCGILL1 mailing list.
The address for the developer was mentioned in other STAT-L postings:
     Dr. William Greene <wgreene@OPTION.STERN.NYU.EDU>
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sas-l
Date:         Tue, 18 Aug 1992 01:52:13 EDT
Reply-To:     Philip Tejera <FXTBB@CUNYVM.BITNET>
From:         Philip Tejera <FXTBB@CUNYVM.BITNET>
Subject:      Re: Macro read from the stack
Comments: To: "Crovo, Bob" <CROVO@UKCC.UKY.EDU>, SAS-L@UGA.BITNET

If you have SAS 6.07 available (as you most likely should under CMS), there
is a new interface between SAS and Rexx that makes strategies like the one
you are attempting unnecessary. The SAS datastep Getexec function can
access the variables in a rexx SASMACRO; it is no longer restricted as in 6.06
to just variables in the exec invoking SAS. Thus the overhead, limitations,
and risks of writing to and reading from the stack can be avoided.

As a simple example, consider the following Rexx code, which is in a
file called TRYGET SASMACRO .

/* test getexec function on some rexx variables */
var1 = alpha
var2 = beta                            /* assign some rexx values */
var3 = gamma
                                       /* start up a SAS datastep */
"data one;"
  "v1=getexec('VAR1');"                /* use getexec function to */
  "v2=getexec('VAR2');"                /* get rexx values.        */
  "v3=getexec('VAR3');"
  "put v1= v2= v3=;"                   /* Display them.           */
"run;"                                 /* End SAS datastep.       */

Exit                                   /* Leave the Rexx Sasmacro */

Then a simple SAS program (done in batch mode to get the saslog) just
has to invoke TRYGET SASMACRO, as shown in the following saslog segment:

 1          options ls=80 nocenter noovp;
 2          tryget;


 V1=ALPHA V2=BETA V3=GAMMA
 NOTE: The data set WORK.ONE has 1 observations and 3 variables.

 NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414

To put it another way, in this situation we have a SAS program one-liner
calling a SAS macro written in Rexx, which in turn is able to address
SAS and run the important datastep.  For more information, see SAS
Technical Report P-219, Changes and Enhancements...for the CMS Environment,
Chapter 8.

P.S. As I hinted above, a restricted form of Getexec is available in SAS
     6.06, but it all has to be done with variables in the exec that
     invokes the SAS system modules, which is a bit cumbersome.
Newsgroups: bit.listserv.sas-l
From: scott@mickey.acs.wmich.edu (Julie Scott)
Subject: Re: CALIS TEST EXAMPLES
Organization: Western Michigan University Academic Computing Services
Date: Thu, 13 Aug 1992 17:11:10 GMT

In article <SAS-L%92081211415865@VTVM2.BITNET>  writes:
> Dear net-folks,
>     In Appendix B of the SAS document, THE CALIS PROCEDURE:
>  EXTENDED USER"S GUIDE,  it lists a number of test examples
>  for which someone has already typed in all of the input code.
>  As I am teaching a course in Structural Modeling in the Fall of
>  1993, I thought my work load would be redcued if I could get a hold
>  of these test example files.  The manual suggests that these are
>  in the master directory of SAS institute.
>      Could someone please kindly inform me as to how I might get my
>  hands on these?
>                         Thanks in Advance,
> 
>                                Robert Terry
>                                Dept. of Psychology
>                                Social and Health Sciences
>                                Duke University
>                                Durham, NC 27708

All these programs are shipped with the software.  Your site SAS  
consultant or software representative should be able to help you find them  
on your system.  On a VAX/VMS they are located in an area called 
SAS$SAMPLES:[SAS607.SAMPLES.STAT] (if you are running SAS 6.07)  I found  
the following six programs there:

CALISEX1.SAS;1 
CALISEX2.SAS;1 
CALISEX3.SAS;1 
CALISEX4.SAS;1 
CALISEX5.SAS;1
CALISEX6.SAS;1 

If you have trouble finding them, let me know and I can email them to you.

Julie Scott
SAS Consultant
Western Michigan University
scott@mickey.acs.wmich.edu
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sas-l
Date:         Thu, 20 Aug 1992 10:53:38 EDT
Reply-To:     Howard Schreier <HIS@NIHCU.BITNET>
From:         Howard Schreier <HIS@NIHCU.BITNET>
Subject:      MVS 6.0x Compatibility

CONTENT:  Response
SUMMARY:  Invoke 6.06 engine to get backward compatibility
REL/PLTF: 6.07 MVS

> Also - any suggestions regarding what to watch out for as far as 5.18 and 6.06
> programs running under 6.07 would be welcome.

Not exactly, but a warning that applies  if  6.06  and  6.07
will both be in use over a period of time.

When either 6.06 or 6.07 writes a  data  set  to  a  library
which  was initially created under 5.18 (or under 6.0x using
the 5.18 engine), the 5.18 engine is automatically  selected
and the new data set can later be used by a 5.18 job with no
difficulty.

But, when 6.07 writes a data set  to  a  library  which  was
initially  created  under  6.06,  the default behavior is to
select the 6.07 engine.  A 6.06 job will be able  to  detect
the presence of the new data set, but will be unable to open
it.  The 6.06  engine  should  be  explicitly  invoked  when
creating the data set if readability by 6.06 is required.

/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\
\   Howard Schreier, U.S. Dept. of Commerce, Washington    /
/                     MVS 5.18 & 6.07                      \
\   Voice: (202) 377-4180        BITNET: HIS@NIHCU         /
/   Fax:   (202) 377-4614      INTERNET: HIS@CU.NIH.GOV    \
\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sas-l
Date:         Fri, 21 Aug 1992 17:01:50 -0400
Reply-To:     robertso@nprdc.navy.mil
From:         Paul Robertson <robertso@NPRDC.NAVY.MIL>
Subject:      epidemiology list?
Comments: To: sas-l@uga.cc.uga.edu

Is there a bitnet list concerned with epidemiology research?
I'm interested in learning whether any clinical trials are
being conducted to determine the effectiveness and risks
inherent in midline episiotomy.

Thanks,

Paul Robertson
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
From: macq@miguel.llnl.gov (Don MacQueen)
Newsgroups: bit.listserv.sas-l
Subject: SQL delete statement
Date: 17 Aug 92 16:36:10 GMT
Organization: Lawrence Livermore National Laboratory

I have a very large dataset, from which I would
like to delete a number of observations. This dataset
is large enough that I am running short on disk space.
The information about which cases to delete comes from
another dataset, based on some key variables.

Normally, I would do something like this:

data new;
  merge big dels (in=indel);
  by area analyte;
  if indel then delete;
  run;

Where there are many observations in big for each
combination of area and analyte, but each combination
of area and analyte only appears once in dels.

I thought I'd look at proc sql. Seems like something such
as

proc sql;
  delete from big
    where big.area=dels.area and big.analyte=dels.analyte;

ought to work, but It doesn't, and I don't know SQL well enough
to fix it.

Help please?
Other non-sql suggestions?

There are several hundreds of observations in dels, >200,000 
observations in big. I'd like to make the deletions without
writing a big temporary file (very dangerous, I know, but
I can always go back and re-create big from the original ascii
file).
-- 
---------------------------------------------------
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
X-Mailer: ELM [version 2.2 PL16]
Newsgroups: bit.listserv.sas-l
Date:         Fri, 21 Aug 1992 09:40:38 CDT
Reply-To:     "R. Snyder" <rsnyder@LOBBY.TI.COM>
From:         "R. Snyder" <rsnyder@LOBBY.TI.COM>
Subject:      Re: SAS Under Unix on Intel Platform
Comments: To: JBRAGG@CALS1.CALS.NCSU.EDU
Comments: cc: sas-l@uga.cc.uga.edu
              92 7:27 am

CONTENT:   Reply to "SAS under UNIX on Intel Platform"
SUMMARY:   In a word, "no".
E-ADDR:    rsnyder@lobby.ti.com
NAME:      Bob Snyder
COMPANY:   Texas Instruments, Sherman, TX
PHONE:     (903) 868-5799
FAX:       (903) 868-7240

Jay Bragg asks:
>
> Hi, here's an easy one.  Does SAS run under any of the Unixes that
> run on Intel platforms (e.g., a 486/33)?  We've reached DOS' limit
> and OS/2 just hasn't caught on here (ergo, no support).  Yes, I
> know, I could call SI marketing but if the answer is "yes" then
> I'm also hoping for additional comments from users.  Thanks!
>
>    /jay bragg/

Jay,

I've heard rumors that SI wants to port to SCO UNIX. To date SI doesn't
support any Intel based UNIX boxes.

Bob
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU