HDTenEightyP/NetNews huggingface dataset:
Organization: Southern Methodist University
Newsgroups: bit.listserv.sas-l
Date:         Tue, 26 Jan 1993 13:32:18 CST
Reply-To:     UDCW@SMUVM1.BITNET
From:         UDCW@SMUVM1.BITNET
Subject:      COMMA DELIMITED ASCII FILES (the solution)

Several people have helped me find a solution to my earlier posting.
I would like to thank each of them; they are:

   Howard Schreier, Derek Morgan, Joe St Sauver, and Kernon Gibes

Here is my earlier post:

> I have an ASCII file that is delimited by commas and quotation marks(").
> Numeric and character variables are both separated by commas except
> when a character variable contains commas then the entire text string
> is enclosed in quotation marks.  For example,
>
> 12,54,67,"Welch,David",34,3,the big dog
>
> Is there an easy way to read a file like this in SAS?  There are an
> equal number of variables on each record and all variables are
> ordered, but they are not fixed width.
>

The following program reads the file:


filename data 'comma data a';

data one;
  INFILE data DSD;
  INPUT A B C D  & $char30.  E F G & $char30.;

Thanks again for the help.  BTW, this option (DSD) is documented in
Tech Report P-222 page 30 and is for version 6.07.

Sincerely,
David Welch
Senior Systems Analyst
Southern Methodist University                            UDCW @ vm.cis.smu.edu
(214) 692-2036                                         dwelch @ sun.cis.smu.edu
Newsgroups: bit.listserv.sas-l
From: crajan@nyx.cs.du.edu (Chella Rajan)
Subject: Median Polish
Organization: University of Denver, Dept. of Math & Comp. Sci.
Date: Fri, 22 Jan 93 23:50:16 GMT


I recently came upon median polish as a technique for smoothing 
counts data in spatial datasets.  I'd like to get some more
information on the procedure and find out if there are
any public macros for executing it.  Appreciate any help
in this direction.
Chella Rajan
crajan@nyx.cs.du.edu

Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Date-warning: Date header was inserted by asu.edu
Content-transfer-encoding: 7BIT
Resent-Subject: Does SAS have anything to do power analysis?
Newsgroups: bit.listserv.sas-l
Date:         Thu, 28 Jan 1993 15:04:26 -0700
Reply-To:     Doug Berry <KGDEB@ASUACAD.BITNET>
Comments:     Resent-From: Doug Berry <KGDEB@ASUACAD.BITNET>
Comments:     Originally-From: KGDEB@ASUACAD.BITNET
From:         Doug Berry <KGDEB@ASUACAD.BITNET>
Subject:      Does SAS have anything to do power analysis?

A faculty member here asks the following question, does anyone have
an answer?  FYI, we have SAS on both CMS and MVS, v. 6.07.  We also have
the 6.08 beta for both Windows and OS/2 but those aren't in wide use.
Thanks for any assistance.

-------------------------------------
Doug Berry   Arizona State University
Tempe, Arizona  85287-0101  USA
Bitnet: KGDEB@ASUACAD
Internet: Doug.Berry@asu.edu

----------------------------Original message----------------------------
Does SAS have anything that does a power analysis now?  So I
could put in the group size, alpha level, and noncentrality
parameter and SAS gives the power?
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Posted-Date: Tue, 26 Jan 1993 20:17:50 -0500 (EST)
Mime-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
Newsgroups: bit.listserv.sas-l
Date:         Tue, 26 Jan 1993 20:17:50 -0500
Reply-To:     Arpad Vincent Toth <tothav@CUMC.CORNELL.EDU>
From:         Arpad Vincent Toth <tothav@CUMC.CORNELL.EDU>
Subject:      PROC CATMOD on PC 6.03

        I'm new to the group and my first question is to anyone who has
experience using this PROC to look at categorical data.  My example is
from Fienberg, ...Cross-Classified Cat. Data...Table 6.1
My code:
data seed; input type $ treatmnt $ outcome $ numcell @; cards;
t1 h d 41
t1 h za 59
t1 l d 11                            /*t1=long leaf/ t2=slash*/
t1 l za 89                           /*treatmnt h=high l=low*/
t2 h d 12                            /*outcome d=dead za=alive*/
t2 h za 88
[Bt2 l d 5
t2 l za 95;
proc catmod data=seed;
weight numcell;
model type * treatmnt * outcome=_response_/nogls noparm noresponse;
loglin type|treatmnt|outcome @2; run;

SAS/STAT User's Guide (REL 6.03) gives examples but doesn't explain
it very well.  Any suggestions?  I'm particularly interested in the
log linear model, looking at different interactions.  The chi square
gives me a start but I want to look deeper into the data.

Thanks in advance for any tips/suggestions.
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 13:50:00 CST
Reply-To:     IMAD.GHANDOUR@MAIL.ADMIN.WISC.EDU
From:         IMAD.GHANDOUR@MAIL.ADMIN.WISC.EDU
Subject:      Subscribe
Comments: To: sas-l@ohstvma.acs.ohio-state.edu

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

SUB SAS-L IMAD GHANDOUR
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Return-Path: <@OHSTVMA.ACS.OHIO-STATE.EDU:SAS-L@VTVM2.BITNET>
X-Envelope-to: SAS-L@AWIIMC12.BITNET
X-VMS-To: IN%"SAS-L@AWIIMC12"
Newsgroups: bit.listserv.sas-l
Date:         Thu, 21 Jan 1993 16:39:00 +0100
Reply-To:     "Wilbert Houweling,
              vakgroep Alg. Agr. Economie" <HOUWELING@RCL.WAU.NL>
From:         "Wilbert Houweling,
              vakgroep Alg. Agr. Economie" <HOUWELING@RCL.WAU.NL>
Subject:      Proc Model and restrictions on parameters

I'm using the SAS/ETS MODEL procedure and want to restrict some parameters. In v
   ersion 5 the procedure SYSNLYN had the possibility of using RESTRICT a1+
b1=1; or something like that. But the version 6 manual says nothing about
that at all. Who can me te

ll me if this is possible or do I need to use
the SYSNLIN procedure?

Wilbert Houweling,
Wageningen Agricultural University
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 15:37:00 EST
Reply-To:     Carol Bristow <CEB@NCCIBM1.BITNET>
From:         Carol Bristow <CEB@NCCIBM1.BITNET>
Subject:      SAS-specific debugging hints

In an effort to supplement the training of inexperienced SAS users/
programmers, we are looking to put together a list of hints, tips,
utilities, etc., that can be used to debug SAS programs.  For example,
if you get a message that a variable is uninitialized, chances are
that you mispelled the variable name, or else dropped or neglected to
keep the variable in a previous step.  The version 5 SAS Guide to
Problem Solving and Error Messages contains some of this kind of
information, but has not yet been updated for version 6.

I am hoping that someone out there may have put together something
of this sort for their own installation, and would be willing to
share it.  If so, I would greatly appreciate it, as I don't have a lot
of time to do it myself.  Responses can be sent via one of the
mechanisms listed below.

TIA!

Carol Bristow

Mail:      DPRA Incorporated
           1300 North 17th Street, Suite 950
           Rosslyn, VA 22209
Voice:     (703) 841-8025
Fax:       (703) 524-9415
Bitnet:    CEB@NCCIBM1.BITNET
Internet:  CEB@EPAIBM.RTPNC.EPA.GOV
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sas-l
Date:         Mon, 25 Jan 1993 14:01:00 EST
Reply-To:     Michael Davis <75046.1627@COMPUSERVE.COM>
From:         Michael Davis <75046.1627@COMPUSERVE.COM>
Subject: Re: HPGL and HP LJ IIIP
Comments: To: "List SAS-L," <SAS-L@uga.cc.uga.edu>

-----------------------------------------------------------------------
CONTENT:    Re: HPGL driver for Release 6.04 and HP LJ IIIP
SUMMARY:    The things SI Tech Support didn't tell you
REL/PLTF:   6.04/MS-DOS
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
-----------------------------------------------------------------------
Jim Goes <goes@chimera.sph.umn.edu> asked if anyone had gotten a
SAS HPGL driver to work successfully with the HP LJ IIIP.

I haven't worked this issue recently but the following information
may help Jim and my other SAS-L colleagues:

1.  The HP LJ IIIP cannot be set to HPGL via the front panel
    operator codes.  The switch has to be made by software.

2.  Call HP Tech Support at (206) 323-2551.  At the end of an
    appropriate conversation, the friendly person at the other
    end of the line will send you a disk containing a short
    program that switches the HP LJ IIIP between HPGL and PCL5
    for free.  The program is part of a demo disk for a
    non-HP commercial software product.

3.  You can not cheat on memory in printerland.  If you want to
    print a full page of HPGL graphics, you will need to invest
    $$$ in a memory board for your HP IIIP to take it past 1 MB.

    Pacific Data Products makes good boards.  If you are suffering
    from the disease "Fundazlo" (funds are low), a 2 MB Elite brand
    memory board, upgradable to 4 MB, is available from the Publisher's
    Toolbox in Middletown, WI (800-233-3898) for the low side of $100.

4.  I vaguely remember something about having to set page protect
    on your printer.  Ask the HP folks about this when you call.

5.  The HP LJ IIIP supports an emulation of HPGL called HPGL/2.
    My recollection is that HPGL/2 is compatible with the HP 7470
    HP 7475 drivers but not the HP 7550 drivers.  Nor does this
    driver emulate multiple pens for obvious reasons.

6.  Don't have a HP III or HP IIIP driver but want to print in
    HPGL?  Pacific Data Products makes a product called
    "Plotter in a Cartridge" which brings this capability to
    earlier model HP LaserJet printers.

Summary:  The HPGL drivers will print much faster but the
appearance of graphics created by the PCL drivers is often
better.
From: rsnyder@LOBBY.TI.COM (R. Snyder)
Newsgroups: bit.listserv.sas-l
Subject: Re: advise needed for sas on SparClassic
Date: 21 Jan 93 15:58:02 GMT
Reply-To: "R. Snyder" <rsnyder@LOBBY.TI.COM>
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
X-Mailer: ELM [version 2.2 PL16]
Comments: To: dhouston@bio.ri.ccf.org
Comments: cc: sas-l@uga.cc.uga.edu
              20, 93 1:26 pm

SUBJECT:   X Windows on a PC
SUMMARY:   HCL gives excellent results
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

Dale Houston Says:
>
> X-Windows on a PC tends to be pretty slow, although a fast PC
> w/accelerated graphics might do the trick. I've  used X under TCP/IP
> for OS/2 on a slowish PS/2. It was too slow for me to recommend,
> although I wouldn't recommend running Os/2 on that PC either.
>
I use HCL's X Windows emulation product on a 486 (EISA) with no special
graphics equipment and obtain excellent results. The speed limiter is LAN
speed, not the PC.

Regards,
Bob
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sas-l
Date:         Tue, 26 Jan 1993 22:54:09 EST
Reply-To:     Anne Liang <GOVE036@TWNMOE10.BITNET>
From:         Anne Liang <GOVE036@TWNMOE10.BITNET>
Subject:      How to apply ZAP

Hi,

I heard SAS release 6.07 on MVS is suffering from Boolean expressions
not being evaluated correctly, which may be corrected by applying ZAP
referenced by Z6075800.  But I don't see how, would you please inform
me about this?   Thanks in advance.

Anne Liang
From: christa@popp.ins.de (Christa Keil)
Newsgroups: bit.listserv.sas-l
Subject: SAS already running under LINUX or 386BSD?
Date: 24 Jan 1993 09:17:57 +0100
Organization: INS - Inter Networking Systems
NNTP-Posting-Host: popp.ins.de

Hallo,

is it already possible to use under LINUX or 386BSD SAS ?

If not so, when will it be possible? :-)

Christa
-- 
christa@germany.uucp                                      zotty@guug.de
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Return-Path: <@OHSTVMA.ACS.OHIO-STATE.EDU:phil@wubios.wustl.edu>
Return-Path: <phil@wubios>
X-Mailer: ELM [version 2.4 PL20A]
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Content-Length: 734
Newsgroups: bit.listserv.sas-l
Date:         Fri, 22 Jan 1993 07:30:08 -0600
Reply-To:     "J. Philip Miller" <phil@WUBIOS.WUSTL.EDU>
From:         "J. Philip Miller" <phil@WUBIOS.WUSTL.EDU>
Subject:      Job Opening
Comments: To: SAS Mailing List <SAS-L@ohstvma.ircc.ohio-state.edu>,
          Data Managment for CT list <datamgt@ctrg.rri.uwo.ca>

The Division of Biostatistics is again seeking to recruit a Statistical Data
Analyst to join the Division's staff in supporting multicenter clinical
trials and epidemiologic studies and multidisciplinary clinical studies in
the School of Medicine.

Candidates should have strong SAS programming skills, particularly in the
use of FSEDIT & AF SCL.  Data analysis skills also required, and experience
with medical research is a plus.  Most computing is in Unix or OS/2.

Please submit your resume via e-mail, FAX or mail.

-phil

----

     J. Philip Miller, Professor, Division of Biostatistics, Box 8067
         Washington University Medical School, St. Louis MO 63110
     phil@wubios.WUstl.edu - Internet  (314) 362-3617 [362-2694(FAX)]
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Return-Path: <@OHSTVMA.ACS.OHIO-STATE.EDU:SAS-L@VTVM2.BITNET>
Newsgroups: bit.listserv.sas-l
Date:         Mon, 25 Jan 1993 16:03:23 EST
Reply-To:     "Gullapalli, Prasad" <KN27@MARISTB.BITNET>
From:         "Gullapalli, Prasad" <KN27@MARISTB.BITNET>
Subject:      subscription request

Hi,

    I am prasad, grad student in comp science department in
MARIST COLLEGE. I am very much interested in subscribing to your
group because of my research interests in this field.

Thank You.

PRASAD.
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Return-Path: <@OHSTVMA.ACS.OHIO-STATE.EDU:SAS-L@VTVM2.BITNET>
X-VMS-To: INTERNET::"SAS-L@VTVM2.BITNET"
X-VMS-Cc: RTIHCG
MIME-version: 1.0
Content-type: TEXT/PLAIN; CHARSET=US-ASCII
Content-transfer-encoding: 7BIT
Newsgroups: bit.listserv.sas-l
Date:         Thu, 28 Jan 1993 11:43:11 -0500
Reply-To:     "Harlene C. Gogan - Go Bills,
              Beat the Cowpies" <RTIHCG@RTI.BITNET>
From:         "Harlene C. Gogan - Go Bills,
              Beat the Cowpies" <RTIHCG@RTI.BITNET>
Subject:      SAS code from Observations

---------------------------------------------------------------------------
CONTENT: Follow-up on availability of Observations program code
SUMMARY: SAS Tech will make avilable if you ask nicely
REL/PLTF: Irrelevant
E-ADDR:   RTIHCG@RCC.RTI.ORG
NAME:     Harlene C. Gogan
PH/ADDR:  Center for Policy Studies, RTI, PO12194, RTP,NC 27709
          (919) 541-6565
---------------------------------------------------------------------------

In article <199301270357.AA01339@lamb.sas.com>,
 richardh@EPISUN.EPIDEM.UWA.EDU.AU (Richard Hockey) writes:
>Are code for the SAS programs listed in Observations available from a ftp site
>anywhere?  I tried ftp.sas.com (the obvious choice) with no luck.
>
>
>| Richard Hockey                    email:richardh@episun.epidem.uwa.edu.au   |
>| Department of Public Health       phone:+61 9 389-3463        _--_|\        |
>| University of Western Australia   fax:  +61 9 389-3648       /      \       |
>| NEDLANDS WA 6009                                             *_.--._/       |
>| Australia                                                          v        |

I was talking with the people at SI about this and they said that they
do not make the code available through FTP unless they get a specific
request for it.  One way of requesting code is to call SI Tech Support,
and they can send specific programs to you.  If you can't call, you can
send EMAIL to the OBSERVATIONS editor at SASOBS@UNX.SAS.COM, let them
know what programs you are interested in, and they can either EMAIL them
to you or they will make it available through FTP.

Use the knowlege wisely!
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sas-l
Date:         Mon, 25 Jan 1993 14:28:46 EST
Reply-To:     Mike Zdeb <MSZ03@ALBNYDH2.BITNET>
From:         Mike Zdeb <MSZ03@ALBNYDH2.BITNET>
Subject:      SAS/GRAPH HPGL -> LASER JET

Instead of a hardware solution (either built-in or a cartridge), I have
been using a piece of software called Laser Plotter to get HPGL out
of a Laser Jet II.  The advantage that I found with Laser Plotter is that
it allows you to map the HPGL color selection to gray scales, giving
nice looking gray-scale fills on polygons.  Also, with a PC with a very fast
CPU, the bitmap conversion from HPGL is quick (and in the background
if you are using Windows, etc.).
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Return-Path: <@OHSTVMA.ACS.OHIO-STATE.EDU:SAS-L@VTVM2.BITNET>
Newsgroups: bit.listserv.sas-l
Date:         Mon, 25 Jan 1993 15:47:52 EST
Reply-To:     "Gullapalli, Prasad" <KN27@MARISTB.BITNET>
From:         "Gullapalli, Prasad" <KN27@MARISTB.BITNET>
Subject:      subscription request

Hi,

   I am prasad, grad student in comp science department specializing
in software development. I am very much interested to subscribe to
your discussion because of my research interests in this field.

Thank You,

PRASAD.
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:CALC0N@UNI-BOCCONI.IT>
Organization: Univ. BOCCONI, Milano, Italy (node IMIBOCCO on EARN/BITNET)
Newsgroups: bit.listserv.sas-l
Date:         Thu, 28 Jan 1993 16:58:00 SET
Reply-To:     "Dr. Flavio ADDOLORATO" <CALC0N@UNI-BOCCONI.IT>
From:         "Dr. Flavio ADDOLORATO" <CALC0N@UNI-BOCCONI.IT>
Subject:      PHASE-AVERAGE TREND METHOD

I would like to know if there is any PC software that measures the
cyclical behaviour of a time series (typically, GDP or industrial
production) using the PAT method.

The PHASE-AVERAGE TREND METHOD was developed by the United States
National Bureau of Economic Research and estimates the trend,
the cycle-trend and the ratio to trend of a time series.
This is a flexible method in which the period over which the trend
is estimated varies according to the duration of the cycles observed
in the data.

The PAT method is currently used by OECD in many its publications,
i.e. the Economic Outlook.

Thank you in advance, any help will be appreciated.

                           Flavio
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Return-Path: <@OHSTVMA.ACS.OHIO-STATE.EDU:SAS-L@VTVM2.BITNET>
X-Envelope-to: sas-l@ualtavm.BITNET
Content-transfer-encoding: 7BIT
Newsgroups: bit.listserv.sas-l
Date:         Thu, 28 Jan 1993 17:08:32 -0500
Reply-To:     Anami Bhargava <bhargava@OFFSV1.CIS.MCMASTER.CA>
From:         Anami Bhargava <bhargava@OFFSV1.CIS.MCMASTER.CA>
Subject:      status of sas software for SunOS platform

I installed SAS 6.07 around February last year on one of our Sparc2 Sun
server.  The log files of sas runs indicate 6.07 at TS203. I am just
wondering if it has been upgraded since then and how to upgrade it to the
current level ? Is any upgraded version is coming soon for this platform ?
I will be installing it on another server. Any information is appreciated.


-anami
=========================================================================
Anami Bhargava                           bhargava@mcmail.cis.mcmaster.ca
Application Software Specialist          TEL (416) 525-9140 Ext. 4162
Computing Information Services           FAX (416) 527-0100
McMaster University, KTH-328                 (416) 528-3773
1280 Main Street West, Hamilton,
Canada, L8S 4M4
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sas-l
Date:         Tue, 26 Jan 1993 10:02:26 CST
Reply-To:     sparapan@SALT.RA.ANL.GOV
From:         sparapan@SALT.RA.ANL.GOV
Subject:      System Time Mystery Solved(by SI)
Comments: To: sas-l@uga.cc.uga.edu

SAS-L:

For those of you who have been anxiously waiting on the edge of your
seats for this solution, here it is.  An informat statement by
default(apparently) does not trim leading blanks and therefore
the spacing of most ascii-delimited files will create inaccuracies
when read.  The way to get around this is to use the colon
modifier in an input statement.  i.e.
"input sysdate mmddyy8. systime:time8.;"
The main assumption appears to be that files that are in an informat
mode are not delimited and are in fixed(as opposed to free) format.

Rodney
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sas-l
Date:         Thu, 21 Jan 1993 13:52:18 EST
Reply-To:     Howard Schreier <HIS@NIHCU.BITNET>
From:         Howard Schreier <HIS@NIHCU.BITNET>
Subject: Re: Variable number of records

CONTENT:  FM Reference
SUMMARY:  Usage *2* covers handling multiline observations

> Can someone give me a point or two on how to set up a SAS program to
> read a raw data file which has observations that span a variable
> number of records? I can see that the # line pointer symbol for the
> input statement would help, but it seems to want a fixed number of
> records per observation. I have been experimenting was a SAS program
> to read this data file, but nothing I have tried seems to work
> properly. By the way, the first record of each observation consists of
> just information about the observation such as ID number and the
> unique form number. I also put a record after each observation to
> signal the end of the observation, but I can't seem to get things to
> work. SAS keeps insisting that each record is a separate observation.
> Any help you can provide will be appreciated.

See SAS Language and Procedures Usage *2* (V.6 1st edition), pp. 31-35.

/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\
\   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
Subject: (no subject given)
Newsgroups: bit.listserv.sas-l
Date:         Wed, 27 Jan 1993 08:45:54 -0500
Reply-To:     RRMAIL@NUACVM.BITNET
From:         RRMAIL@NUACVM.BITNET
Comments: To: sas-l@uga.bitnet

dear sas-lers:
I have a data manipulation question.  I have a variable, call it 'x' for
several firms for 20 years.  I am interested in finding out if 'x'
increased consistently from one time period to the next (i.e., x
at time 't' is greater than x at time 't-1' and so on).  Note that
'x'can take negative values.  I would like to be able to output the names
of the firms, the number of firms for which 'x' increased every year during
the 20 years in the data set.  If 'x' increased only during 10 years in the
20 year-period, I would like to be able to output the name of such firms,
the time period in the 20 year span during which 'x' increased consistently.
Currently the data set is arranged such that 'year' is variable with 20
observations one for each year. Similarly, 'x' is a variable with 20
observations one for each year.
I could try transposing the data set such that each of the  x's becomes
a variable.  Since I have a large number of firms, I am not sure if this
is efficient.  Any suggestions will help. thanks.

We use IBM 4381 and SAS version 5.18.
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Organization: Southern Methodist University
Newsgroups: bit.listserv.sas-l
Date:         Thu, 21 Jan 1993 09:58:27 CST
Reply-To:     UDCW@SMUVM1.BITNET
From:         UDCW@SMUVM1.BITNET
Subject:      COMPUSTAT DATA

  This is not a SAS question but, it is a problem that I've been having
lately.  This problem is with the COMPUSTA database.  If you have
COMPUSTA availible at your site, how do your users access the informa-
tion?  We are running on a IBM VM/XA system and are moving to a UNIX
environment; therefore, I am interested in responses from people on
both platforms.

  Presently, I read the tapes in SAS and write the data to permanent
SAS datasets on tape and the users use a MACRO to access the data.

  Please respond to me directly and I apologize for not asking a
question directly dealing with SAS.

Thanks in advance,
David Welch
Senior Systems Analyst
Southern Methodist University                            UDCW @ vm.cis.smu.edu
(214) 692-2036                                         dwelch @ sun.cis.smu.edu