HDTenEightyP/NetNews huggingface dataset:
From: DRH4@psuvm.psu.edu (Daryl R. Hoffman)
Newsgroups: bit.listserv.sas-l
Subject: Re: SI Pmenu Source Code
Date: 16 Oct 92 12:15:06 GMT
Organization: Penn State University

In article <15921015215051/0005400191PK1EM@mcimail.com>, Willy Waks
<0005400191@MCIMAIL.COM> says:
>
>Does anyone knows if the source code for the default Pmenus is
>available somewhere. I'd like to make a copy and edit them for my
>applications, rather than create new ones from scratch.

  I got the following information from Michael Bretz of the Bureau of the
Census at the NESUG 1992 conference.  In order to modify existing SAS Pmenus
copy the SASHELP catalog to your A disk into a new catalog.  The PMENU entries
are in the CORE library in the SASHELP CATALOG.  There are PMENUs for each
window (OUTPUT, LOG, etc.).  You will still need to run PROC PMENU as you can
not modify a PMENU.  You will simply be able to replace the existing PMENU
with one of your customized ones.

  If you need help with this I can send some samples that I have used.

Daryl R. Hoffman              The Pennsylvania State University
Bitnet:   DRH4@PSUVM.BITNET   The Center for Academic Computing
Internet: DRH4@PSUVM.PSU.EDU  Sr. Appl Prog/Anal, Resource Administration
Office: (814) 865-0845        Fax: (814) 863-7049
From: SENKC@LUB001.LAMAR.EDU ((K. C. SEN))
Newsgroups: bit.listserv.sas-l
Subject: Reversed Sign on Coeff. for Dummy Variable
Date: 14 Oct 92 22:14:42 GMT
Reply-To: "(K. C. SEN)" <SENKC@LUB001.LAMAR.EDU>
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
X-Vmsmail-To: SMTP%"SAS-L@UGA.CC.UGA.EDU"
Comments: To: SAS-L@UGA.CC.UGA.EDU

Thanks to all for responding to my query. I went back and found that the
problem was at the JMP end. Incidentally, for the people who asked, I was
comparing the results of a Proc Reg in SAS. The signs of the dummy
variable in the data set was not reversed i.e. it was not a coding error. I
found that within JMP if you declare a dummy variable as a nominal(ly)
scaled variable, the signs get reversed and also there is a slight change
in the values of the intercept term. Declaring the dummy variable as an
intervally scaled variable within JMP produces identical results to the
Proc Reg results in SAS. This can be duplicated with any data set. If
anyone on the net is familiar with JMP, he/she can perhaps come up with
what exactly JMP is doing under the two different declarations.
---- K. C. Sen
Newsgroups: bit.listserv.sas-l
Date:         Thu, 8 Oct 1992 12:17:00 EDT
Reply-To:     Jeff Boyd <BOYDJ@QUCDN.QUEENSU.CA>
From:         Jeff Boyd <BOYDJ@QUCDN.QUEENSU.CA>
Subject:      Re: factorial problem

This is somewhat similar to Philip Gallagher's idea, but based on numeric
assignments.  I too am not certain I understand the problem.


jeff

 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

 /*  written for SAS v607 on VM/ESA  */
 options linesize=79 pagesize=66;

 data one;
    length name $ 5;
    input  @1  name $char5.
           @8  c1  $char1.    @10 c2  $char1.    @12 c3  $char1.
           @14 c4  $char1.    @16 c5  $char1.    @18 c6  $char1.
           @20 c7  $char1.    @22 c8  $char1.    @24 c9  $char1.
           @26 c10 $char1.    @28 c11 $char1.    @30 c12 $char1.
           @32 c13 $char1.;
