HDTenEightyP/NetNews huggingface dataset:
X-Mailer: ELM [version 2.2 PL16]
Newsgroups: bit.listserv.sas-l
Date:         Wed, 2 Sep 1992 09:35:44 CDT
Reply-To:     "R. Snyder" <rsnyder@LOBBY.TI.COM>
From:         "R. Snyder" <rsnyder@LOBBY.TI.COM>
Subject:      Re: SAS Work space in Unix
Comments: To: phil@WUBIOS.WUSTL.EDU
Comments: cc: sas-l@uga.cc.uga.edu
              92 9:02 am

CONTENT:   SAS Work space under UNIX
SUMMARY:   Reply
REL/PLTF:  6.07/HP300
E-ADDR:    rsnyder@lobby.ti.com
NAME:      Bob Snyder
COMPANY:   Texas Instruments, Sherman, TX
PHONE:     (903) 868-5799
FAX:       (903) 868-7240
>
> I am wondering what other folks do who are running SAS under Unix with
> respect to temporary space for WORK etc.  We have ours pointing to a
> seperate file system so that if it fills up it does not affect other file
> systems, but still it is not a pretty site when it fills up!
>
> -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)]
>
We do essentially the same thing by using out /tmp file system. While there
is a potential for spce problems, this seems the best approach in terms of
performance.

