HDTenEightyP/NetNews huggingface dataset:
Original_To:  BITNET%"sas-l@uga"
Original_cc:  CHENX
Newsgroups: bit.listserv.sas-l
Date:         Wed, 12 Aug 1992 15:26:00 EDT
Reply-To:     Chen Xi <CHENX@CUA.BITNET>
From:         Chen Xi <CHENX@CUA.BITNET>
Subject:      Thank you, How to read V5 Transport File

Dear Netter:

I posted a question yesterday asking how to read SAS V5 Transport File, and I
received a number of the responses.  Thank you all for your kind suggestions,
my problem has been solved.  (I am sorry that I will not post names who
responded to me, since it is a long list.)

For the all who are interested in the topic, I will post the answer to the
group.  I do not know what will be the correct interpretation, but it works.

My question was that some one saved a dataset into a unlabled tape from a
IBM/CMS machine running SAS 5.18, and it is claimed that the data is in
transport format, and the command he used was

        libname out sasv5xpt;
        proc copy in=in out=out;

I would like to read the dataset on a VAX/VMS machine running SAS 6.06.

At first, since it was a unlabled tape, I have to copy the transport file from
tape to disk.  (See SAS companion for VMS, pg 140.)   The file is biggie,
30,000 blocks,  I restored it into a scratch area named DISK$SCRATCH_:[CHENX],
and the file name is GALL.SASPORT.

The following is the complete SAS program running on VAX/VMS:

        options ls=80;
        libname inp xport 'disk$scratch_:[chenx]gall.sasport';
        libname outp 'disk$scratch_:[chenx]';
        proc copy in=inp out=outp;
        proc contents;

The program read GALL.SASPORT, transform it, and write it into a SAS data file
(which is named GALL.SASEB$something, I do not remember.)  Proc Contents
procedure made me sure that all the data has been correctly transformed, and it
showed to me that the data is in V606 format.

Onething I am not clear is that we supposed to use two engines, one for
the transformation from transport file into the SAS file, and the other for
the conversion from V5 to V6.  But, it seems to me that we
do not need the version conversion engine anymore.  One possibility is that the
transport file format is same for V5 and V6, there might be others.  I am not
sure if it has not been documented somewhere in the manuals, but SAS manual is
just like an Encyclopedia.  Besides, there are a lot of things in SAS Technical
Report.

Finally, thank you again for all who tried to answer my questions.


Chen Xi
User Consultant
The Catholic University of America
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Posted-Date:     21 Aug 92 07:27:29 EDT
X-Mailer: Pegasus Mail v2.1b.
X-Pmrqc:  1
Newsgroups: bit.listserv.sas-l
Date:         Fri, 21 Aug 1992 07:27:29 EDT
Reply-To:     Jay Bragg <JBRAGG@CALS1.CALS.NCSU.EDU>
From:         Jay Bragg <JBRAGG@CALS1.CALS.NCSU.EDU>
Subject:      SAS Under Unix on Intel Platform

CONTENT:  Question
SUMMARY:  SAS under UNIX for Intel Platform
E-ADDR:   jbragg@cals1.cals.ncsu.edu
NAME:     Jay Bragg
ADDR:     NC State Univ, Raleigh NC USA

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

   /jay bragg/
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sas-l
Date:         Fri, 14 Aug 1992 18:26:00 GMT
Reply-To:     Willy Waks <0005400191@MCIMAIL.COM>
From:         Willy Waks <0005400191@MCIMAIL.COM>
Subject:      PMENU and SCL /MVS - 6.07

I've created my own PMENU, and I would like to have them in effect accross an
entire application. In 6.06 under OS2, I can start my application with
DM 'PMENU ON; SET PMENU=MYLIB.MYCAT.MYMENU';
In 6.07 under MVS, the DM 'SET ...' is interpreted as SETINIT and opens the
SETINIT window, which is the last thing you want to do to a user.
I know of RC=PMENU('MYLIB.MYCAT.MYMENU'), but it seems that I need to repeat
that for every screen, as opposed to make it the default for the entire
application. Any clue ? Thanks
Willy Waks, 2W Systems Co., Inc. Dallas TX
PS: I've also got a logo:
Errare humanum est... sed perseverare diabolicum !
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sas-l
Date:         Thu, 13 Aug 1992 09:38:21 PDT
Reply-To:     Claire Castell <Claire.Castell@EBAY.SUN.COM>
From:         Claire Castell <Claire.Castell@EBAY.SUN.COM>
Subject:      SAS-L Sign-offs
Comments: To: SAS-L@OHSTVMA.IRCC.OHIO-STATE.EDU