cards;
NAME1  A . C D . . G . I . K L M
NAME2  . B . D E . . . I . . . M
NAME3  . . C . E . . H . J . . .
NAME4  . . . . . . . . . . . . .
NAME5  . . . . . . . . . . . . M
NAME6  . . . . . . . . . . . L .
NAME7  . . . . . . . . . . . L M
NAME8  A . . . . . . . . . . . .
NAME9  A B C D E F G H I J K L M
;

 proc print data=one;

 data two;
    set one;
    array c {13} $ 1 c1-c13;
    level = 0;
    do i = 1 to 13;
       if (c{i}^='.') then level+2**(13-i);
       end;
    keep name level;

 proc print data=two;


 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

                                 The SAS System

     OBS  NAME   C1  C2  C3  C4  C5  C6  C7  C8  C9  C10  C11  C12  C13

      1   NAME1  A   .   C   D   .   .   G   .   I    .    K    L    M
      2   NAME2  .   B   .   D   E   .   .   .   I    .    .    .    M
      3   NAME3  .   .   C   .   E   .   .   H   .    J    .    .    .
      4   NAME4  .   .   .   .   .   .   .   .   .    .    .    .    .
      5   NAME5  .   .   .   .   .   .   .   .   .    .    .    .    M
      6   NAME6  .   .   .   .   .   .   .   .   .    .    .    L    .
      7   NAME7  .   .   .   .   .   .   .   .   .    .    .    L    M
      8   NAME8  A   .   .   .   .   .   .   .   .    .    .    .    .
      9   NAME9  A   B   C   D   E   F   G   H   I    J    K    L    M



                              OBS    NAME     LEVEL

                               1     NAME1     5719
                               2     NAME2     2833
                               3     NAME3     1320
                               4     NAME4        0
                               5     NAME5        1
                               6     NAME6        2
                               7     NAME7        3
                               8     NAME8     4096
                               9     NAME9     8191
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
From: stdev0c@gauss.med.harvard.edu (stat software dev)
Newsgroups: bit.listserv.sas-l
Subject: SAS TOOLKIT, interfacing with externally written procedures
Date: 9 Oct 92 19:16:57 GMT
Organization: Harvard Medical School


I am interested in finding out whether anyone has been using SAS TOOLKIT for 
incorporating externally written procedures into Version 6 SAS.  As far as I 
know, TOOLKIT is only available on VMS systems so far;  does anyone know when 
there will be a version that will run under UNIX?  Is there a beta version out 
yet?  

In my lab we have been writing SAS macros which access external programs 
(usually written in C or Fortran) via the 'filename pipe' and 'x' facilities, 
All of the interface with the external program (making ascii data files,
control statements, and reading the result data back into SAS) is done
transparent to the user.  

An alternative idea, which I have never tried, is to use DBMSCOPY to do any 
necessary data transformations external from the SAS environment, and then run 
the external program in its own native environment.  

Does anyone have any other approaches? 


Carrie Wager
Programmer Analyst
Channing Lab, Harvard Medical School
From: den0@ns1.cc.lehigh.edu (DEAN E. NELSON)
Newsgroups: bit.listserv.sas-l
Subject: Summary: Reading variable length records
Date: 14 Oct 92 18:14:08 GMT
Organization: Lehigh University

In my last post, I had the following problem:

I have a data file which has 27 records per observation.  Two of the records
have information from column 30 to the end of the record that I would like to
be read as the value of the variables comm1 and comm2.  The data step so far
looks like this:


data dir.erac;
  infile 'erac.dat' n=27;
    input #8  username $ 29-32
          #10 @30 position
          #11 @30 gender
              .
              .
              .
          #24 @30 parking
          #25 @30 comm1 & :$78.
          #26 @30 comm2 & :$78.
          #27;


This works OK but will choke on more than 1 embeded blanks.  I wanted to use
the $varying. format, but don't know how the length of the record would be
handled since I am inputting 27 records a pop.  Does anyone have any ideas?
--------------------------------------------------------------------------
I want to thank everyone who responded.  The easiest method suggested was to
use the TRUNCOVER statement in the infile statement which pads the record with
blanks as far as is needed.  Other solutions given used INPUT @ to read the
record (so the record length was known) and then read the values using the
varying format, and to use the RECFM=F PAD options in the infile statements to
pad the records and make them a fixed length.

-- 
Dean E. Nelson  den0@lehigh.edu  (Internet)
(215)-758-4988  (That is d-e-n-zero, not the letter O)
 
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sas-l
Date:         Fri, 16 Oct 1992 09:44:27 EST
Reply-To:     Marge Scerbo <MSCERBO@UMAB.BITNET>
From:         Marge Scerbo <MSCERBO@UMAB.BITNET>
Subject:      NESUG 92
Comments: To: NESUG-L@UMAB.BITNET

Craig Dickstein and I, CoChairs of NESUG 92, wanted to personally thank
all those people who helped make the conference a success: section chairs,
speakers, session coordinators, poster presenters, registrars, other
volunteers, and most importantly, the attendees.  It looks like we hit
about exactly 900 attendees and we're very pleased with that.

We are evaluating the results of the questionnaires returned (around
200) but it's clear people enjoyed the conference.  The 3 new sections
(SAS Trek, Coder's Corner, and Interactive Systems) were well accepted and
may well return next year.  The Vendor Area was well attended and outside
vendors were present for the first time.  The Video Theatre was packed all
day.

If you attended the conference and did not yet return your questionnaire,
please send it on to Clint now.  If you did not complete the volunteer
form and you're interested in helping next year, send it on to Nancy.
If you didn't get to attend and would like to work next year, call Nancy
Kocher at 617-329-4500.

In case you haven't heard, next year's conference will be in Springfield
Mass. at the Sheraton Springfield Monarch Hotel November 7-9.  More details
will follow over the next few months.

For those of you who were unable to attend but would like to purchase the
proceedings, please send $17 ($15 for the proceedings, $2 for postage) to:
  Mike Murphy
  John Hancock Mutual Life
  PO Box 111 T-51
  Boston, MA  02117

Thanks again!
Organization: Queen's University at Kingston
Date: Wed, 7 Oct 1992 17:08:54 EDT
From: Jeff Boyd <BOYDJ@QUCDN.QueensU.CA>
Newsgroups: bit.listserv.sas-l
Subject: Re: factorial problem


This is similar to Philip Gallagher's idea.  I too am not certain I
understand the problem :-).


jeff

 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

 /*  written for SAS v607 on VM/ESA  */
 options linesize=79 pagesize=66;

 data one;
    length name $ 5;
    input  @1  name $char5.
           @8  c1  $char1.    @10 c2  $char1.    @12 c3  $char1.
           @14 c4  $char1.    @16 c5  $char1.    @18 c6  $char1.
           @20 c7  $char1.    @22 c8  $char1.    @24 c9  $char1.
           @26 c10 $char1.    @28 c11 $char1.    @30 c12 $char1.
           @32 c13 $char1.;
cards;
NAME1  A . C D . . G . I . K L M
NAME2  . B . D E . . . I . . . M
NAME3  . . C . E . . H . J . . .
NAME4  . . . . . . . . . . . . .
NAME5  . . . . . . . . . . . . M
NAME6  . . . . . . . . . . . L .
NAME7  . . . . . . . . . . . L M
NAME8  A . . . . . . . . . . . .
NAME9  A B C D E F G H I J K L M
;

 proc print data=one;

 data two;
    set one;
    array c {13} $ 1 c1-c13;
    level = 0;
    do i = 1 to 13;
       if (c{i}^='.') then level+2**(13-i);
       end;
    keep name level;

 proc print data=two;


 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

                                 The SAS System                                1

     OBS  NAME   C1  C2  C3  C4  C5  C6  C7  C8  C9  C10  C11  C12  C13

      1   NAME1  A   .   C   D   .   .   G   .   I    .    K    L    M
      2   NAME2  .   B   .   D   E   .   .   .   I    .    .    .    M
      3   NAME3  .   .   C   .   E   .   .   H   .    J    .    .    .
      4   NAME4  .   .   .   .   .   .   .   .   .    .    .    .    .
      5   NAME5  .   .   .   .   .   .   .   .   .    .    .    .    M
      6   NAME6  .   .   .   .   .   .   .   .   .    .    .    L    .
      7   NAME7  .   .   .   .   .   .   .   .   .    .    .    L    M
      8   NAME8  A   .   .   .   .   .   .   .   .    .    .    .    .
      9   NAME9  A   B   C   D   E   F   G   H   I    J    K    L    M


                                 The SAS System                                2

                              OBS    NAME     LEVEL

                               1     NAME1     5719
                               2     NAME2     2833
                               3     NAME3     1320
                               4     NAME4        0
                               5     NAME5        1
                               6     NAME6        2
                               7     NAME7        3
                               8     NAME8     4096
                               9     NAME9     8191
From: theall@gdalsrv.sas.upenn.edu (George A. Theall)
Newsgroups: bit.listserv.sas-l
Subject: ANSI.SYS drivers and SAS PC
Date: 11 Oct 92 12:58:09 GMT
Organization: Social Science Computing, University of Pennsylvania


  With SAS PC, issuing "X" from a DM window will cause a system hang unless 
an ANSI driver has been loaded. This I understand. I'd like, however, to 
have an ANSI driver loaded *ONLY* for SAS; eg, have a batch file which loads 
the driver, calls SAS, and then unloads the driver. 

  I've tried some TSRs which claim to provide support for ANSI (eg, PC Mag's 
ANSI.COM) but SAS does not seem to sense them (it hangs on issuing "X"). I 
have also tried some utilities that claim they can load device drivers 
dynamically; eg, the DEVICE.COM that accompanys the book _Undocumented DOS_; 
trouble is, I can't then unload the driver.

  If anyone has any experience doing this I'd love to hear from you.


George
---
theall@gdalsrv.sas.upenn.edu                    Social Science Computing
theall@ssdc.sas.upenn.edu                       University of Pennsylvania
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
X-Vmsmail-To: SMTP%"sas-l@AWIIMC12.IMC.UNIVIE.AC.AT"
Newsgroups: bit.listserv.sas-l
Date:         Fri, 16 Oct 1992 09:50:51 -0400
Reply-To:     Tom Flaherty <FLAHERTY@CCSUB.CTSTATEU.EDU>
From:         Tom Flaherty <FLAHERTY@CCSUB.CTSTATEU.EDU>
Subject:      missing rows/columns
Comments: To: sas-l@AWIIMC12.IMC.UNIVIE.AC.AT

