Thank you all for your inputs,   here is the data step raw data - code   data input; input Name$ Sex$ Age Height Weight month; cards; Alfred M 14 69 112.5 0 Alice F 13 56.5 84 1 Barbara F 13 65.3 98 2 Carol F 14 62.8 102.5 3 Henry M 14 63.5 102.5 4 James M 12 57.3 83 5 Jane F 12 59.8 84.5 6 Janet F 15 62.5 112.5 7 Jeffrey M 13 62.5 84 8 John M 12 59 99.5 9 Joyce F 11 51.3 50.5 10 Judy F 14 64.3 90 11 Louise F 12 56.3 77 12 Mary F 15 66.5 112 13 Philip M 16 72 150 14 Robert M 12 64.8 128 15 Ronald M 15 67 133 16 Thomas M 11 57.5 85 17 William M 15 66.5 112 18 Louise F 12 56.3 77 19 Mary F 15 66.5 112 20 Philip M 16 72 150 21 Robert M 12 64.8 128 22 Ronald M 15 67 133 23 Alfred M 14 69 112.5 24 Alice F 13 56.5 84 25 Barbara F 13 65.3 98 26 Carol F 14 62.8 102.5 27 Henry M 14 63.5 102.5 28 James M 12 57.3 83 29 Jane F 12 59.8 84.5 30 Janet F 15 62.5 112.5 31 Jeffrey M 13 62.5 84 32 John M 12 59 99.5 33 Joyce F 11 51.3 50.5 34 Alfred M 14 69 112.5 35 Alice F 13 56.5 84 36 run;   Output - looking for    Data    Want Name Sex Age Height Weight Time - month   want - Sum of weight for 12month (for time=0 need sum of weight from time 0 to 11, then for time=1 need sum of weight from time 1 to 12) Alfred M 14 69 112.5 0   1103.5 Alice F 13 56.5 84 1   1068 Barbara F 13 65.3 98 2   1096 Carol F 14 62.8 102.5 3   1148 Henry M 14 63.5 102.5 4   1173.5 James M 12 57.3 83 5   1204 Jane F 12 59.8 84.5 6   1206 Janet F 15 62.5 112.5 7   1233.5 Jeffrey M 13 62.5 84 8   1198 John M 12 59 99.5 9   1226 Joyce F 11 51.3 50.5 10   1276.5 Judy F 14 64.3 90 11   1354 Louise F 12 56.3 77 12   1397 Mary F 15 66.5 112 13   1432.5 Philip M 16 72 150 14   1404.5 Robert M 12 64.8 128 15   1352.5 Ronald M 15 67 133 16   1327 Thomas M 11 57.5 85 17   1296.5 William M 15 66.5 112 18   1294.5 Louise F 12 56.3 77 19   1267 Mary F 15 66.5 112 20   1302.5 Philip M 16 72 150 21   1274.5 Robert M 12 64.8 128 22   1224 Ronald M 15 67 133 23   1146.5 Alfred M 14 69 112.5 24   N/A Alice F 13 56.5 84 25   N/A Barbara F 13 65.3 98 26   N/A Carol F 14 62.8 102.5 27   N/A Henry M 14 63.5 102.5 28   N/A James M 12 57.3 83 29   N/A Jane F 12 59.8 84.5 30   N/A Janet F 15 62.5 112.5 31   N/A Jeffrey M 13 62.5 84 32   N/A John M 12 59 99.5 33   N/A Joyce F 11 51.3 50.5 34   N/A Alfred M 14 69 112.5 35   N/A Alice F 13 56.5 84 36   N/A ... View more

Thank you ... View more

Thank you for your input, but my process is build in sql and just to change this part in sas is going to be nightmare at this moment as it is impacting lot more on this calculation. so badly needed this in sql. ... View more

Thank you Cwilson thats what I was looking for. Perfect ... ... View more

All, * Here is my table A ; data A; input @1 QUE1 $ @6 QUE2 $ @11 QUE3 $ @16 QUE4 $ @21 UNIQUE$; cards; 0001 0011 0003 0011 ABCDERG1 0002 6934 0006 6934 ABCDERG2 0003 0007 6934 0010 ABCDERG3 0004 6935 6934 0014 ABCDERG4 0005 6934 0014 6934 ABCDERG4 0006 0002 0015 6935 ABCDERG5 0007 0015 6934 0015 ABCDERG6 0008 0017 6934 0017 ABCDERG7 0009 0018 0018 0018 ABCDERG8 6934 6934 0017 6935 ABCDERG9 6935 0007 6935 0017 ABCDERG0 ; run; * Here is my table B ; data B; input @1 QUE_ALL $   AMT 5.2; cards; 0001 7.74 0002 2.90 0003 8.74 0004 6.74 0005 1.90 0006 13.74 0007 0.00 0008 6.00 0009 9.90 0010 9.74 0011 0.90 0012 5.90 0013 9.90 0014 10.24 0015 14.24 0016 17.24 0017 10.74 0018 14.74 0019 12.74 0020 11.74 6932 4.24 6933 4.49 6934 4.74 6935 4.99 6936 5.24 ; run; * Below is the output table I am looking for we need to merge QUE1, QUE2 , QUE3, QUE4 from table A to QUE_ALL from table B and create the new variable AMT1, AMT2, AMT3, AMT4 accordingly; QUE1 AMT1  QUE2  AMT2  QUE3  AMT3  UNIQUE 0001   7.74    0011   0.90     0003   8.74    ABCDERG1 0002   2.90    6934   4.74     0006   13.74  ABCDERG2 0003   8.74    0007   0.00     6934   4.74    ABCDERG3 0004   6.74    6935   4.99     6934   4.74    ABCDERG4 0005   1.90    6934   4.74     0014   10.24  ABCDERG4 0006   13.74  0002   2.90     0015   14.24  ABCDERG5 0007   0.00    0015   14.24   6934   4.74    ABCDERG6 0008   6.00    0017   10.74   6934   4.74    ABCDERG7 0009   9.90    0018   14.74   0018   14.74  ABCDERG8 6934   4.74    6934   4.74     0017   10.74  ABCDERG9 6935   5.24    0007   0.00     6935   4.99    ABCDERG0 ; * after spending whole day on this - I thought to post here.; *Thank you for your help; ... View more

Thank you to Jagdish, Linlin and Cynthia for provide me three different direction for same Job !! Cynthia, Your post are really helpful, I am learning SAS and sometimes I gets answer from your old post and thank you for giving a good description, We really need as a SAS Lerner !! Regards, Ranny ... View more

Karun, I think you have to use conditional statement at some point with merge / proc SQL join but still if you will provide complete information then i can answer correctly. ... View more

Quentin and Damien, Thank you for your advice guys !! I came across with one more problem. Can you please guide me ?? As you know I am running SAS program through Autosys !! so In autosys I am assigning Path for unix script and when Unix script runs through autosys, its invoking SAS program (means unix script call the sas program) and the question is . . . . In SAS program everything is going goood.  ..  but at the end of SAS program I have assigned three PROC EXPORT procedure for .csv and In SAS log it says 1.    "X:\filename.csv" was successfully created 2.    "\\hotest\folder1\folder2\filename.csv" was successfully created 3.   "\hotest\folder1\folder2\filename.csv" was successfully created But when I open the particular folder then I am not finding .csv file ?? Why ?? I have access for this folder also . . . If you know any possibility for this problem then pls tell me otherwise you can give me some other option also.. Thank you Sir !! - Ranny ... View more