IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Information needed on SAS


IBM Mainframe Forums -> All Other Mainframe Topics
Post new topic   Reply to topic
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
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: 2480
Location: Netherlands, Amstelveen

PostPosted: Tue Apr 19, 2011 3:09 pm
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: 8797
Location: Welsh Wales

PostPosted: Tue Apr 19, 2011 3:23 pm
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: 8651
Location: Dubuque, Iowa, USA

PostPosted: Tue Apr 19, 2011 4:03 pm
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
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: 8651
Location: Dubuque, Iowa, USA

PostPosted: Tue Apr 19, 2011 5:06 pm
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

Senior Member


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

PostPosted: Tue Apr 19, 2011 5:08 pm
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
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: 2455
Location: Hampshire, UK

PostPosted: Thu Apr 21, 2011 3:57 pm
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

Senior Member


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

PostPosted: Thu Apr 21, 2011 6:10 pm
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: 2480
Location: Netherlands, Amstelveen

PostPosted: Fri Apr 22, 2011 12:32 am
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: 1691
Location: Tiruppur, India

PostPosted: Sat Apr 23, 2011 11:57 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> All Other Mainframe Topics

 


Similar Topics
Topic Forum Replies
No new posts Help needed to assemble IMS sample co... ABENDS & Debugging 4
No new posts RABBIT HOLE NEEDED - "Live"... All Other Mainframe Topics 0
No new posts Extract all the TWS scheduler informa... IBM Tools 1
No new posts Mainframe profiles needed @ Cognizant Mainframe Jobs 0
No new posts Table Information - DB2 DB2 1
Search our Forums:

Back to Top