Regards,
Bob
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sas-l
Date:         Thu, 27 Aug 1992 16:34:03 -0500
Reply-To:     Kernon Gibes <gibes@SWIRL.MONSANTO.COM>
From:         Kernon Gibes <gibes@SWIRL.MONSANTO.COM>
Subject:      VMS only - f/u on solid lined TABULATE with DEC laser printers
Comments: To: sas-l@tin.monsanto.com
Comments: cc: sascxk@unx.sas.com@tin.monsanto.com, GIBES@tin.monsanto.com

 CONTENT:   FYI
 SUMMARY:   Solid lined TABULATEs with LN0x's: SI says must post-process
            now, but 1-to-many formchar MAY BE a '93 SASware ballot item
 REL/PLTF:  n.a./ VMS ONLY
 E-ADDR:    gibes@swirl.monsanto.com
 NAME:	    Kernon Gibes
 DATE:	    27 August 1992

 Are you tired of hearing about TABULATE and solid lined tables using
 DEC laser printers?   Yes?  :-(   Oh well, just to make sure that I
 shouldn't throw out post-processing routines I contacted tech. support
 and received the answer given below.  Note that Tina says that this MAY
 BE a '93 SASware ballot item.  I wonder if interested parties shouldn't
 do some additional lobbying, perhaps via SAS-L or by letter?

 I'm considering submitting my post-processing approach as a SUGI talk,
 but if you're desperate and interested, feel free to contact me
 directly and I will send you the guts of it.

___EMITS Response from SI_____________________________________________________

<header plus other stuff deleted>

The first 8 lines of your original description is included below
for your convenience:

> BEGIN ORIGINAL DESCRIPTION
 A long-standing problem under VMS with DEC laser printers is the inability to
 print solid-lined PROC TABULATE tables using the FORMCHAR option since, to
 the best of my (or SAS-L's) knowledge, DEC can only print solid lines using
 either SGR or DECVEC escape sequences.  This would require a 1-to-many
 mapping of FORMCHAR instead of its current 1-to-1 mapping.  At present, post
 processing the output is one workaround.  Is there any other?  Is there any
 plans for a future release of the SAS system under VMS to allow 1-to-many
 FORMCHAR mappings?
> END ORIGINAL DESCRIPTION

<more stuff deleted>

Hi Kernon,
  You and your fellow SAS-L'ers are correct--there is no other way to achieve
the solid lines other than post-processing the output.  At this point in time
there has been no discussion of adding this capability to the FORMCHAR= option,
but we have had several suggestions submitted so far.  I know this item is
being considered for inclusion in the 1993 SASware Ballot, which is scheduled
for shipment in the 1st quarter 1993 SAS Communications issue.  You might want
to look for it and enter your vote.

Tina Keene

___end of EMITS response______________________________________________________
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sas-l
Date:         Wed, 26 Aug 1992 11:34:04 EDT
Reply-To:     Howard Schreier <HIS@NIHCU.BITNET>
From:         Howard Schreier <HIS@NIHCU.BITNET>
Subject: Re: SAS date function

CONTENT:  Comment
SUMMARY:  Use SAS date/time tools

> dob_dt is a count of days. just add 15*365.25 to it.

To get an approximately  correct  answer.   After  all,  the
value  365.25  is  just an average.  It's either 365 or 366,
and SAS date values *should* be integers.

The collection of date  and  time  functions,  formats,  and
informats provided by SAS is pretty extensive and versatile.
I suggest working with these tools wherever possible.

/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\
\   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:         Tue, 25 Aug 1992 16:50:00 EDT
Reply-To:     Sally Muller <UNCSM1@UNC.BITNET>
From:         Sally Muller <UNCSM1@UNC.BITNET>
Subject:      SAS/CONNECT and OS/2 2.0

----------------------------------------------------------------------
SUMMARY:  Problem with SAS/CONNECT and OS/2 2.0
REL/PLTF: 6.06 OS/2 2.0
E-ADDR:   uncsm1@unc.bitnet
NAME:     Sally Muller
PH/ADDR:  919-962-6501  OIT CB#3455, UNC, Chapel Hill NC 27514
----------------------------------------------------------------------

In a nutshell....it don't work!  Exact error message is that
RASYNC, which we specify in the OPTIONS line:

OPTIONS COMAMID=RASYNC REMOTE=COM1;

This is the log:

 NOTE: Remote signon to COM1 commencing (SAS Release 6.06).
 NOTE: Script file 'tso.scr' entered (SAS Release 6.06).
 NOTE: Signing on async device.
 ERROR: Communication Failure: RASYNC Device Driver initialization
 error 99
 Dos return xmit data status failed, rc = 22
 Dos return xmit data status failed, rc = 22
 Dos return xmit data status failed, rc = 22
 Dos return xmit data status failed, rc = 22
 Dos return xmit data status failed, rc = 22
 Dos return xmit data status failed, rc = 22
 Dos return xmit data status failed, rc = 22
 Dos return xmit data status failed, rc = 22
 Dos return xmit data status failed, rc = 22
 Dos return xmit data status failed, rc = 22
 Close port XMIT timeout after 10 seconds
 Dos reset initial control block info failed, rc = 22
 Dos reset initial line characteristics failed, rc = 22
 Dos reset initial baud rate failed, rc = 22
 ERROR: Unexplained error transmitting text to the remote system.
 ERROR: Script file interpretation terminated due to error.
 ERROR: Communication device driver initialization failure
 ERROR: Remote signon to COM1 cancelled.

Any insights much appreciated!
Best Regards,
Sally Muller
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sas-l
Date:         Tue, 1 Sep 1992 15:27:51 PDT
Reply-To:     Ted Grichuhin <FREDC@U.WASHINGTON.EDU>
Comments:     Warning -- original Sender: tag was FREDC@UWAVM.U.WASHINGTON.EDU
From:         Ted Grichuhin <FREDC@U.WASHINGTON.EDU>
Subject:      MVS 6.06 TO CMS 6.07 XFER PROBLEM

I received some tapes in transport format from a 6.06 MVS site.
I imported the data using 6.07 on a CMS site and placed it on disk.
Again using 6.07 I used PROC COPY to put the data on tape. Later, I
copied the data back to disk, then found I could not access the data.
There was a message to the effect, "invalid password access denied".
This turned out to be a bug and SAS is working on a ZAP for it.
You have to use 6.06 to import the data. Then you can use 6.07.


UW Maternal and Child Health Program Programmer        H:(206)842-4301
Telecommuting from an island is the civilized way to work.  FAX:(CALL)
Compuserve ID: 72261,2413
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
X-Mailer:     Pegasus Mail v2.3 (R3).
Newsgroups: bit.listserv.sas-l
Date:         Fri, 28 Aug 1992 09:17:11 EDT
Reply-To:     Ray Pass <PASSRAY@CPMAIL-NZ.CIS.COLUMBIA.EDU>
From:         Ray Pass <PASSRAY@CPMAIL-NZ.CIS.COLUMBIA.EDU>
Subject:      Re: print dup records
Comments: To: SAS-L@uga.cc.uga.edu

ON     Fri, 28 Aug 1992 08:37:07 EST
       LYCACC%RITVM.BITNET@uga.cc.uga.edu  WROTE:

> I wonder if anyone knows a "easy" way to print duplicate records in a
> data set.  Proc sort has an option to drop duplicates, but nothing to
> keep the duplicates only.  I suppose I can use a do loop in DATA step
> to check for duplicates, but is there an easier way?  We are running
> SAS607 on MVS, and CMS.
>
> Thanks in advance,
> Loyi
--------------------------------------------------------------------------
1) Sort the original dataset       PROC SORT DATA=ORIG;  BY IDNO;
   on a variable that indicates
   duplicated obs, e.g. IDNO.

2) Create a set of dups only by    DATA DUPS;
   only including obs that are        SET ORIG;
   NOT the first occurrence of        BY IDNO;
   each IDNO.                         IF NOT FIRST.IDNO;