I'm back on the list after some automatic deletion and then it took me a few
weeks to miss it ..

I published my collection of your "sign-offs" in the BASAS newsletter,which I've
been collecting since I started here.  I thought you might enjoy having this
list and many of you will recognize your own.  Sorry, I didn't keep track of
who said what.
Claire Castell
		Bay Area SAS Users Group Newletter

SAS-L is the SAS Discussion "bulletin board" available on Bitnet and
Internet to which I've subscribed for 3 years.  Many contributors sign
the email with  standard signature files which often contain very clever
quotes and sayings.  I've taken to collecting my favorites and thought
you might enjoy them too.                           .... Claire

"Reality is still the best place to get a good steak."   --Woody Allen

Californians are not without their faults.

"All SAS Programming is Prone to Suffering; All SAS Datasets are Dynamic ;
 Data Never Sleeps"   -- The Tao of SAS

"Veni, Vedi, Visa" "I came, I saw, I did a little shopping."
         (my personal favorite)

Words pick up flavors and odors like butter in the refrigerator.
              -- John Steinbeck

"Too much of a good thing is  WONDERFUL!" Mae West

When marriage is outlawed, only outlaws will have in-laws.

"Quandoque dormitat bonus Homerus"   "Sometimes even Homer sleeps"

Live every day like your hair is on fire.      --Zen Proverb

"Fanaticism consists in redoubling your efforts  when you have
forgotten your aim."    - Santayana

'We're real when someone loves us' - from the Velveteen Rabbit

"We're only really real when someone humiliates us"
 The Terry-cloth Mummies

Optimist: one who thinks he'll breakup a traffic jam by tooting his horn.

Does the name Pavlov ring a bell?

Yield to temptation today, it may not pass your way in a long time.

No  amount of  genius can overcome a pre-occupation with details.

"Cogito ergo erratum" I think, therefore I am wrong."

Never blame on malice that which can be fully explained by stupidity.
-- Hanlon

"Beauty is in the eye of the beholder, or at the very least the
System Design Committee"

Yes, I did change my mind.  But at least I kept the original!

"Outside of a dog, a book is a man's best friend.  Inside a dog,
it's too dark to read." -- Groucho Marx

Ballo ergo sum (I dance therefore I am) -des Cartwright

DISCLAIMER:  If you believe this message is offensive, illegal, immoral,
or otherwise politically incorrect, then you probably get my drift.

Never cheat on a woman, they hate that.
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
X-Envelope-to: sas-l@OHSTVMA.BITNET
X-VMS-To: IN%"DALMAS@NIEHS.BITNET"
X-VMS-Cc: BITNET%"sas-l@ohstvma"
Newsgroups: bit.listserv.sas-l
Date:         Thu, 20 Aug 1992 11:27:00 EDT
Reply-To:     "Robert M. Hamer 908-932-2696" <HAMER@ZODIAC.BITNET>
From:         "Robert M. Hamer 908-932-2696" <HAMER@ZODIAC.BITNET>
Subject:      Re: SAS/AF beginner needs suggestions
Comments: To: DALMAS@NIEHS.BITNET

Dawn Dalmas <DALMAS@NIEHS.BITNET> writes:

>CONTENT:   SAS/AF beginner needs suggestions
>REL/PLTF:  mine is VAX/VMS running SAS v6.06
>E-ADDR:    DALMAS@NIEHS.BITNET
>NAME:      Dawn Dalmas
>DATE:      August 20, 1992

>user-generation of reports, resulting in creation of SAS datasets.  Sounds
>like a job for SAS/AF, right?  But I'm having a little trouble getting started,
>and would appreciate suggestions/comments/advice aimed at my level (SAS
>programmer with no AF or SCL experience).  I have one Fine Manual at my
>fingertips: SAS/AF Usage & Reference, Vs. 6, 1st edition.  The Ch.10 (p.172)
>description of PROC BUILD states ability to "read from and write to SAS data
>sets" yet I'm not clear on just how to do this.  Are there other manuals/books
>you'd recommend with tutorial-type examples?  Is the SI course "SAS/AF Software
>Applications Using Screen Control Language" worth the money?

I took the course a couple of months ago, and in my opinion, it's worth it.
Like most SAS short courses, it is well organized, full of information,
and well taught.  I took it at the Institute training center in Cary.
While one can by no means expect to walk out of the course and write
systems with the ease with which one could had you had a bunch of experience,
if you choose your initial project carefully it will teach you more, and you
will develop the experience needed to write more sophisticated projects.

