how to list png and html files in caslib via code

[acordes]

It comes in handy to generate a proc casutil deletesource command for files in a caslib.

The %sashdat or csv option works as well. 

It works fine but I cannot "see" files of type png or html. 

How can I achieve this?

proc cas;
table.caslibinfo result=sss/caslib="mkt"  ;
table.fileinfo result=sss / path="%.xlsx caslib="mkt";
saveresult sss  dataout=work.xdata;
run;

proc sql;
    select catX(" ", 'deletesource casdata=', "'"||strip(name)||"'", ' ',  "incaslib='mkt'", " quiet;") into :str
    from work.xdata
where prxmatch("m/nom|denom|kpi/oi",name) or 1=1 order by name;
quit;

I then copy/paste the reult to a proc casutil step. 

proc casutil;
deletesource casdata= 'ALL_DENOMINADOR2.sashdat' incaslib='mkt' quiet;
deletesource casdata= 'CARTERA_2_CHECK_REMAPPED2.sashdat' incaslib='mkt' quiet;
deletesource casdata= 'CRISTAL_BALL.xlsx' incaslib='mkt' quiet;
run;

[HarrySnart · Accepted solution]

Hi @acordes you should be able to set the allFiles parameter to TRUE with the tables.fileInfo action