Dear all! Thanks for the best support here!   I've a problem...   I have this type of table: QT_APPENDICE                   Rata_Totale_Calcolata    Incrocio 201257486                             279,46                             12 / 10000 201257486                             289,51                             12 / 15000 201257486                             299,57                             12 / 20000 201257486                             309,63                             12 / 25000 201257486                             319,68                             12 / 30000 201257486                             338,48                             12 / 35000 201257486                             357,24                             12 / 40000 201260661                             325,56                             12 / 10000 201260661                             343,80                             12 / 15000 201260661                             362,04                             12 / 20000 201260661                             380,28                             12 / 25000 201260661                             398,51                             12 / 30000 201260661                             416,75                             12 / 35000 201260661                             434,95                             12 / 40000   After the creation of this table i make a traspose where the column incrocio become the lable of the column. This is the code: PROC SQL; CREATE VIEW WORK.SORTTempTableSorted1 AS SELECT T.Incrocio, T.Rata_Totale_Calcolata, T.QT_APPENDICE FROM WORK.QUERY_FOR_DB_MTX1_0000 as T ; QUIT; PROC TRANSPOSE DATA=WORK.SORTTempTableSorted1 OUT=WORK.TRNSTransposed1(LABEL="WORK.QUERY_FOR_DB_MTX1_0000 trasposto") NAME=Origine LABEL=Etichetta ; BY QT_APPENDICE; VAR Incrocio Rata_Totale_Calcolata; ID Incrocio; IDLABEL Incrocio; RUN; The result is correct but now i need to filter the only for the value of rata totale (i filter the column origine with value "incrocio" created after the traspose) and i need to convert this character value in number. I create this code:   PROC SQL; CREATE TABLE WORK.MATRIX_OUT AS SELECT t1.QT_APPENDICE, ((input(COMPRESS('12 / 10000'n),COMMAX10.2))) PROC SQL; CREATE TABLE WORK.MATRIX_OUT AS SELECT t1.QT_APPENDICE, ((input(COMPRESS('12 / 10000'n),COMMAX10.2))) FORMAT=COMMAX10.2, ((input(COMPRESS('12 / 15000'n),COMMAX10.2))) FORMAT=COMMAX10.2, ((input(COMPRESS('12 / 20000'n),COMMAX10.2))) FORMAT=COMMAX10.2, ((input(COMPRESS('12 / 25000'n),COMMAX10.2))) FORMAT=COMMAX10.2, ((input(COMPRESS('12 / 30000'n),COMMAX10.2))) FORMAT=COMMAX10.2, ((input(COMPRESS('12 / 35000'n),COMMAX10.2))) FORMAT=COMMAX10.2, ((input(COMPRESS('12 / 40000'n),COMMAX10.2))) FORMAT=COMMAX10.2 FROM WORK.TRNSTRANSPOSED1 t1 WHERE t1.Origine NOT = 'Incrocio'; QUIT; with this code convert the text value in number, but  it lost the label of column like the traspose and give the name "_TEMA001... _TEMA002... ecc".   If i use the AS attribute he rename the column.   How can i retain the label and convert the format with this code?   Thanks for the support!         ... View more

Good Morning   with a proc sql I produce the db out_invoices that i want to export only if it is the second monday of the month (a monday in a day between 8 and 14 )   This is the macro that i've created: %macro export_conditionally; %if (day(now) between 8 and 14) and workday(now)=2 %then %do; proc export data=work.out_invoices dbms=xlsx outfile="\\23- REPORT\CUSTOMER.xlsx" replace; run; %end %mend; %export_conditionally;   When i open SAS, in the first time, the program execute correctly the code. From the second run the macro crash and give this error:   _________________________________ 49 NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended.   what i'm doing wrong? 😞 ... View more

Hi, i want to use SAS to run a macro in a excel .xlsm file. I read this useful guide:   https://blogs.sas.com/content/sasdummy/2011/05/03/using-sas-enterprise-guide-to-run-programs-in-batch/   but i've a problem to use the filename "excel|system" option. The code is: options noxwait noxsync; x '"C:\Program Files (x86)\Microsoft Office\Office14\EXCEL.EXE" '; /* Sleep for 5 seconds to give Excel time to come up */ data _null_; x=sleep(5); run; filename cmds dde "excel|system"; data _null_; file cmds; /* Open the excel file test.xlsm which contains the VBA macro */ put '[open("X:\temp\test.xlsm")]'; /* Run myVBAmacro */ put '[run("test.xlsm!myVBAmacro")]'; run; When i run a program the log give back this error:   ERROR: Physical file does not exist, excel|system.   What is wrong?   Thanks for the support ... View more