Bom dia. Alguém poderia ajudar? Estou tentando rodar o rotina: proc sql noprint; select max(input(scan(scan(arquivo,1,'.'),-1,'_d'),yymmddn8.)) as dt_ref into: dt_copia from work.out_ls where pasta eq './' and arquivo contains "cluster_encer"; ;run; %put &dt_copia; proc sql; create table ENCERRADA as select * from canal.cluster_encer_&dt_copia ; quit; Mas está tendo os erros: ERROR: The informat YYMMDDN was not found or could not be loaded. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. NOTE: PROC SQL statements are executed immediately; The RUN statement has no effect. WARNING: Apparent symbolic reference DT_COPIA not resolved. &dt_copia NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): NOTE: Line generated by the invoked macro "SEUDIA". 4278 create table ENCERRADA as select * from canal.cluster_encer_&dt_copia ; _ 22 200 WARNING: Apparent symbolic reference DT_COPIA not resolved. ERROR 22-322: Syntax error, expecting one of the following: a name, ;, (, ',', ANSIMISS, AS, CROSS, EXCEPT, FULL, GROUP, HAVING, INNER, INTERSECT, JOIN, LEFT, NATURAL, NOMISS, ORDER, OUTER, RIGHT, UNION, WHERE. ERROR 200-322: The symbol is not recognized and will be ignored.
... View more