Dear All,

I have a doubt....

Let us suppose that I have the following data...

SUB. NO LABPARAMETERS RESULTS

001 WBC 1102
001 Lymphocytes 20% of WBC
002 WBC 1305
002 Lymphocytes 15% OF WBC
003 WBC 1065
003 Lymphocytes 18% Of WBC
004 WBC 2356
004 Lymphocytes 17 % OF WBC


Without using proc transpose how can I arrive the exact values for all Lymphocytes....

WE can rearrange the table now as below....

SUB. NO LABPARAMETERS RESULTS

001 WBC 1102
001 Lymphocytes 20
002 WBC 1305
002 Lymphocytes 15
003 WBC 1065
003 Lymphocytes 18
004 WBC 2356
004 Lymphocytes 17

So here I have kept only numbers...Where the 20 (RESULTS for SUB.NO 001 Lymphocytes) represents 20% of WBC.