HDTenEightyP/NetNews huggingface dataset:
From: news@sci.kun.nl (News owner)
Subject: Re: SAS on Alpha ?
 
Organization: University of Nijmegen, The Netherlands
Date: Tue, 26 Jan 1993 21:27:20 GMT

In one of the latest issues of 'Communications' I read that SAS Institute is
indeed developing a SAS version for DEC Alpha machines. 
I'm afraid you can't license that one yet, because it's still under
development. I've seen it working at the last meeting of HUGS, the Holland
User Group for SAS at The Hague.
 
Jos Grote Punt
Heeskesacker 1423
6546  JK NIJMEGEN
tel. +31 (80) 783097
The Netherlands
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Return-Path: <@OHSTVMA.ACS.OHIO-STATE.EDU:SAS-L@VTVM2.BITNET>
X-Envelope-to: sas-l@vtvm2.BITNET
X-VMS-To: SAS-L
X-VMS-Cc: RJOHNSON
MIME-version: 1.0
Content-type: TEXT/PLAIN; CHARSET=US-ASCII
Content-transfer-encoding: 7BIT
Newsgroups: bit.listserv.sas-l
Date:         Tue, 26 Jan 1993 21:49:17 -0400
Reply-To:     BOB <RJOHNSON@VCUVAX.BITNET>
From:         BOB <RJOHNSON@VCUVAX.BITNET>
Subject:      Re: Unmatched quotes (excedrin #607)

 Robert Cymbala / North American Maple Project writes:

> The most frustrating thing about SAS Display Manager is having unmatched
> quotes in  submitted lines and  not being able  to recover. Often  I use
> BYE to quit, and then restart SAS (6.07).
>
> How do I avoid that?  Is there a command-line command that
> "refreshes" ?  Lately, I noticed that single-quotes in comments like:
>  %* PROC SORT That's already done previously. ;
> cause problems too.
>
>  * * *

A possible pain reliever for the first throe:

        After you realize that an dangling quote has suspended your program,
        try submitting the line
                        "; run cancel;
        to hopefully end the string and abort the submission. (Or is that
        string up the end and submit to the abort?)


(Bob)   Robert E. Johnson
        Department of Mathematical Sciences
        Virginia Commonwealth University
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sas-l
Date:         Wed, 27 Jan 1993 10:27:14 EST
Reply-To:     MORRISF@PACEVM.BITNET
From:         MORRISF@PACEVM.BITNET
Subject:      Measurements of Income Inequality

Dear SASperts:

Does anyone have code that will generate the Gini, Theil and Atkinson
statistics that relate to income inequality (we run SAS 6.07 under
VM/ESA).

                           Thanks;
                           Walter Morris
                           Pace University
                           Economics
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Subject: (no subject given)
Return-Path: <@OHSTVMA.ACS.OHIO-STATE.EDU:meij@pop.psu.edu>
Newsgroups: bit.listserv.sas-l
Date:         Fri, 22 Jan 1993 12:40:56 -0500
Reply-To:     "Hendrik K. Meij" <meij@POP.PSU.EDU>
From:         "Hendrik K. Meij" <meij@POP.PSU.EDU>
Comments: To: sas-l@ohstvma.acs.ohio-state.edu

Dear SAS'ers,

We got a problem here. In v5 PROC LOGIST a model with censored data
appears to be running fine (it converges). When we rerun these
models in v6's PROC LOGISTIC, the model does not converge. Are there
parameters which have a different meaning between these two PROC's we
should know about ??

Thanks for any help offered.
-Henk


      * * * * * * * *   Hendrik K. Meij
      *             *
      * Penn  State *   Population Research Institute
      *             *   -------------------------------------------
      *   1 8 5 5   *   meij@pop.psu.edu               814-863-7375
       *           *    22 Burrowes Building
         *       *      University Park, PA 16802
             *
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sas-l
Date:         Thu, 28 Jan 1993 10:08:20 CST
Reply-To:     LISA KRIESE <ANSC413@UNLVM.BITNET>
From:         LISA KRIESE <ANSC413@UNLVM.BITNET>
Subject:      thanks -- animals and weather question

Many thanks to Kernon Gibes, Joe Kelley, Chap Gleason, Pete Rikard
and Robert Hamer for their insightful answers to merging animal data
with daily weather information.  If anyone would like a copy of the
program the graduate student successfully used, respond to me and
I will send you a copy.  Thanks again.
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
X-Mailer: ELM [version 2.2 PL16]
Newsgroups: bit.listserv.sas-l
Date:         Tue, 26 Jan 1993 08:33:13 CST
Reply-To:     "R. Snyder" <rsnyder@LOBBY.TI.COM>
From:         "R. Snyder" <rsnyder@LOBBY.TI.COM>
Subject:      SAS Performance, Hard Disk controllers
Comments: To: sas-l@uga.cc.uga.edu

SUBJECT:   PC Disk I/O Speed
SUMMARY:   "32 bit" disk access under Windows
E-ADDR:    rsnyder@lobby.ti.com
NAME:      Bob Snyder
COMPANY:   Texas Instruments, Sherman, TX
PHONE:     (903) 868-5799
FAX:       (903) 868-7240

<Stuff Deleted>
>
> Hard disk controllers: there is some literature that indicates that a
> good software cache is close to equivalent to a hardware caching
> controller. This seems to run counter to a previous posting; your
> mileage may vary.  It's also not easy to know what caching is going
> on in your hardware; some cache is almost always included.  I *think*
> many IDE drives included in Gateway systems have had some cache.
>
<Stuff Deleted>
>
>  --Nelson R. Pardee,  Computing Services, Syracuse University          --
>  --120 Hinds Hall, Syracuse, NY 13244-1190 USA   (315)443-1079         --
>  --Bitnet: SASMAINT@SUVM     Internet: SASMAINT@SUVM.ACS.SYR.EDU       --
>
Nelson,

One thing I have observed is that if you are able to use the "32 bit" disk
access mode in Windows, disk operations speed up dramatically.

Bob
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Encoding: 43 TEXT
X-Mailer: Microsoft Mail V3.0
Newsgroups: bit.listserv.sas-l
Date:         Fri, 22 Jan 1993 13:21:00 EST
Reply-To:     rjf2@PHPDLS1.EM.CDC.GOV
From:         rjf2@PHPDLS1.EM.CDC.GOV
Subject:      Concatenating format catalogs under 6.07
Comments: To: SAS-L@uga.cc.uga.edu

content      : Response
summary      : use of several format-libs:
               use multiple LIBNAME LIBRARY '<libref>'; statements
rlse/platform: V6.07 / MVS
Ron Fehd     :                SMTP:BitNet:    <rjf2@phpdls1.em.cdc.gov>
              Centers for Disease Control
              1600 Clifton Rd  MS:G25         FAX  : 404/639-1778
              Atlanta, GA 30333  USA          phone: 404/639-1707
?????????????????????????????????????????????????????????????????????????
From:         Jeff Davis <NY921603%PACEVM.BITNET@uga.cc.uga.edu>
Subject:      Concatenating format catalogs under 6.07
Does anyone know how to access more than one format catalog under
SAS 6.07 in the same SAS session or job?  Under MVS SAS 5.18 you
were able to concatenate the format libraries in the JCL.  Can you
concatenate 6.07 format catalogs in MVS?  What about CMS?  I
**don't** want to have to use PROC CATALOG to copy the format
entries to the WORK format catalog.  I have not been able to find
anything in Language, Procedures, Language and Procedures,
Companion for CMS or Companion for MVS.

Any clue?
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
somewhere, (in a galaxy far, far away,) I remember reading that you can
access multiple sets of formats stored in different SAS libraries by using
several LIBNAME statements with the same libref=LIBRARY:

LIBNAME LIBRARY '<SAS-data-lib-1>';
<use formats>;
run;
LIBNAME LIBRARY '<SAS-data-lib-2>';
<use formats>;
run;
...
LIBNAME LIBRARY '<SAS-data-lib-n>';
<use formats>;
endSAS;

check your proc FORMAT information:
SAS Proc Guide,V6 pg 280: Storing Formats and Informats
                  pg 295-6: Temporary and Permanent Formats and Informats

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!happy crunching*************************
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sas-l
Date:         Wed, 27 Jan 1993 08:30:58 EST
Reply-To:     Tom Bruulsema <XPEX@CORNELLA.BITNET>
From:         Tom Bruulsema <XPEX@CORNELLA.BITNET>
Subject:      Expanded memory with PC-SAS

I recently installed PC-SAS version 6.04 on an IBM PS/2 L40SX with
a 386SX processor and 4MB RAM.  PROC ANOVA and PROC GLM work fine
but when I try a moderately large factorial model in PROC GLM I get an
insufficient memory message.  From the instructions in  the SAS/STAT
manual I calculate that this problem should require about 1.2 MB of RAM.
I use HIMEM.SYS and EMM386.SYS as memory managers and I've tried this
problem with both 512 K expanded memory and with 2048 K expanded memory.
Can PC-SAS use expanded memory for PROC GLM's matrix manipulations?
Any suggestions on ways around this problem would be gratefully received.
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sas-l
Date:         Wed, 27 Jan 1993 08:38:20 EST
Reply-To:     Howard Schreier <HIS@NIHCU.BITNET>
From:         Howard Schreier <HIS@NIHCU.BITNET>
Subject: Re: Comma delimted ASCII files with missing variables...

CONTENT:  Response
SUMMARY:  DSD option handles typical comma-delimited files
REL/PLTF: 6.07+

>     A small problem, which was probably covered in the long discussion about
> commas, but I didn't read it all as I am rather pushed for time.
>     Anyway, I have a small (in terms of number of variables, large number of
> subjects) set of data, produced by someone else that is comma delimted.  Using
> the delimiter= option in the infile statement is fine, except when there is
> missing data, as there are simply two commas in such a case, and SAS reads the
> simply as one comma.  eg
>
> 1,2,3,4,5    This line is normal.  Well, the values are purely illustrative...
> 1,2,,4,5     <- 3rd variable is missing.
>
>     I can't get the data changed.  I could get an editor to execute a simple
> search and replace routine, but I am working on a noddy-proof system, so I
> have to be able to solve this within SAS, if at all possible.  Has anyone got
> anysuggestions?  (I tried to use the SCAN function, too, but that does the
> same thing...)  RTFM is fine, but which FM and which page...  (Read the
> archives is fine, too, but which archive and how to get the thing...)

If you are running 6.07 --

   FM:    Tech. Report P-222
   Page:  30

Summary:  DSD option on the INFILE statement will  make  the
comma  the  default  delimiter,  cause SAS to impute missing
values  between  consecutive  delimiters,  and   allow   the
delimiter character to appear within a quoted string.

/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\
\   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: mschaeff@pilot.njin.net (Marc Schaeffer)
Newsgroups: bit.listserv.sas-l
Subject: THANKS
Keywords: SAS 607 VMS
Date: 22 Jan 93 20:32:43 GMT
Organization: Rutgers Univ., New Brunswick, N.J.


Thanks to those who responded to my question about how to change the
sign of some variables in a financial data set.  The array suggestions
probably would work but Jim from Notre Dame makes me embarrassed I
asked by suggesting just to multiply by minus 1!!!  

I made the cardinal mistake of forgetting the K.I.S.S. theory of
coding (Keep it Simple Stupid!).
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sas-l
Date:         Wed, 27 Jan 1993 10:53:57 CST
Reply-To:     LISA KRIESE <ANSC413@UNLVM.BITNET>
From:         LISA KRIESE <ANSC413@UNLVM.BITNET>
Subject:      merging animal and weather data

     I have a graduate student that would really like to use SAS for the
following problem and I don't know where to send him in the FM to
begin this problem.

      SAS platforms we have available are SAS on cms -- 6.07 on a
small ibm 4381, pc sas and os/2 sas --- 6.06.

      He has animal data with beginning and ending dates on trial.  Some
animals will start on the same day, but most end on different days.  In
another file he has daily weather information.  He needs to find the
average weather information for each animal given their beginning and
ending dates  (on average 3 months worth of weather data) on trial.

      Any clues?  Any suggstions?  I suggested he write a FORTRAN program
but he is vehemently against that idea.  Any suggestions for him will be
greatly appreciated.

Lisa Kriese                            ansc413@unlvm
Research Associate
Roman L. Hruska Meat Animal Research Center
Clay Center, NE
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Return-Path: <@OHSTVMA.ACS.OHIO-STATE.EDU:SAS-L@VTVM2.BITNET>
Return-Path: <@AWIIMC12.IMC.UNIVIE.AC.AT,
             @AWIIMC12.IMC.UNIVIE.AC.AT:BTD0@NIORDS1.EM.CDC.GOV>
Encoding: 11 TEXT
X-Mailer: Microsoft Mail V3.0
Newsgroups: bit.listserv.sas-l
Date:         Tue, 26 Jan 1993 09:06:00 EST
Reply-To:     BTD0@NIORDS1.EM.CDC.GOV
From:         BTD0@NIORDS1.EM.CDC.GOV
Subject:      mult group t-tests
Comments: To: sas-l@awiimc12.imc.univie.ac.at

I am trying to put together code to perform multiple t-tests across 11 drug
catoegories for tissue mean responses.  An assumption of unequal variances
must be satisfied....(the result should be 55 t-tests).  Does anyone have
code for this type of procedure?  Or a reference to codes in the SUGI guides?

Thanks in advance.


                              Brian Day
                              BTD0@NIORDS1.EM.CDC.GOV
                              Phone: (304) 291-4501
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sas-l
Date:         Wed, 27 Jan 1993 07:43:58 -0600
Reply-To:     Kernon Gibes <gibes@SWIRL.MONSANTO.COM>
From:         Kernon Gibes <gibes@SWIRL.MONSANTO.COM>
Subject:      RE: Dearth of ZAPs available from FTP.SAS.COM
Comments: To: SAS-L@uga.cc.uga.edu@tin.monsanto.com
Comments: cc: GIBES@tin.monsanto.com

Regarding:

>If you've been wondering why no "new" ZAP-files have been made available
>for anonymous-FTP to 'FTP.SAS.COM' since October 25, I've been told:
>
>! As far as zaps not being added for FTP, this goes back to the fact that
>! we are now doing source code fixes, and not writing new zaps,
>! thus there is nothing to add to anonymous FTP.
>
>I didn't ask whether they've also discontinued the updating of
>the Usage Note databases which also are available via the same method. :-(

What about Z6075789?  The usage note that was just sent out indicates
that such a ZAP has been written, but I can't find it (for VMS) via FTP.
Is it just that VMS got cheated?

Kernon Gibes
Internet: gibes@swirl.monsanto.com
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Return-Path: <@OHSTVMA.ACS.OHIO-STATE.EDU:IMAD.GHANDOUR@mail.admin.wisc.edu>
Newsgroups: bit.listserv.sas-l
Date:         Thu, 21 Jan 1993 11:00:00 CST
Reply-To:     IMAD.GHANDOUR@MAIL.ADMIN.WISC.EDU
From:         IMAD.GHANDOUR@MAIL.ADMIN.WISC.EDU
Subject:      Signing to SAS-L
Comments: To: sas-l@ohstvma.acs.ohio-state.edu

to: sas-l@ohstvma.acs.ohio-state.edu

Can anybody tell me how to sign to SAS-L. Thanks.

email: imad.ghandour@mail.admin.wisc.edu
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Return-Path: <@OHSTVMA.ACS.OHIO-STATE.EDU:SAS-L@VTVM2.BITNET>
Posted-Date:     21 Jan 93 13:06:26 EST
X-Pmrqc:  1
X-Mailer: Pegasus Mail v2.3 (R1).
Newsgroups: bit.listserv.sas-l
Date:         Thu, 21 Jan 1993 13:06:26 EST
Reply-To:     Ted Greenstein <TED@SERVER.SASW.NCSU.EDU>
From:         Ted Greenstein <TED@SERVER.SASW.NCSU.EDU>
Subject:      Comparing SAS under Windows and OS/2
Comments: To: sas-l@vtvm2.bitnet

Has anybody done or seen a comparison of SAS for Windows running
under Windows 3.1 as compared to SAS for OS/2 running under OS/2 2?
I'd be curious to hear anyone's reactions as to which platform would
be preferable, all things being equal.


Theodore N. Greenstein
307 1911 Building
Department of Sociology and Anthropology
North Carolina State University
Raleigh, NC 27695-8107

Voice: (919) 515-3114  FAX: (919) 515-2610
Email: ted_greenstein@ncsu.edu
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Return-Path: <@OHSTVMA.ACS.OHIO-STATE.EDU:SAS-L@VTVM2.BITNET>
Newsgroups: bit.listserv.sas-l
Date:         Tue, 26 Jan 1993 12:36:00 EST
Reply-To:     "Philip Gallagher,(919)966-1065" <UPHILG@UNC.BITNET>
From:         "Philip Gallagher,(919)966-1065" <UPHILG@UNC.BITNET>
Subject:      Changing order of variables in a SAS dataset
Comments: cc: ted@SERVER.SASW.NCSU.EDU

Ted Greenstein <TED@SERVER.SASW.NCSU.EDU>
    writes enquiring about changing the order of variables
    in a SAS dataset.  I knew that I didn't know the answer to
    this, for I have never had the need to do it.  I suppose it
    might be useful if one were preparing datasets for students
    who were too naive to use VAR stmnts, or something like that,
    though.  Ted wrote asking for a solution that works for 6.08
    in Windows;  my soln was tested in 5.18, but I hope it will work
    for 6.08 as well.

    My first expectation was that clever use of either a KEEP stmnt
    or a KEEP= dataset option would accomplish the re-ordering, but
    I tried it and proved to myself that neither device reordered the
    variables in any of the ways that I implemented them.

    Then I resorted to (first) something I knew would work, namely
    creating a dummy (no observations) dataset using a datastep with
    nothing but a LENGTH stmnt in which I ordered the variables in
    the desired order.  Then, I created a new dataset by concatenating
    the old (unwanted order) dataset onto the dummy (desired order)
    dataset, for I knew that SAS would take the order from the first
    dataset it encountered.  This worked.  (I was using 5.18, and
    the resulting concatenation had an unexpect first observation
    of all missing values from the nominally 0 observation dummy
    dataset, and I had to put in a stmnt to delete that observation,
     - unnecessarily nasty complication - I think it is different in
     6.04, but I haven't checked yet.)

    Finally I tried using the LENGTH stmnt in a datastep, preceding
    the SET stmnt;  as I expected, everything worked fine.
    Here is the code that produced the final result;  needless to
    say, it is much simpler than producing a dummy dataset and
    concatenating onto it.

    I am surprised that the KEEP stmnt/dataset didn't do the
    reordering, but that shows how little I know about how
    the SAS compiler works when it is establishing the characteristics
    of a dataset.  I know a tiny bit more, now.

                           Phil Gallagher
                           uphilg@unc

DATA NEW;
   ARRAY ZAP {10} var1-var10;
   DO I = 1 TO 10; ZAP{I} = I; END;    drop i;
RUN;
PROC PRINT;  TITLE 'Original order';  run;

DATA NEWEST;
    length VAR10 VAR9 VAR8 VAR7 VAR6 VAR5 VAR4 VAR3 VAR2 VAR1 8;
    SET NEW; RUN;
PROC PRINT;  TITLE 'Order via DATAstep LENGTH stmnt';  run;
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
From: meij@pop.psu.edu (Hendrik K. Meij)
Subject: sas v5 logist vs v6 logistic
Organization: Penn State Population Research Institute
Date: Fri, 22 Jan 93 17:36:32 GMT

Dear SAS'ers,

We got a problem here. In v5 PROC LOGIST a model with censored data
appears to be running fine (it converges). When we rerun these
models in v6's PROC LOGISTIC, the model does not converge. Are there
parameters which have a different meaning between these two PROC's we
should know about ??

Thanks for any help offered.
-Henk


      * * * * * * * *   Hendrik K. Meij
      *             *
      * Penn  State *   Population Research Institute
      *             *   -------------------------------------------
      *   1 8 5 5   *   meij@pop.psu.edu               814-863-7375
       *           *    22 Burrowes Building
         *       *      University Park, PA 16802
             *      
-- 

-=- -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- -=-

  * * * * * * * *   Hendrik K. Meij
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Encoding: 9 TEXT
X-Mailer: Microsoft Mail V3.0
Newsgroups: bit.listserv.sas-l
Date:         Thu, 21 Jan 1993 16:26:00 EST
Reply-To:     PXG6@ATSDHS2.EM.CDC.GOV
From:         PXG6@ATSDHS2.EM.CDC.GOV
Subject:      mult. set stmts
Comments: To: SAS-L@uga.cc.uga.edu

Thanks to all who answered my questions on multiple set stmts. and detecting
end of file.  I have tried to thank everyone personally but if I missed some
of you, please consider this a hardy "THANK YOU" from a struggling SAS
programmer.


Phil Graffunder
pxg6@atsdhs2.em.cdc.gov
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Return-Path: <@OHSTVMA.ACS.OHIO-STATE.EDU:SAS-L@VTVM2.BITNET>
Newsgroups: bit.listserv.sas-l
Date:         Sun, 24 Jan 1993 13:59:00 EST
Reply-To:     Jay Jacob Wind <JWJ@NCCIBM1.BITNET>
From:         Jay Jacob Wind <JWJ@NCCIBM1.BITNET>
Subject:      Need transportation from East Coast of Florida to Tampa

Hi everybody!
I shall be on the east coast of Florida near Pompano Beach/Fort
Lauderdale on Sunday Morning February 14.  From there, I'm heading to
NESUG in Tampa.
Is anyone out there in SAS-Land driving from East Florida to Tampa?
I'll gladly share the driving and the expenses in exchange for
scintillating conversation.
Please call me at (703) 920-5193 or reply directly.  Thanks!
-----
Jay Jacob Wind                      ____ ___ ___
American Environmental Institute           
611 South Ivy Street                -- --  
Arlington, VA  22204                   __ __
(703) 920-5193 (VOICE)
(703) 521-6157 (FAX)          JWJ@EPAIBM.RTPNC.EPA.GOV
From: MSZ03@ALBNYDH2.BITNET (Mike Zdeb)
Newsgroups: bit.listserv.sas-l
Subject: PROC SQL
Date: 21 Jan 93 16:46:58 GMT
Reply-To: Mike Zdeb <MSZ03@ALBNYDH2.BITNET>
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU

SQL help please - the following gives me matched records plus all
unmatched records from datasets ONE and TWO.  I want to restrict
the content of BOTH to:  matched records (id1=id2) + all unmatched
records from dataset TWO + unmatched records from dataset ONE where
drg1 = '300'.  As an SQL neophyte, no matter what SQL expression I try,
I don't get the desired result. (HOWARD S. HELP !!!!!!!)
-----------------------------------------------------------------------

options nocenter;

data one;
input
@1 id1  $char3.
@5 var1 $char3.
@9 drg1 $char3.;
cards;
123 on1 300
234 on2 200
345 on3 300
;
run;

data two;
input
@1 id2  $char3.
@5 var2 $char3.
@9 drg2 $char3.;
cards;
123 tw1 300
456 tw2 300
;
run;

proc sql;
create table both as
select *
from one full join two
on id1 = id2;

proc print data=both;
run;
Newsgroups: bit.listserv.sas-l
From: news@sci.kun.nl (News owner)
Subject: Re: LCD COmmadnd Line Readability
 
Organization: University of Nijmegen, The Netherlands
Date: Sun, 24 Jan 1993 15:02:00 GMT

The readability of text in the Display Manager windows under SAS release 6.04 
on LCD screens can be enhanced by using the right screen driver.
The best thing to do is create a file named CONFIG.SAS in the directory from 
which you start SAS. 
Be careful if there's already a CONFIG.SAS file in any directories specified 
by a DOS PATH command or int the root ofdirectory. Then you must first copy it to 
the current directory. Then add the following line:
-fsedvice            
 
-fsdevice sasxdcpa 
 
This invokes a special screen driver for LCD and plasma screens. If you still have problems then read pp. 205-208 of 'Technical Report: P-171, Changes and 
enhancements to Base SAS Software for Personal Computers, Release 6.03 (1987).
Whish you luck,
 
J.os Grote Punt
Heeskesacker 1423
6546 JK  NIJMEGEN
tel +31 (80) 783097
The Netherlands
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU