Hi Panos, with the BY statement you can use the automatic variables FIRST.xxxxx and LAST.xxxxxx, where xxxxxx is one of the items in the BY list. The contents of the variables is the information, if there is the first or last record in the group currently in the PDV (active).

Panos PAPANIKOLAOU <PapanikolaouP@CARDIFF.AC.UK> on 06.01.2000 20:45:01

Bitte antworten an Panos PAPANIKOLAOU <PapanikolaouP@CARDIFF.AC.UK>

An: SAS-L@LISTSERV.UGA.EDU Kopie: (Blindkopie: DeTeCSM HellriegelG/D/ExternalStaff/WLB) Thema: set and by

Dear All,

thank you very much for your helpful responses to my query regarding the presence of an IN option in the SET statement. I understand that the SET statement accepts a BY statement as well.

I have 2 data-sets and for each of those a i have an id variable. I used the SET statement in order to add rows to the initial data-set. IThat is, i wanted to stack them. I am wonder if i would supplement ths SET statement with the BY command, would this cause any harm on the output data-set? In other words, would the use of BY statement harm the arising data-set? What would be the additional benefits of using the BY statement?

Thank you very much indeed for taking the time to consider my request. I look forward to hearing from you.

Regards Panos.

Mit freundlichen Gruessen

DeTeCSM, Gerhard Hellriegel

WestLB Abteilung: 001-80622 Aderstr. 22 D - 40217 Duesseldorf Tel.: +49211 826 6173 Fax: +49211 826 5393