I'm generating code like this for all variables of all the datasets of a given library.
I cannot know beforehand waht format will be used, if any.
ods output Tabulate.Report.Table=SHOES_FREQ;
proc tabulate data=sashelp.SHOES;
class Sales / preloadfmt missing;
table Sales / printmiss;
run;
My original idea was to look at the format variable in the metadata to decide if the preloadfmt was to be used in proc tabulate.
proc sql;
select name, format
from dictionary.columns
where upcase(libname)='SASHELP' and
upcase(memname)='SHOES';
quit;
But logically, it won't work for generic formats provided by the SAS system. It is fine for me.
Option 1 would be to find a way to identify if the format is relevant or not beforehand. Any idea how? Option 2 would be to set a global option to nowarn to avoid the warning in that case. Does such solution exists?
Option 3?
... View more
