Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
avoiding subselects
Friends, I think my earlier post went deviated from my expectations and I would to rephrase the question in simple terms. I have a table with large number of rows. The fields are Policy_num, Eff_date, ... For an input date range (Eff_date), I need to extract the Policy_nums. After that I need...- 9776
- Thread
- Replies: 1
- Forum: SAS Institute, Inc. solutions
-
simulating cursor logic in SAS
klaz2002 and jymm, thanks for your prompt responses. Unfortunately I won't be able to change the existing process and introduce stored proc on DB2 side. The existing program does lot of complex processing. So we are only interested in improving the performance by removing the subselect (to get...- 9776
- Post #4
- Forum: SAS Institute, Inc. solutions
-
simulating cursor logic in SAS
Friends, I am fairly experienced in SAS but am finding hard to find a better way to handle the below problem in SAS. I have a table with multiple fields. eg. Policy table with fields Pol_ref,Date,Premium fields. Pol_ref is not unique. First I need to check if the Pol_ref is within inputted...- 9776
- Thread
- Replies: 3
- Forum: SAS Institute, Inc. solutions