3) Print it.                       PROC PRINT DATA=DUPS:

That was an "easy" one.  And now for the SQL answer.  Howard ?


 *--------------------------------------------------------------------------*
 | Ray Pass, Ph.D.                                    Voice: (212) 305-7748 |
 | Columbia-Presbyterian Medical Center                 Fax: (212) 305-3302 |
 | 161 Ft. Washington Ave.       AP1310                                     |
 | New York, NY 10032-3784               passray@cpmail-nz.cis.columbia.edu |
 *--------------------------------------------------------------------------*
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Via: uk.ac.leicester; Thu, 3 Sep 1992 15:20:46 +0100
Newsgroups: bit.listserv.sas-l
Date:         Thu, 3 Sep 1992 15:20:00 BST
Reply-To:     Mail_System@LEICESTER.AC.UK
From:         Mail_System@LEICESTER.AC.UK
Subject:      %% Undelivered Mail %%
Comments: To: SAS-L <SAS-L@VTVM2.CC.VT.EDU>

Your mail was not delivered as follows:
%MAIL-E-USERSPEC, invalid user specification '@UK.AC.LEICESTER.IRIX'

Your original mail header and message follow.

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
Via: UK.AC.NSFNET-RELAY; Thu, 3 Sep 92  15:20 BST
Received: from vtvm2.cc.vt.edu by sun3.nsfnet-relay.ac.uk with Internet SMTP
          id <g.22617-0@sun3.nsfnet-relay.ac.uk>;
          Thu, 3 Sep 1992 15:19:34 +0100
Received: from vtvm2.cc.vt.edu by VTVM2.CC.VT.EDU (IBM VM SMTP V2R2) with BSMTP
          id 9240; Thu, 03 Sep 92 10:18:07 EDT
Received: from VTVM2.BITNET by vtvm2.cc.vt.edu (Mailer R2.08 R208002)
          with BSMTP id 9321; Thu, 03 Sep 92 10:18:06 EDT
Date: Thu, 3 Sep 1992 10:10:58 EDT
Reply-To: Howard Schreier <HIS%BITNET.NIHCU@EDU.VT.CC.VTVM2>
Original-Sender: "SAS(r) Discussion" <SAS-L@EDU.VT.CC.VTVM2>
From: Howard Schreier <HIS%BITNET.NIHCU@EDU.VT.CC.VTVM2>
Subject: SAS Communications
To: Multiple recipients of list SAS-L <SAS-L@EDU.VT.CC.VTVM2>

CONTENT:  Announcement
SUMMARY:  Several SAS-L regulars in new SAS Communications

