MVSFORUMS.com

[20cents]

Hi,

Here's the scenario

1. I got 2 input files FileA and FileB;
2. I only need the header record from FileA;
3. I need all the data in FileB;
4. I need to produce a report:

SeqNo: XXXXXXX

CLASS NAME
-------- ------
YYYYYY YYYYY
YYYYYY YYYYY
YYYYYY YYYYY

XXXXXXX - is from FileA
YYYYYY - is from FileB

SeqNo is would serve as header for my report. FileB doesnt contain the data I need, so I need to get it from another File.

How do I tackle this?

20cents.

[vkphani]

20cents,

I haven't understood anything from your scenarios.

What do you mean by this:

[20cents]

VK,

Sorry about that.

To make it clearer (i hope), all the columns that I need for my report resides on FileB, but for my report header (report title) I need to get it from FileA.

20cents.

[20cents]

I tried this:

DATA FDR;
INFILE FDRIN1;
INPUT @1 REC_TYPE $CHAR1.
@359 MAILCODE $CHAR2.
@359 BAG $CHAR17.
@361 BAG_ID $CHAR15.
@361 CENTER 2.
@363 PROD_ID $CHAR3.
@363 PROD_TYP $CHAR3.
@366 BANK_NUM 4.
@370 CARDTYPE 1.
@371 PRODTYP2 1.
@372 CARD_ISS 1.
@373 AIRMAIL 1.
@374 RESERV 2.;
JDATE = SUBSTR(SYSPARM(),1,3);
IF REC_TYPE = '5';
COUNT = 1;
INFILE FDRIN2 OBS=1;
INPUT @46 SEQ_NUM $CHAR8.;

My header worked fine... but then the body of my report also stopped on the first observation.

[batu544]

20cents,

As per your example SEQ_NUM will be a new variable in this dataset FDR . and also you have given OBS=1. so it will read only the 1st observation.
_________________
Regards,
batu

[batu544]

can u give the exact input and desired output structure of your file. ??
_________________
Regards,
batu

[20cents]

All,

thanks for the prompt reply.

Pls disregard my query above. But do help mw with this one.

How do I do this:

Table1 contains (one entry alone):

YYYYYYY


Table 2 contains:

1111111 ZZZZZZ XXXXXXX
2222222 RRRRRR TTTTTTTT
3333333 EEEEEEE QQQQQQ
4444444 UUUUUU MMMMMM
5555555 AAAAAA BBBBBBB

How do I merge the two tables (Table 1 and 2) and produce Table 3:

1111111 ZZZZZZ XXXXXXX YYYYYYY
2222222 RRRRRR TTTTTTTT YYYYYYY
3333333 EEEEEEE QQQQQQ YYYYYYY
4444444 UUUUUU MMMMMM YYYYYYY
5555555 AAAAAA BBBBBBB YYYYYYY

That's right! Append the value found in Table 1 to all rows in Table 2.

Your help is greatly appreciated.

[jetson]

proc sql;
create table table3 as
select * from table1, table2;
quit;

[20cents]

[20cents]

[jetson]

PROC SQL is the easiest way IMO. Since you are creating tables FDR and FDR2 using data steps, you can simply add the PROC SQL as the final step:

PROC SQL;
CREATE TABLE FDR3 AS
SELECT * FROM FDR, FDR2;
QUIT;

Also, as good programming practice, you should add a RUN; statement at the end of each data step.

[20cents]

[jetson]

Can you post that section of the LOG? Did you put the PROC SQL step AFTER the two data steps?

Yes, PROC SQL CREATE TABLE creates a normal SAS dataset by default.

[20cents]

Oh... IT WORKED!!! Thanks a lot Jetson... could I send you PMs incase i got more SAS questions.

/bows to Jetson

[jetson]

I've been a SAS programmer for 15 years. I'm no expert, but I've written a hell of a lot of SAS programs. Happy to help!

I'm new to this forum and I really like it. A great mainframe resource.

Kenny