I'm trying to document my EG 4.3 project. I need to include external files (docx, xlsx) to a project for user to read. I tried doc, docx, xls, xlsx and only type which I can open and read is doc. EG opens docx in non-readable format and Excel files it wants to import. Is there a way to include these file types only as "attachments" to a project? Or is there an easy (not SAS code) way to include links to documents? For example a note which includes a link to a docx file? Or a data which includes links in cell values? ... View more

Hi! I have problem doing the join between two tables in EG or sql code. First data set has observations with unique id and second data set has n obs with that id and also a var (for example date) and I need to join obs from first data set to the obs from second data set with the latest date. Also many other vars in both data sets. Data step merge is easy but is it possible to do it in one sql join (preferrably using EG query builder)? See data step solution below. data a; input id num1; datalines; 1 4 2 5 ; data b; input id num2 name $; datalines; 1 2 Br 1 3 Qc 1 7 Fe 2 2 Dr 2 4 Mi ; proc sort data=a; by id; run; proc sort data=b; by id num2; run; data c; merge a b; by id; if last.id; run; proc print;run; ... View more