One remark: You mention use of your systems for data entry and data management.
Although this can be done completely in AF, if you have FSP as well, PROC
FSEDIT will make this much easier.  You can invoke FSEDIT from within an
AF SCL program.  Both FSP and AF use SCL.

I feel, personally, that trying to learn how to do all this, by yourself,
from the manuals alone, is very difficult.  I think the course will help
a lot.  Especially as the manuals are all written under the assumption
that you're on an IBM mainframe, and you are working under VMS.
As VMS users know well, what the IBMers use the function keys for in SAS,
VAX SAS uses the numeric keypad, and the behavior of some of the
interactive screen oriented procedures differ just enough to confuse
in the various environments.
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sas-l
Date:         Wed, 19 Aug 1992 10:33:44 PDT
Reply-To:     annfow <afowler@CCLINK.FHCRC.ORG>
From:         annfow <afowler@CCLINK.FHCRC.ORG>
Subject:      Subsetting data set

          CONTENT:  Question on subsetting a data set
          REL/PLTF: PC SAS v6.04 on DOS
          E-ADDR:   annfow@cclink.fhcrc.org
          NAME:     Ann Fowler
          DATE:     8/20/92

          I was given a data file (ascii) that contains both baseline
          values and 1-yr follow-up values.  Each respondent has
          multiple records of the same variables except for the date.
          The only thing that distinguishes between the baseline
          records and follow-up records is that they are about a year
          apart.  Is there an easy way to separate the baseline data
          from the one year data?  The problem is that there are no
          fixed no. of records for each respondent.  Some have 2
          records at baseline and 4 at follow-up, 4 at baseline and
          none at follow-up, 3 at baseline and 2 at follow-up, etc.
          There is also no specific cut-off date for baseline, ie. the
          dates overlap.  Below is an eg.:

          ID     DATE    VAR1  VAR1  VAR3........
          101    8/10/90  1     2     3
          101    8/11/90  2     2     1
          101    8/12/90  1     1     2
          102    5/1/91   1     1     3
          102    5/3/91   2     3     3
          103    8/5/91   3     3     1
          103    8/7/91   1     1     1
          101    8/4/91   3     3     2
          101    8/5/91   2     2     3
          103    8/1/92   1     1     1
          107    10/1/90  1     2     2
          107    10/3/90  2     3     1
          102    4/29/92  3     2     1
          102    4/30/92  2     2     2
          104    6/23/90  3     3     3
          104    6/24/90  3     1     2
          104    6/26/90  1     2     3

          p/s - I'm not very familiar with macros and I don't use sql.


          Hope I've made my problem clear.  Thanks for any help.
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sas-l
Date:         Wed, 12 Aug 1992 13:40:13 EDT
Reply-To:     Howard Schreier <HIS@NIHCU.BITNET>
From:         Howard Schreier <HIS@NIHCU.BITNET>
Subject: Re: Macro variable naming conventions

CONTENT:  Suggestion
SUMMARY:  Care needed for "regular" names within macros

This  discussion  up  till  now  has   dealt   with   naming
conventions for *macro* variables.

My comment deals with a related but clearly distinct matter:
the  choice  of  regular (non-macro) names for data sets and
DATA step variables created by macro-generated code.

Sometimes  it  is  necessary  for  a  macro  to  create  new
variables  or  data sets on a temporary basis (the variables
get DROPped;  the  data  sets  are  in  the  WORK  library).
Obviously,  it is important to avoid conflicts with existing
objects.  The convention I have sometimes used is  to  begin
these names with a *double* underscore.  For example:

   %macro whatever .  .  .

           *;
      data __temp1;
           *;
      .  .  .

/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\
\   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:         Wed, 12 Aug 1992 08:53:38 CDT
Reply-To:     "PADMANABH M. PADAKI" <X041PP@TAMVM1.BITNET>
From:         "PADMANABH M. PADAKI" <X041PP@TAMVM1.BITNET>
Subject:      Re: PROC TSCSREG
              11 Aug 1992 23:07:59 GMT from <jkatz@WEBER.UCSD.EDU>

On Tue, 11 Aug 1992 23:07:59 GMT Jonathan Katz said:
>I am looking for information regarding the proc TSCSREG. I am trying

If you are running SAS6.07 then you wont' find any documentation
       like Manuals or Tech reports.  Last week, I got a copy of the
       Proc from SI.  Just call SI Tech Support and they will mail
       you Tscsreg documentation.



             Padmanabh M. Padaki             MVS  SAS6.07
               User Services
              Texas A&M University
              College Station, TX 77843- 3142
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sas-l
Date:         Wed, 19 Aug 1992 20:28:00 GMT
Reply-To:     Willy Waks <0005400191@MCIMAIL.COM>
From:         Willy Waks <0005400191@MCIMAIL.COM>
Subject:      Binary Segment Attached

