The following code generates the table you want: data have; input subjectID $ year old_age; cards; AAAAAA      2000     10    AAAAAA      2001     11    AAAAAA      2003     12    AAAAAA      2004     13    BBBBBB      2003     43    BBBBBB      2004     44    CCCCCC      2001     20    CCCCCC      2003     22    CCCCCC      2004     23    CCCCCC      2006     25    ;; run; proc sql;   create table want as   select subjectid, year, old_age, min(old_age) as new_age   from have   group by subjectid; quit; Buy I think what you really need is a table with only one row by subjectid: proc sql;   create table want as   select distinct subjectid, min(year) as year, min(old_age) as new_age   from have   group by subjectid; quit; Regards, ... View more

Hi Daizy, Remember that Enterprise Guide is just a powerfull front-end to SAS. It does not work alone. Where is the SAS Server? Did you download (install) SAS as well in the desktop? Regards, ... View more

be sure to use the colon(:) in the Multidata option: Multidata: Maybe double quotes? Look at the documentation: SAS(R) 9.3 Component Objects: Reference Regards ... View more

Try using the Multidata: 'Y' option in the Declare Hash statement:  declare hash first_HT(dataset:"master", Multidata: 'Y'); Regards, ... View more

My contribution: To use the SQL Pass-Through facility you don't need the libname but instead you need to do a select * from connection. Try this: PROC SQL;      connect to odbc(dsn="SERV1");      select * from connection to odbc (           **** Here the sql code you want the SQL server to execute ****          );      disconnect from odbc; QUIT; RUN; Regards, ... View more

Haikuo: When I run your code I get an error: No DATALINES or INFILE statement. But If I remove the input statement in the data _null_ step I get the same result without the error message. ... View more