Hi,   I want to update all observations with a condition. If i have a newer date and for the same Tag. I did a search and i may mixed sql and sas.   date is in format 05Mar2018 Date9. and Tag is a string   data mydata; modify mydata adddata; by date; if (adddata.date ge mydata.date AND adddata.Tag eq mydata.Tag) then replace; run; and i have this error: ERROR: DATA STEP Component Object failure.  Aborted during the COMPILATION phase. ERROR 557-185: Variable adddata is not an object.   Can i do with this correct by someone or i have other options?   Regards, Aleixo ... View more

Hi,   I try to search how to merge horizontally but from only one data and never found. This happen to me because i use function append   The idea is making a historical data, for example: when find multiple tags add the older date to a new column.   I have this DATA: Name Tag Date Ze A 10Jan2018 Ze A 1Jan2018 Ze B 15Fev2018 Manel C 3Mar2017 Joao D 20Fev2018 Joao D 10Fev2018 Joao D 3Fev2018 Joao E 25Fev2018 Antonio F 25Dec2018 I want this DATA: Name       Tag     Date1 Date2 Date3 Ze A 10Jan2018 1Jan2018 Ze B 15Fev2018 Manel C 3Mar2017 Joao D 20Fev2018 10Fev2018 3Fev2018 Joao E 25Fev2018 Antonio F 25Dec2018 It is possible to do with a task computed new columns? Or somebody have a macro for that?   Thanks for your atention, Aleixo ... View more

Hi,   I want to update a table (one column) from WORK.FILTER_FOR_TESTE_NOVA_LISTADISJU but only new values(not same values) with a condition. With this next code the column is all updated with new value and the others values changed to NULL because the condition.   What i want is change only the new value on the column with these conditions and not all column.   proc sql; title 'Nova Lista Disjuntores'; create table WORK.Nova_Lista_Disjuntores as select * from DIST_DDC.DDC_APA_LISTADISJUNTORESRND; update WORK.Nova_Lista_Disjuntores as u set Último_Disparo=(select Último_Disparo from WORK.FILTER_FOR_TESTE_NOVA_LISTADISJU as n where u.Tag=n.Tag AND u.Último_Disparo < n.Último_Disparo) where u.Último_Disparo in (select Último_Disparo from WORK.FILTER_FOR_TESTE_NOVA_LISTADISJU); select Último_Disparo from WORK.Nova_Lista_Disjuntores; run; Regards, Aleixo   ... View more

Hi,   I had this ERROR about dates. I tried with fix dates like 01JAN2012 and 07FEB2018 and works fine. I don't know why SAS doesn't like calculated variables.   34 35 GOPTIONS ACCESSIBLE; 36 %let date=2012-01-01; 37 %let date_d9=%sysfunc(inputn(&date, yymmdd10.), date9.); 38 %put &date_d9.; 01JAN2012 39 40 %let tdate = %sysfunc(today(),date9.); 41 %put &tdate.; 07FEB2018 42 43 PROC SQL; 44 CREATE TABLE WORK.TEST AS 45 SELECT t1.'Instalação'n, 46 t1.Painel, 47 t1.'Último Disparo'n 48 FROM WORK.LISTADISJUNTORESRND t1 49 WHERE t1.'Último Disparo'n BETWEEN 'date_d9.'d AND 'tdate.'d; ERROR: Invalid date/time/datetime constant 'date_d9.'d. ERROR: Invalid date/time/datetime constant 'tdate.'d. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 50 quit; NOTE: The SAS System stopped processing this step because of errors. Regards, Aleixo ... View more