My apologies to those of you on the list who received my messages yesterday with
a unintelligible Binary Segment Attached. This was supposed to be my signature,
but I did not expect Norton Mail to send it separately from the body of the
message and in binary. So please ignore it, and I'' make sure it won't ahppen
again.
Willy Waks, Dallas TX
Errare humanum est, sed perseverare diabolicum !
How pertinent...
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Original_To:  BITNET%"sas-l@uga"
Newsgroups: bit.listserv.sas-l
Date:         Thu, 13 Aug 1992 13:55:00 EDT
Reply-To:     XIC@UTKVX.BITNET
From:         XIC@UTKVX.BITNET
Subject:      Data Conversion, Thank you.

Thank you all for the help to solve my question of the data conversion, my
problem has been solved perfectly.

There are a number of ways to convert a Character variable to a numerical
variable.  Assume that ABC is a character variable, then

        x=input(abc,4.);

converts ABC to a numerical variable whith length 4.  On the other hand,
using SAS default rule

        x=abc*1.0;   or    x=abc+0.0;

will do samething, since by the rule, the result of calculation between
character variable and numerical variabel will be numerical.  SAS tried
to convert the character variable to numerical at first, then do the
calculation.  When the character vairable is not appropriate for the
conversion, for example, abc='Smith-25', ABC will be assigned a missing
value.

Thank you all again for your information.
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Original_To:  BITNET%"sas-l@uga"
Original_cc:  HOGE
Newsgroups: bit.listserv.sas-l
Date:         Fri, 14 Aug 1992 17:06:00 EDT
Reply-To:     HOGE@CUA.BITNET
From:         HOGE@CUA.BITNET
Subject:      compress a file

Hello, Netters,

Thank all those who responded to my earlier questions.

I have another beginner's question (I have not yet completed my task yet):

How can I compress a file to make it smaller.  The default numerical
variable length in SAS DATA FILE is 8, but in my data I just need
1, 2 or some times 4 columns only for a variable.
So the question is:

1: When I convert a character variable into a numerical variable,
how can I control the variable length?

Question 2:  when I import a SPSS SYSTEM FILE and save it as a
SAS DATA FILE, the size increased about three times larger.  When
I save it as a SAS DATA FILE, how can I save it as compressed?

Thank you again for any help.

Fenggang Yang
From: tamara@glia.biostr.washington.edu (tiny t)
Newsgroups: bit.listserv.sas-l
Subject: Re: formchar option
Date: 18 Aug 92 00:11:58 GMT
Organization: Dept Biological Structure-University of Washington

I have successfully used HP PCL HP program language to replace
HP hex codes to insert graphics characters which enhance
tables, etc.

I know of a group of folks who use HP printers and the formchar
replacement characters successfully. There will be some discussion
of other nifty things like this, by Jim Comer at SESUG. He
has a lot of experience in this as well as DSGI Data Step Graphics
Interface. The things he has done have been quite remarkable.

Tamara Fischell
Tamara@glia.biostr.washington.edu
SESUG at St. Petersburg Florida, February 14-16 1993
For more information (919) 933-6404
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
X-Mailer: ELM [version 2.2 PL16]
Newsgroups: bit.listserv.sas-l
Date:         Thu, 13 Aug 1992 09:21:05 CDT
Reply-To:     "R. Snyder" <rsnyder@LOBBY.TI.COM>
From:         "R. Snyder" <rsnyder@LOBBY.TI.COM>
Subject:      Re: SAS/PC 6.04 --> SAS/CMS 6.06
Comments: To: DAN%UMDD.BITNET@uga.cc.uga.edu
Comments: cc: sas-l@uga.cc.uga.edu
              92 4:17 pm

In reply to:
>
> I have been sent a large number of SAS data sets created using SAS/PC
> Version 6.04.  The files will be uploaded onto an IBM mainframe and
> analyzed using Version 6.06 under CMS.  What is the best way to convert
> the SAS data sets so they can be used with Version 6.06?
>
> Dan Jacobs, Ph.D.                 BITNET: DAN@UMDC
> Ecologist/Biometrician
> Maryland Sea Grant College
> University of Maryland           Ben Hay-Hay taught:
> 1115 Taliaferro Building         The reward is proportionate
> College Park, MD  20742          to the suffering.
> (301) 405-6379                              Pirkei Avot V:25
>
Dan,