After participating in SAS-L for a while, you start to  feel
you  "know"  many  of  the other regulars.  Then you realize
that you don't know what most of them look like.

SAS-L  is  well  represented  in  the  latest   (92Q3)   SAS
Communications,  especially  in the photos.  Take a look and
you'll see Ray Pass, Pete Rikard, and Anup Roy (I  hope  I'm
not leaving anyone else out).

/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\
\   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    \
\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
End of returned mail
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
X-Acknowledge-To: <JBALENT@UKCC.UKY.EDU>
Newsgroups: bit.listserv.sas-l
Date:         Wed, 26 Aug 1992 10:56:10 EDT
Reply-To:     Jean Balent <JBALENT@UKCC.UKY.EDU>
From:         Jean Balent <JBALENT@UKCC.UKY.EDU>
Subject:      SAS job openings

I wish SAS Institute would post their job opening listing to this
bulliten board.  Anyone one from SAS listening that could help?
How tough is it for an out-of-state person to get a job at SAS?
Are most of SAS's employees native of North Carolina?
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sas-l
Date:         Wed, 26 Aug 1992 15:38:00 CDT
Reply-To:     padaki <PADAKI@TAMVM1.BITNET>
From:         padaki <PADAKI@TAMVM1.BITNET>
Subject:      greplay

I am trying to get 6 two dimensional and one 3 dimensional plot using
  PROC GREPLAY.  Somehow, when I run  the program it complains
  about the 3 dimensional plot 's name not in igout specification.

What I want to know is, is it possible to have two and three dimensional
   plots on the same page using Greplay.  I also would like to know
   whether I can have many three dimensional plots on the same page
   using Greplay procedure.

                                  SAS6.04/ MSDOS 4.0 386/25 PC
Thanks in advance


                  Padmanabh M. Padaki         Padaki@tamvm1
                    User Services
                  Texas A&M University
                  College Station, TX 77843-3142
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
X-Envelope-to: SAS-L@VTVM2.BITNET
X-VMS-To: RCCW21::IN%"SKPWORK@SUVM.BITNET"
X-VMS-Cc: BITNET::"SAS-L@VTVM2.BITNET"
MIME-version: 1.0
Content-transfer-encoding: 7BIT
Newsgroups: bit.listserv.sas-l
Date:         Mon, 31 Aug 1992 13:41:46 -0400
Reply-To:     "Harlene C. Gogan: RTI's PC-SAS Technical Consultant"
              <RTIHCG@RTI.BITNET>
From:         "Harlene C. Gogan: RTI's PC-SAS Technical Consultant"
              <RTIHCG@RTI.BITNET>
Subject:      Re: Transporting SAS Files: OBSERVATIONS article
Comments: To: SKPWORK@SUVM.BITNET

--------------------------------------------------------------------
CONTENT:  Follow-up on what Observations is
SUMMARY:  Observations is SAS Institute's Technical Journal
E-ADDR:   RTIHCG@RTI.BITNET
NAME:     Harlene C. Gogan
PH/ADDR:  (919) 541-6565 / RTI, PO 12194, RTP, NC 27709
DATE/TIME:  Aug 31, 1992: 13:30 EST
--------------------------------------------------------------------
Please forgive my assumption that everyone reading my SAS-L posting
on the Observations article about transporting SAS files would know
what "Observations" is.  "Observations" is "the Technical Journal
for SAS Software Users" produced by SAS Institute.  Mike Kalt is the
Technical Editor and Judy Whatley the Managing Editor.

The first issue premiered 4th quarter 1991: issues are published quarterly.
Subscription information inside Observations prices subscriptions at
$49 per year and single copies at $15.  To quote SI, "International
customers should contact their local SAS Institute office".

From the quality and diversity of articles in the 4 issues published to
date, IMHO it's well worth the $49.

______________________________________________________________________
>     Hate to confess my ignorance.  I would appreciate info.
>on what Observations is and how may one obtain a copy.

Forgive my lack of inclusion of this information in my original posting.

-Harl

