View previous topic :: View next topic |
Author |
Message |
emadhubabu Beginner

Joined: 03 Sep 2005 Posts: 13 Topics: 6
|
Posted: Fri Dec 09, 2005 6:50 am Post subject: SAS doubts |
|
|
my requirement is:
I had list of variable names in a file.
I have to read a table once for each variable name.
And I have to copy the result of each variable name in to a separate
new member in a PDS. ( member creation should be dynamic)
I have 3500 members to be created..
Please help me! |
|
Back to top |
|
 |
emadhubabu Beginner

Joined: 03 Sep 2005 Posts: 13 Topics: 6
|
Posted: Fri Dec 09, 2005 9:37 am Post subject: |
|
|
I am making my requirement so more clear...
1. I have a PDS with 3500 members.
MEMBER1, MEMBER2,......MEMBER3500
2. Each member has the data like this
abcedefgh
( ABCD123.*
BCDE234.*
CDEF345.*
-----
---- )
xyz
xyzasasa
xyxx
3. I have a DB2 table for which I will pass a SQL like
SELECT COL1
FROM DB2_TABLE
WHERE COL2 = MEMBERXXXX
4. The result coming the SQL will contain the data
If data is
ABCD123
BCDF234
CDEF345
matching with the data in the braces " () "
copy the member from PDS to another NEW_PDS
if data is not matching means
ABCD123
CDEF345
leave the member
5. Like this I have to copy 3500 members and copy the matching member to another PDS.
Please help me
Thanks
Madhu Babu |
|
Back to top |
|
 |
|
|