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: capture the condition when number of records > 100

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

New User


Joined: 25 Jan 2007
Posts: 11
Location: New York

PostPosted: Tue May 08, 2007 5:37 am    Post subject: SAS: capture the condition when number of records > 100
Reply with quote

Hi
i have question on sas.in sas program currently i am using array

array branch(100) _temporary_ ;

then later

branch(i) = a+b;

where 100 is the number if records in the input file .i add a+b for all branches. (just looping it) .Now i want to capture the condition when number of records is more than 100. how can i know the count first and set it ? please help .
Back to top
View user's profile Send private message

expat

Global Moderator


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

PostPosted: Tue May 08, 2007 1:02 pm    Post subject:
Reply with quote

You want to know the number of branches before you build your array ?
Back to top
View user's profile Send private message
Phrzby Phil

Active Member


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

PostPosted: Tue May 08, 2007 5:56 pm    Post subject:
Reply with quote

For a small-ish file:

1. DATA step #1 reads the file, counting records, and at end sets the value of a macro variable to this number

2. DATA step #2 can now do better than what you wanted. It can size the array using the macro variable, thereby effectively dynamically allocating the array to just the size you want

3. DATA step #2 then re-reads the file, knowing that the array is sized correctly
Back to top
View user's profile Send private message
expat

Global Moderator


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

PostPosted: Tue May 08, 2007 6:20 pm    Post subject:
Reply with quote

If the input data is already in SAS format you could just use the NOBS keyword to get the number of observations in the dataset.

SET &FILEIN (OBS=1) NOBS=NNN;
Back to top
View user's profile Send private message
ganeshcet

New User


Joined: 25 Jan 2007
Posts: 11
Location: New York

PostPosted: Wed May 09, 2007 9:41 pm    Post subject:
Reply with quote

Hi
thanks for the help.
here is the code for the macro variable.

DATA _NULL_;
INFILE inputfileddname END=EOF;
INPUT;
IF EOF THEN
CALL SYMPUT('X',_N_);
RUN;

DATA _NULL_;
array arrayvariable(&x) _temporary_;
Back to top
View user's profile Send private message
Phrzby Phil

Active Member


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

PostPosted: Thu May 10, 2007 6:14 pm    Post subject:
Reply with quote

Thanks for posting your resolution.
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 Skip records depends on count lakshmiibmmainframes DFSORT/ICETOOL 5 Sun Dec 24, 2017 9:51 pm
No new posts Compare two PS files using ICE TOOL f... SENTHIL MURUGAAN DFSORT/ICETOOL 5 Sun Dec 24, 2017 1:26 pm
No new posts Inefficient BUILD - VB records paddin... Daniel Prosser SYNCSORT 9 Thu Dec 14, 2017 3:52 pm
No new posts ISSUE IN copying Sequential file reco... thesumitk JCL & VSAM 2 Wed Dec 13, 2017 3:07 pm
No new posts Merging 2 records at multiple rows wi... Bijesh DFSORT/ICETOOL 2 Wed Dec 06, 2017 1:50 am

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