Harlene C. Gogan
RTI's PC-SAS Technical Consultant
Research Triangle Institute
PO 12194
Research Triangle Park, NC 27709
BITNET:   RTIHCG@RTI.BITNET
INTERNET: RTIHCG%ZEUS@RTI.RTI.ORG
Newsgroups: bit.listserv.sas-l
From: retzer@convex.csd.uwm.edu (Joe J Retzer)
Subject: Mixing fonts 
Originator: retzer@convex.csd.uwm.edu
Reply-To: retzer@convex.csd.uwm.edu
Organization: University of Wisconsin - Milwaukee
Date: Sun, 30 Aug 1992 00:55:47 GMT

I have a graph that has labels for the x, y and z axis which mix
(or I should say I would like to mix :-)) greek and english letters.
The problem is that if I set the font for the labels (in my goptions
statement) to cgreek, I cant put in an english charactor. 
For example, I'd like to label one axis:
 
		      D(p)

where the "p" appears as the greek letter pi. The problem is 
that the "D" appears as the greek letter delta (a triangle).
I'd like the "D" to remain as the english charactor "D".
Any suggestions would be appreciated.

		      Many Thanks in advance,
			     Joe Retzer
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Via: uk.ac.leicester; Thu, 3 Sep 1992 15:19:45 +0100
Newsgroups: bit.listserv.sas-l
Date:         Thu, 3 Sep 1992 15:19:00 BST
Reply-To:     Mail_System@LEICESTER.AC.UK
From:         Mail_System@LEICESTER.AC.UK
Subject:      %% Undelivered Mail %%
Comments: To: SAS-L <SAS-L@VTVM2.CC.VT.EDU>

Your mail was not delivered as follows:
%MAIL-E-USERSPEC, invalid user specification '@UK.AC.LEICESTER.IRIX'

Your original mail header and message follow.

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
Via: UK.AC.NSFNET-RELAY; Thu, 3 Sep 92  15:19 BST
Received: from vtvm2.cc.vt.edu by sun3.nsfnet-relay.ac.uk with Internet SMTP
          id <sg.22549-0@sun3.nsfnet-relay.ac.uk>;
          Thu, 3 Sep 1992 15:18:24 +0100
Received: from vtvm2.cc.vt.edu by VTVM2.CC.VT.EDU (IBM VM SMTP V2R2) with BSMTP
          id 9228; Thu, 03 Sep 92 10:16:05 EDT
Received: from VTVM2.BITNET by vtvm2.cc.vt.edu (Mailer R2.08 R208002)
          with BSMTP id 9245; Thu, 03 Sep 92 10:16:04 EDT
Date: Thu, 3 Sep 1992 10:08:02 EDT
Reply-To: Howard Schreier <HIS%BITNET.NIHCU@EDU.VT.CC.VTVM2>
Original-Sender: "SAS(r) Discussion" <SAS-L@EDU.VT.CC.VTVM2>
From: Howard Schreier <HIS%BITNET.NIHCU@EDU.VT.CC.VTVM2>
Subject: WHERE & FIRSTOBS
To: Multiple recipients of list SAS-L <SAS-L@EDU.VT.CC.VTVM2>

CONTENT:  Comment
SUMMARY:  SQL WHERE and global SAS WHERE not same thing
REL/PLTF: 6.06+

> In all procs WHERE and OBS/FIRSTOBS are mutually exclusive.
> HOWEVER, look at the PROC SQL <options>; there is one to
> control the number of observations (I think) and the number
> of loops (essentially a "govenor" of sorts).

But,  the  SQL  WHERE  clause  and  the  SAS  WHERE  feature
(implemented  both  as a statement and as a data set option)
are two different things which just happen to share a name.

/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\
\   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    \
\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
End of returned mail
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sas-l
Date:         Mon, 31 Aug 1992 11:41:02 CET
Reply-To:     Arnold Schick <SCHICK@DMRHRZ11.BITNET>
From:         Arnold Schick <SCHICK@DMRHRZ11.BITNET>
Subject:      Re: print dup records

