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

First step is eliminate the code generation so we can see what code you are trying to run more clearly. For example you posted this SQL step that appears to be trying to put code into a macro variable. *MACRO 1; proc sql noprint; select distinct cat("DATA I1_",&month.,"_",compress(&COLUMN.,,'kad'),"; set &TABLE.(where=(&COLUMN.='", &COLUMN.,"'));run; proc export data=I1_",&month.,"_", &COLUMN.," outfile='&out_path.","ST_", &column.,"_", &fecha., "_S_M7_",&month.,"' dbms=xlsx replace;sheet='SHEET 1';run; ;run")length=500 into :allsteps separated by ';' from &TABLE. quit; Let's see if we can figure out what code it is you are trying to create with that. Looks a lot like this might be it: data I1_MONTH_COLUMN-VALUE; set TABLE (where=(COLUMN="COLUMN-VALUE")); run; proc export data=I1_MONTH_COLUMN outfile="OUT_PATH/ST_COLUMN_FECHA_S_M7_MONTH" dbms=xlsx replace ; sheet='SHEET 1'; run; Where OUT_PATH, MONTH, FECHA, TABLE and COLUMN are actually being replaced by macro variable values, except in a few places where you are using the actual value of the variable that named by the value of the COLUMN macro variable.   There does not appear to be any need to make dataset.  Why not just add the dataset option to the PROC EXPORT call?   Now you mentioned wanting to combine the multiple spreadsheets you are generating.  What do you think that should look like?  Do you want to write all of the values of COLUMN to the same XLSX workbook, but just into separate sheets?  Or perhaps all of the sheets for that value of COLUMN into the same XLSX workbook but with different sheets for each value of MONTH?  Or perhaps each value of FECHA?   ... View more