Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
SAS to ICETOOL conversion.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics
View previous topic :: :: View next topic  
Author Message
vaibhavjadhav

New User


Joined: 27 Jul 2007
Posts: 33
Location: mumbai

PostPosted: Wed Jun 15, 2011 10:46 am    Post subject: SAS to ICETOOL conversion.
Reply with quote

Hi,

In my project requirement I have to convert the below SAS code to ICETOOL code.
Could you please help me on this?

SAS code:
DATA<O/P FILE>;
MERGE<I/P FILE-1> (IN=in_b) <I/P FILE-2>;
BY POL_NO --> this is first 9 bytes in both the input files.
IF in_b;
RUN;

Note: this merge writes the matching records from both the input files and non-matching records from the I/P FILE-1.

Please help me with this issue also do let me know if you have any concerns.

Vaibhav.
Back to top
View user's profile Send private message

vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1522
Location: Chennai

PostPosted: Wed Jun 15, 2011 11:05 am    Post subject:
Reply with quote

Hello,
As you maybe aware that a SAS dataset is almost similar to a SQL table,
The code which you have shown produces a SAS dataset as output, whereas ICETOOL cannot produce SAS dataset as output.

are you planning to write both the sas datasets into external file and then merge using SORT(ICETOOL)?
Back to top
View user's profile Send private message
vaibhavjadhav

New User


Joined: 27 Jul 2007
Posts: 33
Location: mumbai

PostPosted: Wed Jun 15, 2011 2:27 pm    Post subject:
Reply with quote

Yes Vasanth you are correct.
Back to top
View user's profile Send private message
vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1522
Location: Chennai

PostPosted: Wed Jun 15, 2011 4:18 pm    Post subject:
Reply with quote

Hello,
I guess you are looking for SPLICE using ICETOOL, try if this example suits ur requirement
http://ibmmainframes.com/post-42612.html

if no, provide more information of how the two sas datasets get created,
is there any processing done while creating the two SAS datasets?
what is the input statement used? (to understand the layout of the file)
what would be the put statement used to write the SAS datsets into external files?
More relevant information will be useful.
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Wed Jun 15, 2011 10:42 pm    Post subject:
Reply with quote

Vaibhav.

If you're looking for a DFSORT solution (or a DFSORT/ICETOOL solution), you could use DFSORT's JOINKEYS function. For complete details on JOINKEYS, see:

http://www.ibm.com/support/docview.wss?rs=114&uid=isg3T7000174

If you want more specific help to do this with DFSORT, please show an example of the records in each input file (relevant fields only) and what you expect for output. Explain the "rules" for getting from input to output. Give the starting position, length and format of each relevant field. Give the RECFM and LRECL of the input files. If file1 can have duplicates within it, show that in your example. If file2 can have duplicates within it, show that in your example.

Also, run this job and show the //SYSOUT messages you receive, so I can see what level you're at:

Code:

//S1    EXEC  PGM=SORT
//SYSOUT    DD  SYSOUT=*
//SORTIN DD *
RECORD
//SORTOUT DD DUMMY
//SYSIN    DD    *
    OPTION COPY
/*
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Difference in SORT & ICETOOL Mohan Kothakota DFSORT/ICETOOL 5 Fri Sep 22, 2017 4:56 pm
No new posts Multiple VSAM files single output fil... Mohan Kothakota DFSORT/ICETOOL 11 Wed Aug 09, 2017 7:57 pm
No new posts Using ICETOOL, how we can seperate th... bshkris SYNCSORT 5 Tue May 09, 2017 8:33 pm
No new posts Group elements using ICETOOL Learncoholic DFSORT/ICETOOL 2 Fri Apr 14, 2017 11:01 am
No new posts Converting decimal to numeric using I... Balaryan DFSORT/ICETOOL 4 Thu Feb 02, 2017 11:27 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us