05-18-2013 10:07 PM
Any input on how to create an Excel file with the first name, DOB of child and Name of child of the youngest child (clearly bulb born on 22-nov-80).
|last name||first name||DOB of Child||Name of Child|
05-18-2013 10:20 PM
You are absolutely right sorry about that.
Shepard would be the youngest.
After proc sorting the dataset by DOB what would be the best to remove Shepard's info (first name, DOB and name) and setting up another file in excel.
05-19-2013 01:33 AM
*select the minimum;
create table want as
select * from have
where dob=(select min(dob) from have);
*use export in SAS to get the code or tagsets which generates an XML file;
ods tagsets.excelxp file="C:\temp\test.xml" style=journal;
proc print data=want noobs;
ods tagsets.excelxp close;