thanks tom for your reply. I'm actually very new to SAS EG. I used to use SQL to extract data, use script or just manually implement them in Excel before EG was introduced in our company. if this task is even challenging in EG, then what is this better than Excel? Sorry I'm a little bit off topic here. Anyway, back to the topic, I'm very interested in any method that could achieve this goal in SAS. After all, it could be a better working process in SAS than in EXCEL. Thanks Thomas.K
... View more