Hi,   How i can filter results in a table with the variable frequency that SAS VA assume in each table? Frequency is not recognise as variable. I want to do something like TOP3, TOP5 or TOP10 in tables/graphs by frequency.    Another question is how to change the criteria of frequency? Could be a table with 3 /4 variables and i choose the variable for frequency?   Thanks ... View more

  Hi,   This is my table with a format char, and i want to change format to YYMM7.     I try this with no result   PROC SQL; CREATE TABLE WORK.QUERY_FOR_DATES AS SELECT /* Calculation */ (input(t1.ANO_MES, anydate.)) FORMAT=YYMM7. AS Calculation FROM WORK.DATES t1; QUIT;   . 2016M01 2016M02 2016M03 2016M04 2016M05 2016M06 2016M07 2016M08 2016M09 2016M10 2016M11 2016M12 2017M01 2017M02 2017M03 2017M04 2017M05 2017M06 2017M07 2017M08 2017M09 2017M10 2017M11 2017M12 2018M01 2018M02 2018M03 2018M04 2018M05 2018M06 2018M07 The output is the same to the input but in format of a date YYMM7.   It is very dificult to work with dates. I had to pass to char because i want to filter duplicates. I had 2 times:  2018M07   but with a sort and keep only first observations SAS do not filter duplicates because this date have the day "hidden". That why am i want to change format to initial, YYMM7.   Regards, Aleixo ... View more

Hi,   I am using this code for import files. This code is a copy from another topic.   %let path=C:\My_SAS_PROJECTS; filename folder "&path\Data."; libname c 'C:\Temp'; /* just an example destination folder */ options validmemname=extend; /* to allow non-standard dataset names */ /* Making a list of all files in the folder */ data FilesInFolder; length Line 8 File $300; List = dopen('folder'); /* corrected the function argument */ do Line = 1 to dnum(List); File = trim(dread(List,Line)); output; end; drop list line; run; /* Creating global macro variables */ /* not "local" */ data _NULL_; set FilesInFolder end=final; call symput(cats('File', _N_), trim(File)); /* used CATS instead of COMPRESS (...||...) */ call symput(cats('Name', _N_), trim(nliteral(substr(File,1,min(32, length(File)-4))))); /* inserted */ if final then call symputx(trim('Total'), _N_); /* replaced symput by symputx */ run; /* This macro should import all files specified in the list and save them as datasets */ %macro loop; %do i = 1 %to &Total; proc import datafile="&path\Data\&&File&i" out=c.&&name&i /* adapted */ dbms=xlsx replace; getnames=yes; run; %end; %mend loop; %loop What i want is to named the output with name of file.   I am using this function to cut extension file, like xlsx. It is working for xlsx not for all extensions. But ok fine.   Nopath = substr(trim(dread(List,Line)), 1, length(trim(dread(List,Line))) -5)   It is not working.   /* This macro should import all files specified in the list and save them as datasets */ %macro loop; %do i = 1 %to &Total; proc import datafile="&path\Data\&&File&i" out=&&Nopath&i /* adapted */ dbms=xlsx replace; getnames=yes; run; %end; %mend loop; %loop    72 PROC IMPORT DATAFILE= ""&path\Data\&&File&i"  OUT=&&Nopath&i DBMS=XLSX replace; GETNAMES=YES; RUN; _ 76 ERROR 76-322: Syntax error, statement will be ignored.   I do not understand why is not working and produce several outputs with name of file.   Thanks ... View more

Hi,   I do not understand why SAS has a result different for same dates. Only format is different, date or datetime.   Why happen this? I need the format datetime21.3   %let tdate = %sysfunc(today(),date9.); %put &tdate.; %let dois_anos_fmt = %sysfunc(intnx(year, %sysfunc(today()), -2, same), date9.); %put &dois_anos_fmt.; result:    36 GOPTIONS ACCESSIBLE; 37 %let tdate = %sysfunc(today(),date9.); 38 %put &tdate.; 07MAY2018 39 40 %let dois_anos_fmt = %sysfunc(intnx(year, %sysfunc(today()), -2, same), date9.); 41 %put &dois_anos_fmt.; 07MAY2016   %let data_requerida = %sysfunc(today(),datetime21.3); %put &data_requerida.; %let data_dois_anos_menos = %sysfunc(intnx(year, %sysfunc(today()), -2, same), datetime21.3); %put &data_dois_anos_menos.; result:   55 %let data_requerida = %sysfunc(today(),datetime21.3); 56 %put &data_requerida.; 01JAN60:05:55:11.000 57 58 %let data_dois_anos_menos = %sysfunc(intnx(year, %sysfunc(today()), -2, same), datetime21.3); 59 %put &data_dois_anos_menos.; 01JAN60:05:43:01.000     Regards, Aleixo ... View more