LYCACC@RITVM.BITNET asks:
>
> I wonder if anyone knows a "easy" way to print duplicate records in a
> data set.  ...
>

Hallo,

I would like to add one feature to the discussion about dup keys/records
within a SAS data set here:

when the SAS data set is to create from an external file, which has (perhaps)
duplicate records and does not span hard-disk-space if it is stored twice,
then helps the following SAS program:

           filename file_in 'see operating\system/dependent:conventions.ext';
           filename doubles ' = .dou';
           filename cleared ' = .cle';
           data _NULL_ ;
             infile file_in;
             input rec $char132. ;   *must be longer or equal as longest rec;
             rec_1pre = lag1(rec);
             rec_2pre = lag2(rec);
             rec_3pre = lag3(rec);
             if (rec = rec_3prev) or
                (rec = rec_2prev) or
                (rec = rec_1prev) then do; file doubles; put rec; end;
                                  else do; file cleared; put rec; end;
          run;
          data to_print;
            infile doubles ;
            input bill1-bill13;
          run;
          proc print data=to_print;
            title 'Doubles' ;
          run;

A sort can also be done by sorting of RECs with proc SORT, if _NULL_ is
substiuted with another data set name and the sorting proc is called. In this
example is only the first or second or thrird successor record of double
presenting relevant. It writes this record to another file and read this
file into a SAS data set separatly.


Arnold Schick  University of Marburg/Germany
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sas-l
Date:         Thu, 3 Sep 1992 03:07:00 GMT
Reply-To:     Joseph A Schunk <0001007026@MCIMAIL.COM>
From:         Joseph A Schunk <0001007026@MCIMAIL.COM>
Subject:      re: sql questions

>Date:     Wed Sep 02, 1992  4:01 pm  PDT
>From:     Ray Pass
>Subject:  Finding non-dups via SQL
>I need two listings, one showing the cases in FILE1 that
>aren't in FILE2, and the other, obviously showing those in FILE2 that aren't
>in FILE1.  I don't want to see the dups.  The only var that I care about in
>matching is CASENO.  In other words I only want to match on the key CASENO.

Have you tried the relational operator EXCEPT:

proc sql;
   title1 'Cases in file1 and not in file2';
   select caseno from file1
     except
   select caseno from file2
   ;
 ... PROC ETC ...

>Date:     Wed Sep 02, 1992  5:48 pm  PDT
>From:     Jim Clark
>Subject:  SQL again - Conflict between WHERE and OBS option
>54             select
>55               max(dep), max(crs), max(sec), max(ins), 0, ., ., ., ., .,
>max(n), mean(mn)
>56               from freq
>57               where qn<26
>58               group by dep, crs, sec, ins;
>ERROR: A where clause may not be used with the FIRSTOBS or the OBS data set

In all procs WHERE and OBS/FIRSTOBS are mutually exclusive. HOWEVER, look
at the PROC SQL <options>; there is one to control the number of
observations (I think) and the number of loops (essentially a "govenor" of
sorts).

  +------------------------------------------------------------+
  |  MCI Mail:  JSchunk or 100-7026                            |
  |  Telex (MCI/WUI): 6501007026   Ans: 6501007026MCI UW       |
  |  Internet:  JSchunk@MCIMail.Com                            |
  |  X.400: G=joseph; S=schunk; ADMD=mci; C=us;                |
  +------------------------------------------------------------+
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
From: tamara@glia.biostr.washington.edu (tiny t)
Newsgroups: bit.listserv.sas-l
Subject: Re: Syntax-Sensitive Editing for SAS Programming (fwd)
Date: 28 Aug 92 18:31:24 GMT
Organization: Dept Biological Structure-University of Washington

In response to Phil Miller's flame re: batch vs. interactive
processing.

sh folks. Everyone is really steaming lately. Is it the hurricane.

B
I was not in anyway advocating that one use interactive SAS
instead of Batch, Phil. I was only answering a question about
editors. I was trying to explain that one can use emacs in
batch actually.

I was trying to suggest that there might be another option.
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU