View previous topic :: View next topic
|
Author |
Message |
Narsimha
New User
Joined: 06 Feb 2006 Posts: 3 Location: Vizag
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Looks like i'm confused (again ). . . .
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 |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Maybe we'll get a bit more detail to work with - maybe not. . . |
|
Back to top |
|
|
Phrzby Phil
Senior Member
Joined: 31 Oct 2006 Posts: 1042 Location: Richmond, Virginia
|
|
|
|
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 |
|
|
|