PROC CPORT and PROC CIMPORT provide a straight forward way of moving the data.
Also, if you are connected via Micro-to-Host Link on the PC and SAS/CONNECT
on the mainframe, you may use PROC UPLOAD.

Hope I helped.

Bob Snyder, Texas Instruments, Sherman, TX
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Encoding: 3 TEXT
X-Mailer: Microsoft Mail V3.0 (beta-2)
Newsgroups: bit.listserv.sas-l
Date:         Wed, 19 Aug 1992 08:30:00 EST
Reply-To:     fri1@CIDHIV1.EM.CDC.GOV
From:         fri1@CIDHIV1.EM.CDC.GOV
Subject:      Documenting SAS Data Sets (220 lines)
Comments: To: SAS-L@AWIIMC12.IMC.UNIVIE.AC.AT

Steve-you left all your concatenation operators as ?/ in your program
example.
From: rcw@TENET.EDU (Richard Wright)
Newsgroups: bit.listserv.sas-l
Subject: Finding SAS libraries on MVS
Date: 20 Aug 92 01:46:19 GMT
Reply-To: Richard Wright <rcw@TENET.EDU>
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
X-Envelope-to: SAS-L@TCSVM.BITNET

CONTENT: Finding SAS libraries on MVS disk packs
SUMMARY:
REL/PLTF:MVS/v6.07
E-ADDR:  RCW@TENET.EDU
NAME:    Richard Wright
DATE:    August 19, 1992

Dear SAS Wizards:

Stand by, this should probably be saved for April Fools day.

We are (slowly) converting to SAS 6.07. We would like to compile a
list of all, version 5.18 through 6.06, SAS data sets so that we can
back up and convert these en masse.

Two approaches come to my mind immediately - one is to examine all OS
data sets for specific attributes (e.g. DSORG = PS or U, RECFM=PS,
and etc). This should give me a list of candidate data sets to be
examined and processed further.

A related question is - are there any identifier bytes in a SAS data
library that mark it as such?

A second approach I am tendering is to examine all "text" files for a
JOB card and then looking for output SAS libraries. This approach has
the advantage of a relatively few number of SAS users and
consequently few user ids.

Has anybody out there in SASland done anything like this or know of
any techniques that might assist me in "rightsizing" this problem?

10 line PROC SQL solutions are especially desirable (grin).

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

Thanks in advance,

       ============================================
      =  RRRRR ------ CCCCC ----- WW          WW =
     = RR     RR  CC        CC - WW          WW =
    = RR    RR - CC       CC  - WW          WW =
   = RRRRRRR -- CC           - WW          WW = Richard Wright
  = RR    RR - CC           - WW    WW    WW = Tx. Leg. Bud. Board
 = RR     RR -- CC    CC --- WW  WW  WW  WW = Internet:rcw@Tenet.edu
= RR     RR ---- CCCCC ------ WWW --- WWW  = Compuserve: 70673,1131
===========================================
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
X-Envelope-to: SAS-L@UGA.BITNET
X-VMS-To: IN%"SAS-L@UGA"
X-VMS-Cc: DALMAS
Newsgroups: bit.listserv.sas-l
Date:         Thu, 20 Aug 1992 10:56:00 EST
Reply-To:     Dawn Dalmas <DALMAS@NIEHS.BITNET>
From:         Dawn Dalmas <DALMAS@NIEHS.BITNET>
Subject:      SAS/AF beginner needs suggestions

CONTENT:   SAS/AF beginner needs suggestions
REL/PLTF:  mine is VAX/VMS running SAS v6.06
E-ADDR:    DALMAS@NIEHS.BITNET
NAME:      Dawn Dalmas
DATE:      August 20, 1992

I'd like to develop SAS/AF applications for data entry which are menu-driven
and user-friendly, featuring data/field value restrictions, help selections,
user-generation of reports, resulting in creation of SAS datasets.  Sounds
like a job for SAS/AF, right?  But I'm having a little trouble getting started,
and would appreciate suggestions/comments/advice aimed at my level (SAS
programmer with no AF or SCL experience).  I have one Fine Manual at my
fingertips: SAS/AF Usage & Reference, Vs. 6, 1st edition.  The Ch.10 (p.172)
description of PROC BUILD states ability to "read from and write to SAS data
sets" yet I'm not clear on just how to do this.  Are there other manuals/books
you'd recommend with tutorial-type examples?  Is the SI course "SAS/AF Software
Applications Using Screen Control Language" worth the money?
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU