You said ... for those that are trying to get the SAS to work without prior
knowledge of the language, the nigglers'll point out that RETAIN DATA
DATARDW; and RETAIN BDW; are missing (actual location is irrelevant)
from the respective DATA steps. It's only a minor thing and doesn't
affect the
At October 7, 2005 12:14, concerning RE: Summarize length of all
variable length recor, Barry Merrill [EMAIL PROTECTED] wrote (to Neil
Duffee):
[snip]
However, it is not necessary to use an explicit RETAIN statement, when
you, instead, use the SUM Statement syntax, which has an implied
At October 6, 2005 01:08, concerning Re: Summarize length of all
variable length records in a file?, Barry Merrill [EMAIL PROTECTED]
main.lst wrote (to IBM-Main):
a. [snip] use DATA _NULL_, SUM statements to accumulate,
and a PUT the sum at the END= of the INFILE:
DATA _NULL_
: Re: Summarize length of all variable length records in a file?
Ted,
Thanks for that, but I guess we all cannot be perfect...
First: L would not be a written variable.
It should be:
DATA LRECL00(KEEP=LEN);
INFILE IN LENGTH=L;
INPUT @ ;
LEN = L ;
True. Total brainfart on my
You're right about the OUTPUT statement, but I haven't worried about it for
years.
SAS since earlier than 1982.
It was the first language I used in the field.
-teD
In God we Trust!
All others bring data!
-- W. Edwards Deming
On Oct 5, 2005, at 7:00 PM, Ted MacNEIL wrote:
You're right about the OUTPUT statement, but I haven't worried about
it for years.
SAS since earlier than 1982.
It was the first language I used in the field.
-teD
Ted:
I thought English was your first language, no?:)
Ed
Hi,
I can write a quick and dirty program to do this but since it is for an
application group a supported utility would be preferred.
Does anyone have code to use SAS, SYNCSORT or some other utility to quickly
summarize the lengths of all the records in a file of variable length
records?
-8260
-Original Message-
From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On
Behalf Of Knutson, Sam
Sent: Wednesday, October 05, 2005 9:17 AM
To: IBM-MAIN@BAMA.UA.EDU
Subject: Summarize length of all variable length records in a file?
Hi,
I can write a quick and dirty program
On Wed, 5 Oct 2005 09:17:03 -0400, Knutson, Sam [EMAIL PROTECTED] wrote:
Hi,
I can write a quick and dirty program to do this but since it is for an
application group a supported utility would be preferred.
Does anyone have code to use SAS, SYNCSORT or some other utility to quickly
summarize
I love this program. So retro. Without the magic handshake on SYSIN,
SYSUT1 gets 013-18. If SYSUT1 is RECFM=F file you get:
HIS004A INVALID DCB OR ACB DATA
And what exactly is a record too short? What does key length mean on
a flat file?
HISTOGRM VERSION 4 JAN. 1981
: Summarize length of all variable length records in a file?
I love this program. So retro. Without the magic handshake on SYSIN,
SYSUT1 gets 013-18. If SYSUT1 is RECFM=F file you get:
HIS004A INVALID DCB OR ACB DATA
And what exactly is a record too short? What does key length mean
on
a flat file
Mainframe Discussion List [mailto:[EMAIL PROTECTED] On
Behalf Of Knutson, Sam
Sent: Wednesday, 5 October 2005 9:17 PM
To: IBM-MAIN@BAMA.UA.EDU
Subject: Summarize length of all variable length records in a file?
Hi,
I can write a quick and dirty program to do this but since
DATA LRECL00(KEEP=L);
INFILE IN LENGTH=L;
INPUT @;
OUTPUT;
RUN;
...
First: L would not be a written variable.
It should be:
DATA LRECL00(KEEP=LEN);
INFILE IN LENGTH=L;
INPUT @ ;
LEN = L ;
Second: @ holds the line. You don't want that! You'll be stuck on the
On Oct 5, 2005, at 9:03 AM, Mark Zelden wrote:
---SNIP-
Since you have SYNCSORT, will HISTOGRM work? I don't think I've run
it in 15 years, but I just tried and it looks like it is what you
want. Here was my test JCL:
//STEP01 EXEC PGM=HISTOGRM
a. You don't need nor want to output to a SAS dataset, if you just want to
count things in the infile. Each OUTPUT takes CPU time and disk space;
instead use DATA _NULL_, SUM statements to accumulate, and a PUT the
sum at the END= of the INFILE:
DATA _NULL_;
INFILE test LENGTH=LENDATA
15 matches
Mail list logo