Good Morning All, I am attempting to dynamically allocate a macro variable based on the availability of the macro variable name. My problem is that for some reason when 2 or more my batch jobs run at the same time the macro variable I am using ("dog" in the example below) gets overridden by the next job. As a result I would like to read in the macro variable "dog" and change it's name to "dog1". If "dog1" is not available then check the availability of "dog2" and so on until an available name is located then specify the value (by resolving "dog"). The code I have written is as follows: OPTIONS MPRINT MLOGIC SYMBOLGEN; %LET DOG = SCOTT; /*%LET DOG1 = CAT;*/ DATA STUFF; LOOPEND = 1; DO I = 1 TO LOOPEND; TEXT = SYMGET('DOG'||TRIM(LEFT(PUT(I,8.)))); IF TEXT = "" THEN CALL SYMPUT('DOG'||TRIM(LEFT(PUT(I,8.))),SYMGET('DOG')); ELSE LOOPEND +1; END; RUN; %PUT _GLOBAL_; /*%SYMDEL DOG DOG1 DOG2 DOG3 DOG4;*/ Any help you could offer would be greatly appreciated. Thank you for your time. Regards, Scott ... View more

Hi Guys, I am attempting to send an email which has voting buttons associated with it. The question asked will be: Do you use the "Report Name From Dataset" report? Can anyone think of a way that would allow me to do this? As the voting buttons are an Outlook function, I gather that I would somehow need to create code which initiates an outlook session and creates a message with the option buttons turned on. If this isn't possible, does anyone have experience with such an issue? Thank you. Scott ... View more

Hi Guys, At present we have SQL set up which allows us to access an Oracle DB via OLEDB (my understanding, but the code is attached to better explain). The thing is that I would like to establish a libname for this connect, so that I can see the tables contained within. I have code to do this for a genuine Oracle connection, but can't get it to work in this instance. Would anyone have any ideas on this? Thank you in advance. proc sql; connect to oledb as oradb (User = XXXXXXXX Password = XXXXXX DataSource = XXXXXXXXXXXXX provider = MSDAORA.1);; create table list_tab as select * from connection to oradb (select OWNER, TABLE_NAME from ALL_TABLES); quit; ... View more

Hi All, Is there a system option which will give me more meaningful error messages in EG than the below? ERROR: Prepare error: ICommandPrepare::Prepare failed. SQL statement: SELECT C.CLAIMID , C.CLAIMNUMBER , AI.DESCRIPTION , AI.ESTIMATEAMOUNT FROM CBMRV_ASSESSMENTITEM AI , CBMRV_INCIDENT I , CBMRV_CLAIM C , CBMRVL_REFERENCELISTS VC , CBMRVL_REFERENCELISTS AA WHERE C.CLAIMID = I.CLAIMID AND I.INCIDENTID = AI.INCIDENTID ORDER BY C.CLAIMID VC.DESCRIPTION. Thank you for your help. ... View more

Good Afternoon, I have recently stumbled over using the Spool Option in tandem with the Include statement which would assist in reducing the amount of code I have. An example of what I have is below. OPTIONS SPOOL; DATA TEST; SET SASHELP.CLNMSG; WHERE LEVEL = "N"; RUN; DATA TEST1; %INC 4:5; RUN; It appears very simpe, but I get nothing in dataset TEST1. Does anyone have an idea about what I am doing wrong? I have trawled the internet, but can't find anything of use. Your help is greatly appreciated. Regards, Scott ... View more

Hi All, I am trying to sort using SQL (as I am reading the data in from an oracle database and this appears to be the most efficient method), however it sorts blanks last. As a result I get: 1 2 . . . Where as with Proc Sort I get: . . . 1 2 Does anyone know a way to have Proc SQL sort in the same way that Proc Sort does? Thank you for your help. ... View more

Good Morning All, I have an existing XLS file that is in excess of 250mb and is becoming less and less user friendly. There are over 50 pivot tables in this document that the end user still requires which now takes 10 minutes to open. If we convert this file to XLSM then everything opens quickly and the file size is reduced substantially, however the report is automated and is immediately sent to the user upon it's completetion at 6am (when the user begins his day), and therefore it is not practical for me to re-open the XLS file and re-save it as XLSM. I am using 9.1.3 and my understanding is that it can not output to XLSX, hence my question: "Is it possible to export to XLSX using a work around?". Any help would be deeply appreciated. Regards, Scott ... View more