Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Need Jcl to run SAS program

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
Narsimha

New User


Joined: 06 Feb 2006
Posts: 3
Location: Vizag

PostPosted: Fri Apr 06, 2007 7:09 pm    Post subject: Need Jcl to run SAS program
Reply with quote

Hi

I need to convert SAS data set to text file. Please help in coding JCL Job. or let me know if there is any alternative to do the same.

Thanks in advance.
Narsimha
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Apr 06, 2007 8:59 pm    Post subject:
Reply with quote

Hello,

If you post the file description and a small amount of your sas data, we may be able to offer suggestions.
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Sat Apr 07, 2007 12:18 pm    Post subject:
Reply with quote

The usual default JCL for executing SAS is

//SAS EXEC SAS
//SYSIN DD *

You place your code after the SYSIN DD card, and any additional DD names can be used and placed between the 2 cards above.

I have been to some shops that have changed this, so if it doesn't work, ask your sysprogs for the PROC name that is correct.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sun Apr 08, 2007 2:53 am    Post subject:
Reply with quote

Hello,

Looks like i'm confused (again icon_confused.gif ). . . .

Do you have a file to convert, do you need to write sas code to create a new text file, both, or something else?

If all you have is a file that needs to be reformatted, we need a few records and then we can offer suggestions on easy ways to reformat your data.

We're here, so let us know what your requirement is icon_smile.gif
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Sun Apr 08, 2007 12:16 pm    Post subject:
Reply with quote

Quote:
Please help in coding JCL Job

Well, that's what I've done.

I think that the OP also wants us to code the SAS too, but without any idea of the input variable list, the format of output or any indication on hourly rate for code supply, there is very little else to offer.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sun Apr 08, 2007 9:53 pm    Post subject:
Reply with quote

Hello,

Maybe we'll get a bit more detail to work with - maybe not. . .
Back to top
View user's profile Send private message
Phrzby Phil

Active Member


Joined: 31 Oct 2006
Posts: 962
Location: Richmond, Virginia

PostPosted: Mon Apr 09, 2007 5:20 pm    Post subject:
Reply with quote

Input the SAS dataset into the CONTENTS and PRINT procs (for the latter, just print a few recs if you have many recs). They'll show you what variables are there and their data types.

Then write a SAS DATA step to input the SAS dataset via the SET command and use the PUT command with appropriate format codes to create a flat file.
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 -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SQL query not working in Cobol program. CuriousMainframer COBOL Programming 14 Wed Feb 22, 2017 5:56 pm
No new posts Executing OO COBOL program invoking J... Virendra Shambharkar COBOL Programming 2 Tue Jan 10, 2017 6:37 pm
No new posts Need Suggestion on COBOL program vickey_dw COBOL Programming 5 Thu Jan 05, 2017 10:55 pm
No new posts I can not compile my program PL1 V3.R... Miguel Fernandez PL/I & Assembler 13 Tue Dec 06, 2016 8:30 pm
No new posts IMS BMP program causes 878 system abend Artemk IMS DB/DC 7 Tue Nov 22, 2016 8:26 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us