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
 

 

Information needed on SAS

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

New User


Joined: 26 Apr 2005
Posts: 87
Location: Hyderabad

PostPosted: Tue Apr 19, 2011 3:01 pm    Post subject: Information needed on SAS
Reply with quote

Dear Friends,

Can anyone let me know about SAS datasets?
Is SAS dataset is different from our normal mainframe datasets?

Any information on this would really help.

Regards
Tanden
Back to top
View user's profile Send private message

PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2422
Location: Netherlands, Amstelveen

PostPosted: Tue Apr 19, 2011 3:09 pm    Post subject:
Reply with quote

Visit the SAS site.

In short : SAS libraries are mainframe datasets containing SAS datasets.
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: Tue Apr 19, 2011 3:23 pm    Post subject:
Reply with quote

How do you mean different
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7913
Location: Bellevue, IA

PostPosted: Tue Apr 19, 2011 4:03 pm    Post subject:
Reply with quote

A SAS dataset is stored in a "normal mainframe dataset" you know. SAS maintains a SAS dataset itself as there is data about variable attributes as well as data values stored in the SAS dataset.
Back to top
View user's profile Send private message
notonly4u

New User


Joined: 26 Apr 2005
Posts: 87
Location: Hyderabad

PostPosted: Tue Apr 19, 2011 5:02 pm    Post subject:
Reply with quote

Hi Robert,

Thanks for the posting.
Is there anyway that we could write the data values stored in the SAS dataset into our normal mainframe dataset?

I read through the manuals, but was unsuccessful in finding one.

Thanks much for your time.

Regards
Tanden.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7913
Location: Bellevue, IA

PostPosted: Tue Apr 19, 2011 5:06 pm    Post subject:
Reply with quote

Code:
DATA _NULL_;
SET SAS.DATASET;
FILE OUTFILE;
PUT ...
where the PUT statement outputs each variable you want in the output dataset pointed to by OUTFILE DD name. DATA _NULL_ saves the overhead of creating a WORK. version of the SAS dataset. You may want to use formats in your PUT statement, depending upon the variables. You may also want subsetting IF logic to restrict which observations you output -- it all depends.
Back to top
View user's profile Send private message
Phrzby Phil

Active Member


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

PostPosted: Tue Apr 19, 2011 5:08 pm    Post subject:
Reply with quote

Write a SAS program, run it in SAS.

The program will input the SAS dataset (usually in a DATA step via a SET statement), and then write the data in display mode (in the same DATA step) via a PUT statement, to a file identified in a FILE statement.

For more info, you'll obviously need to know some SAS, or else contract with someone to srite a program for you.
Back to top
View user's profile Send private message
notonly4u

New User


Joined: 26 Apr 2005
Posts: 87
Location: Hyderabad

PostPosted: Thu Apr 21, 2011 3:48 pm    Post subject:
Reply with quote

Dear All,

Thank you all for your time.
I came to know that we can write the SAS dataset using Libname statement in SAS program.

Code:
LIBNAME NEWLIB "HLQ.TST.DATA"   
   DISP=(NEW,CATLG)                             
   UNIT=SYSDA SPACE=(27998,(15000,1500),RLSE)   
   BLKSIZE=23040;                               


and

Code:
PROC PRINT DATA=NEWLIB.MEMBER1;
RUN;                           


This helped me to create SAS dataset.

Regards
Tanden
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 1715
Location: UK

PostPosted: Thu Apr 21, 2011 3:57 pm    Post subject:
Reply with quote

notonly4u wrote:

This helped me to create SAS dataset.


Which is not the question you asked. If you had then some of the other answers may have been irrelevant to your requirements.
Back to top
View user's profile Send private message
Phrzby Phil

Active Member


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

PostPosted: Thu Apr 21, 2011 6:10 pm    Post subject:
Reply with quote

It also did not create a SAS dataset.

It printed it.

This is a pretty elementary distinction in any programming environment - create a file vs. print a file.

Perhaps you need a basic IT primer.
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2422
Location: Netherlands, Amstelveen

PostPosted: Fri Apr 22, 2011 12:32 am    Post subject:
Reply with quote

It allocated a SAS library. And maybe in between the creation and the print, a MEMBER1 SAS dataset was created in THE library. But then the TS
is letting us guessing about what he did.
What i really find is disgusting that this kind of topic starters is/are most of the time using pics of holy minds or matrix stuff, meaning they are on a high mental level.
Back to top
View user's profile Send private message
vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1445
Location: Azeroth

PostPosted: Sat Apr 23, 2011 11:57 pm    Post subject:
Reply with quote

Quote:
using pics of holy minds or matrix stuff, meaning they are on a high mental level.


I second this statement icon_biggrin.gif
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 Obtaining file information pahiker COBOL Programming 25 Tue Sep 27, 2016 7:25 pm
No new posts Help Needed with View Direct shailesh_do CA Products 2 Wed Jul 13, 2016 10:39 am
No new posts Need information on COBOL MOVE CORRES... subratarec COBOL Programming 10 Tue Jun 28, 2016 10:38 pm
No new posts Passing information through JCL as in... Pia Baruah JCL & VSAM 5 Wed May 25, 2016 2:22 pm
No new posts Extracting Information from DD Statem... Charles Wolters All Other Mainframe Topics 7 Wed Apr 13, 2016 10:21 pm


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