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: 8593
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: 965
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: 8593
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: 965
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 sort records based on length exceeds ... maxsubrat DFSORT/ICETOOL 7 Wed Oct 04, 2017 4:48 pm
No new posts Addition of two records on 2 fields amar143 SYNCSORT 8 Tue Oct 03, 2017 11:14 am
No new posts BUILD OUTFIL based on condition other... balaji81_k DFSORT/ICETOOL 13 Fri Sep 08, 2017 11:06 pm
No new posts Join records from 2 files with No Dup... Poha Eater DFSORT/ICETOOL 22 Sun Aug 27, 2017 10:35 pm
No new posts Profile changed to NUMBER ON STD (fro... Martylin TSO/ISPF 1 Thu Aug 03, 2017 9:14 am

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