Dear Sas folks,   I am preparing for SAS advanced exam. In my preparation i viewed some online questions. Some of these questions i could not relate to the Sas advanced prep guide.   The questions related to topics as: - ranuni (seed) - proc sort nodup - groupformat - sortedby   My question is: Can i expect questions like this on the exam? Or are these outdated questions? Or to put my question differently: Are all exam questions solely based on the most recent version of the prep guide?   Thanking you in advance, Kind regards,   Unito ... View more

Dear Sas folks,   I try to export a large table (40k records comparable to sashelp.snacks) to an existing .xlsm file (microsoft excel macro file). But i dont's succeed 😞   Does anyone have the golden tip?   i tried an failed with the following methods: 1) use proc export with dbms=xlsx. SAS creates a xlsx file even if the outfile is defined als xlsm. 2) use proc export with dbms=xlsm i get the message  errror: DBMS type XLSM not valid for export. 3) assign a libname with the pc engine to the macro file and  use ods excel and proc print 4) assign a libname with the pc engine to the macro file and use a range in the xlsm file. then use proc copy. success with small files, no succes with large files. 5)  assign a libname with the pc engine to the macro file and then use a data stap   i use sas EG 6.1. and SAS version 9.4.   Kind regards, Unito ... View more