This is a problem that may have no solution within SAS (or maybe it's
obvious and I will look like a fool), but here's hoping.  In our work,
we often have to prepare tables containing data which will later be
entered (manually or electronically) into another computer database.
The problem is that SAS, for obvious reasons, will not print values for
a variable that have no cases.  To pick a very simple example, if we are
using PROC FREQ, say to produce a frequency distribution of the students
at our university by home state, and we have no students from NM, that
line simply does not appear in the report; we just have the NJ line
followed by the NV line.  This creates manifold problems for data
re-entry.  (Please don't ask why we are re-entering data.)

Now, I understand WHY this happens, the question is:  Has anyone figured
out a way to get SAS to print lines in the output whose frequency=0?  We
have even considered manual editing of the reports or output files, but
this gets quite cumbersome when the tables (from PROC TABULATE, say) are
more complicated.  Any help will be greatly appreciated.  Thanks,

--Tom
+--------------------------------------------------------------------+
| Thomas B. Flaherty                      flaherty@ccsu.ctstateu.edu |
| Planning and Institutional Research     Office: (203)827-7305      |
| Central Connecticut State University    FAX:    (203)827-7200      |
| New Britain, CT  06050   USA            Home:   (203)666-3210      |
+--------------------------------------------------------------------+
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
From: sas@NIORDS1.EM.CDC.GOV
Newsgroups: bit.listserv.sas-l
Subject: Nested vars
Date: 14 Oct 92 17:30:00 GMT
Reply-To: sas@NIORDS1.EM.CDC.GOV
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Encoding: 21 TEXT
X-Mailer: Microsoft Mail V3.0 (beta-2)
Comments: To: sas-l@awiimc12.imc.univie.ac.at

Sas list:

     I have an interest in determining the relationship between dust level
and geographic region where cotton was grown. (iv=region, dv=dust).  The
problem is that within the regions(2) there are 6 mills(3 in each region),
and within each mill there are 6 departments.(the departments are the same
across mills).  How do I incorporate these independents to best test the
effect of region on dust?(it is felt that there is too much variability in
dust measurements in individual mills and departments to leave them out of
the analysis).

  To throw another var in, I also have a sample year variable(1 or 2) that
denotes what sample year the dust measurement was taken.  The problem with
year is that in one of the regions only 1 mill has data for the second year.

I am stumped here and would greatly appreciate suggestions.

Brian Day
btd@niords.em.cdc.gov
From: 75046.1627@COMPUSERVE.COM (Michael Davis)
Newsgroups: bit.listserv.sas-l
Subject: Re: FAX & SAS/GRAPH
Date: 17 Oct 92 02:58:47 GMT
Reply-To: Michael Davis <75046.1627@COMPUSERVE.COM>
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Comments: To: sas-l@uga.cc.uga.edu

-----------------------------------------------------------------------
CONTENT:    Reply to Question about Faxing SAS/GRAPH output
SUMMARY:    Two solutions
REL/PLTF:   6.04 MS-DOS, 6.08 Windows Beta
E-ADDR:     0002395748@mcimail.com
P-ADDR:     BC&BS OF Conn., 370 Bassett Road, North Haven, CT 06473
PHONE:      (203)-985-7187
FAX:        (203)-985-7030
-----------------------------------------------------------------------

Jay Jacob Wind <JWJ@EPAIBM.RTPNC.EPA.GOV> <"Mr. Map" to those who
admire his SUGI papers> asked if anyone had success in generating
a graphic stream file with SAS/GRAPH for use with a fax modem.
I infer that a solution that does not requirer a scanner is desired.
Two solutions may be worth a try, depending on what is available:

6.04 MS-DOS:  Head out to your favorite local software shop (in my case,
my brother-in-law's mail-order business) and obtain a copy of HiJaak or
HiJaak for Windows.  For more information about HiJaak, contact:

Inset Systems
71 Commerce Drive
Brookfield, CT  06804-3405
(800) 374-6738

HiJaak will convert several of the graphic file formats produced by SAS
into formats that are accepted by fax boards.

6.08 Windows:  I haven't tested my beta copy yet but I was told at SUGI
by our friends from Cary that the Windows release was to work with standard
windows drivers (The experimental releases did not).  If this is true, then
head out to your favorite software shop and obtain WinFax Pro or a similar
Windows fax software package that works with your fax modem.  Then all you
have to do is use the Windows control panel to selected the WinFax and a
COM port as your printer to send your fax.

Warning:  Test out your solution by sending the image to a nearby fax
machine first!  Images that look sharp on the screen often fax miserably.
Use sans serif typefaces and keep the image simple and black and white.
From: shoe@world.std.com (Jack N Shoemaker)
Subject: Re: Environmental Rounding Logic
Organization: The World Public Access UNIX, Brookline, MA
Date: Wed, 14 Oct 1992 18:10:13 GMT

Mark,

I haven't fully tested this, but I think this code fragment will set you
in the right direction:

intpart = scan(num,1,'.');
frac = trim(scan(num,2,'.'));
fraclen = length(frac);
i = 2;
do until (substr(frac,i,1) * substr(frac,(i-1),1));
  i + 1;
  if i >= fraclen then goto jump;
end;
jump:
modnum = trim(intpart)||'.'||substr(frac,1,i);

Good luck and happy SASing! - Jack
-- 
Jack Shoemaker
Real Decisions Corporation    Voice: 203-656-1500
Darien, CT  06820          InterNet: shoe@world.std.com

Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sas-l
Date:         Wed, 7 Oct 1992 12:43:57 PST
Reply-To:     Thomas M Skinner <Thomas_M_Skinner@CCM.HF.INTEL.COM>
From:         Thomas M Skinner <Thomas_M_Skinner@CCM.HF.INTEL.COM>
Subject:      Re: SAS/Windows or SAS/OS2 or SAS/DOS working with MicroSoft
Comments: To: Bert_Cave@ccm.hf.intel.com, Ski_Taniguchi@ccm.hf.intel.com,
              SAS-L@uga.cc.uga.edu

Rich La Valley writes:

>We are currently investigating the use of SAS/Windows and have a lot of data
>currently residing in MicroSoft SQL Server.  I am sure someone in SAS-L has
>encountered this and would like to get some input and experiences in this
>-area.
>I know that SI is currently evaluating this but I am hoping others have tried
>and can let me know what we are going to encounter.  I suspect that there are
>some
>workarounds that have been devised and hopefully some of you will be willing
>-to
>share your ideas.

>Please respond back and if you want to talk directly call me at (214) 918 -
>5870.
>Rich La Valley - MCI

     Rich,

     We have been working on a project with SI, Microsoft, Sybase, and
     others to develop a SAS/ACCESS product specific to this need.  SI has
     assigned a fulltime person to this task, and we expect to see a test
     product sometime early next year.

     Bert Cave, our SAS Product Manager has been testing SAS 6.08 for
     windows for some time now, and we have recently received the Beta
     release.  Bert has been able to access SQL Server data via Q+E, but
     the procedure is very cumbersome.  I'd suggest contacting him directly
     to get his views on this endeavor.  We certainly would like to hear
     about any others who are pursuing this track.

     Bert's internet address is Bert_Cave@ccm.hf.intel.com

     Intel-Insider,

     Tom Skinner


     ======================================================================
     T.M. Skinner               Internet:Thomas_M_Skinner@ccm.hf.intel.com
     Sr. SAS Tech. Support      Mail: c/o Intel Corporation
     Intel Corporation                1900 Prairie City Road MS FM1-102
                                      Folsom, CA 95630
     ======================================================================
From: 0005400191@MCIMAIL.COM (Willy Waks)
Newsgroups: bit.listserv.sas-l
Subject: SI Pmenu Source Code
Date: 15 Oct 92 21:50:00 GMT
Reply-To: Willy Waks <0005400191@MCIMAIL.COM>
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Comments: To: SAS-L <SAS-L@tcsvm.bitnet>

Does anyone knows if the source code for the default Pmenus is
available somewhere. I'd like to make a copy and edit them for my
applications, rather than create new ones from scratch.
Incidentally, the platform I nned it most urgently is 6.07 under MVS,
but I may use the same for 6.06/OS2  or 6.08/Windows.
Thanks
        <<Errare humanum est... sed perseverare diabolicum !>>
Willy Waks
2W Systems Co., Inc 5430 Alpha Road Suite 200 Dallas TX 75240
Tel: 214-6618619 Fax: 214-6610130
Email: wwaks@mcimail.com     73437.344@Compuserve.com
From: G9W5D7@IRISHMVS.BITNET (kevin brunson)
Newsgroups: bit.listserv.sas-l
Subject: Proc datasource
Date: 16 Oct 92 16:46:00 GMT
Reply-To: kevin brunson <G9W5D7@IRISHMVS.BITNET>
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU

Looking for help on Proc Datasource...
      [1]  Are company names on Compustat CSAIBM??
       2.  How do I restrict the records being read to just
           certain years or certain variables?   My goal is
           to reduce the amount of time taken to read Cstat.  I
           have no problems once the files are in a SAS dataset
           but it can often take as much as 3 hours just to read
           Cstat into an output dataset!

  Braves in 6!!!!

  Kevin Brunson
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Encoding: 6 TEXT
X-Mailer: Microsoft Mail V3.0 (beta-2)
Newsgroups: bit.listserv.sas-l
Date:         Wed, 7 Oct 1992 09:26:00 EST
Reply-To:     sas@NIORDS1.EM.CDC.GOV
From:         sas@NIORDS1.EM.CDC.GOV
Subject:      distribution curve
Comments: To: sas-l@awiimc12.imc.univie.ac.at

I have an n=797 frequency distribution I would like to graph to see what the
values look like graphically.  Is there an EASY way to do this in SAS?

Brian Day
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU