A few years back, I had to automate the download of attachments from certain emails for a data processing project. Like you, I started with VB code and a rule in Outlook. It worked fine for a while but sometimes skipped emails or didn’t trigger reliably, which was super frustrating.What saved me was looking into Outlook add ins. I found one that handled attachments more effectively—it could automatically download and even rename files based on email content. This freed me from worrying about Outlook’s rules acting up. Once I integrated it with my scripts, everything flowed smoothly. ... View more

i'm having troubles with the same error ... View more

@Abelp9 wrote: Ok, sorry, I start from this idea in which I join 5 tables in another called output, they are 5 different tables but they all correspond to the month of February:   data OUTPUT; set ST.TABLEA1 ST.TABLEB1 ST.TABLEC1 ST.TABLED1 ST.TABLEF1; run; So, I want to add a condition that checks if these tables exist, and if any of them don't exist, it takes the table from the previous month (from the one that doesn't exist ending in 1 that it takes the one that ends in 2)   And I've started testing with this: data OUTPUT; if exist('ST.TABLEA1') then do; set ST.TABLEA1; end; else do; set ST.TABLEA2; end; run; And it returns this error "ERROR: The file ST.TABLEA1.DATA does not exist."   I would like to leave it something like this, but these conditionals inside a data step don't work for me data OUTPUT; if exist('ST.TABLEA1') then do;set ST.TABLEA1;end;else do;set ST.TABLEA2;end; if exist('ST.TABLEB1') then do;set ST.TABLEB1;end;else do;set ST.TABLEA2;end; if exist('ST.TABLEC1') then do;set ST.TABLEC1;end;else do;set ST.TABLEA2;end; if exist('ST.TABLED1') then do;set ST.TABLED1;end;else do;set ST.TABLEA2;end; if exist('ST.TABLEF1') then do;set ST.TABLEF1;end;else do;set ST.TABLEA2;end; run; If your data sets may have differing numbers of observations then you want to be very careful about involving multiple SET statements as they may behave quite differently than you expect. A brief example;   data one; input x; datalines; 1 2 3 4 ; data two; input y; datalines; 11 22 33 ; data example; set one; set two; run; Set One above has 4 observations, set Two has 3 observations. Before running code guess how many observations will be in the output? If you guess anything other than 3 you have a problem. And if ANY of those data sets have the same variables you may have problems with the actual values in the result compared with what you expect/need. ... View more

Hola Abel, You will probably have to provide a bit more details. I assume you're using SAS StudioV available through the menu option "Develop SAS Code". If yes are you just assigning caslibs to SAP HANA or is your code more complex? Saludos, Jos ... View more

This is a community for a SAS Institute product called Visual Analytics. You appear to be asking about  SAP Analytics Cloud, which is a different company's product.  ... View more

It works, thank you very much ... View more

The QUOTE() function has an optional second parameter that allows you to specify which quote character to use.  QUOTE(string,"'") If you want to make a quoted list of digit strings from your list of numbers you can do it in one macro variable. 160 digit strings of 8 digits each with quotes and separator will take 160*(8+2+1) = 1760 bytes.   So you could do this in the step that generates the macro variable. data _null_; set TABLE_WITH_DAYS end=eof; length list $2000 ; retain list; list = catx(',',list,quote(cats(day),"'")); if eof then call symputx('daylist',list'); run; Which you could then use to subset your dataset that has the character variable the with the "day" digit strings. data want; set have ; where char_day in (&daylist); run;     ... View more

https://gist.github.com/statgeek/d583cfa992bf56da51d435165b07e96a   *create sample data for demonstration; data have; infile cards dlm='09'x; input OrgID Product $ States $; cards; 1 football DC 1 football VA 1 football MD 2 football CA 3 football NV 3 football CA ; run; *Sort - required for both options; proc sort data=have; by orgID; run; **********************************************************************; *Use RETAIN and BY group processing to combine the information; **********************************************************************; data want_option1; set have; by orgID; length combined $100.; retain combined; if first.orgID then combined=states; else combined=catx(', ', combined, states); if last.orgID then output; run; **********************************************************************; *Transpose it to a wide format and then combine into a single field; **********************************************************************; proc transpose data=have out=wide prefix=state_; by orgID; var states; run; data want_option2; set wide; length combined $100.; combined=catx(', ', of state_:); run; ... View more

I have a pre-canned macro for this named filemove. You can get it like this: /* Grab a copy of the filemove macro */ %let thisMacro=filemove; filename mCode "c:\temp\%qlowcase(&thisMacro).sas"; proc http url="https://raw.githubusercontent.com/SASJedi/sas-macros/master/%qlowcase(&thisMacro).sas" out=mcode; run; %include mcode /source2; filename mcode; %&thismacro(?) The macro call with the question mark writes documentation to the log:   NOTE: FILEMOVE documentation: Purpose: Move a file from one directory to another Syntax: %FILEMOVE(fileName, sourcePath,targetPath<,newFileName>) fileName: Name of the file to be copied sourcePath: path where the source file is located targetPath: path to which the file will be moved newFileName: OPTIONAL: New name for the copied file Examples: %FILEMOVE(abc.txt,c:\temp\source,c:\temp\target) %FILEMOVE(old.csv,c:\temp\source,c:\temp\target,new.csv) Use ? to print documentation to the SAS log.    To copy your file from one directory to another, something like this would do: %fileMove(XDF_&column._&date._XDF_M2_&month..xlsx ,/opt/sas/data/xxx/xx/xx/xxx/FinalFolder ,/opt/sas/data/xx/xx/xx/xx/BridgeFolder);   ... View more