MVSFORUMS.com

chandra_vssv · Posted: Mon Jun 08, 2009 3:06 am Post subject: SAS array help needed

Hi,

I have i/p dataset ' A 'with 5 columns and 22 rows, 4th column contains STATE Names. I want to load all these values from 'A' in to an array and match this 4th column with a field in another dataset 'B' at a particulat position say @44, if match found then i have to move all the values from 'A' to 'B'. B contains many records with same STATE.I have to write all the records of matching state. Very new to SAS. Please let me know how can i acheive this.

Lay out of 'A

Sno Name STATE AMNT
1 sam CA 10000
.
.
.
.
.
.
.
22 xyz NY 200000

Layout of B

50 fields and @44 position STATE column.

Thanks in advance
_________________
Regards,
Chandu

expat · Posted: Mon Jun 08, 2009 5:32 am Post subject:

MERGE dataset1 (in=id1) dataset2 (in=id2);
BY whatever;
_________________
If it's true that we are here to help others,
then what exactly are the others here for ?

chandra_vssv · Posted: Mon Jun 08, 2009 9:22 am Post subject:

I got it by doing MERGE but i want the i/p 'A' dataset to be loaded in array, as per requirement. Please let me know how can i do that. Thanks in advance.
_________________
Regards,
Chandu

kolusu · Posted: Mon Jun 08, 2009 10:42 am Post subject:

chandra_vssv,

Check this link which explains array processing with examples

http://support.sas.com/documentation/cdl/en/lrcon/61722/HTML/default/a002299816.htm

Kolusu

expat · Posted: Tue Jun 09, 2009 12:43 am Post subject:

If you get the required results by an easier route, why the stupid requirement to use a more involved and difficult code route ?
_________________
If it's true that we are here to help others,
then what exactly are the others here for ?

chandra_vssv · Posted: Tue Jun 09, 2009 8:34 am Post subject: thanks

Thanks Kolusu for the Link on Arrays, i am trying to understand the array concept in SAS, it is different in SAS from other programming languages(COBOL) .

Expat
Thanks for suggesstion as well. Cannot change the requirement.

Let me know incase if you can provide the solution. I understood one D arrays in SAS, i/p file is 2D. I have to match that 2D array element to a field in flat file.I am trying but running short of time.
_________________
Regards,
Chandu

kolusu · Posted: Tue Jun 09, 2009 12:51 pm Post subject: Re: thanks

chandra_vssv · Posted: Wed Jun 10, 2009 3:29 am Post subject: hi

Kolusu,

I just started learning SAS, hardly 3-4 days. I conquer with Expat but i was just letting him know about my requirement. I do not mean it, i am sorry if something wrong in my previous reply.

You guys are really doing a wonderful job.
_________________
Regards,
Chandu

expat · Posted: Wed Jun 10, 2009 6:11 am Post subject:

I've heard worse, believe me Very Happy

Just more than a little confused ...................

If you load file A into an array, then try and merge it with file B, the variable name will have to be the same, so you create a new variable by Varname = Array_Name(n), or you also need to format file B into an array with the compare variable being referred to by the same index as that used for file A.
_________________
If it's true that we are here to help others,
then what exactly are the others here for ?

chandra_vssv · Posted: Wed Jun 10, 2009 10:29 am Post subject: Hi

Expat

You are right , i tried in SAS editor , it is giving me results but not as expected. Here i have taken the data to be compared with array under cards but actual file is unknow, we dont know how many records will be processed (cant say , may be millions)