how to list png and html files in caslib via code

acordes — Thu, 10 Mar 2022 15:13:00 GMT

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;

Re: how to list png and html files in caslib via code

HarrySnart — Fri, 11 Mar 2022 09:17:33 GMT

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

topic Re: how to list png and html files in caslib via code in SAS Programming

how to list png and html files in caslib via code

Re: how to list png and html files in caslib via code