format _numeric_ _character_ in cas actions possible?

acordes — Fri, 25 Mar 2022 12:27:46 GMT

I'd like to convert this program to a cas action like freqtab. Can I use the _numeric_ shortcut in an cas action?

Have:

proc format;
value $ missfmt ' '="Missing" other="Not Missing";
value nmissfmt .="Missing" other="Not Missing";
run;
*Proc freq to count missing/non missing;
options casdatalimit=all;
ods table onewayfreqs=temp;
proc freq data=MKT.PROFILE_PORTFOLIO;
table _all_ / missing;
format _numeric_ nmissfmt. _character_ $missfmt.;
run;

Want:

proc cas;
   action freqTab.freqTab /
      table={name='PROFILE_PORTFOLIO', caslib="mkt", 
....

Re: format _numeric_ _character_ in cas actions possible?

JOL — Wed, 15 Jun 2022 19:30:31 GMT

No, it does not appear possible to use special name lists and the documentation does not seem to support it.

Some tips:

Add user-defined formats to CAS with the CASFMTLIB option:

proc format CASFMTLIB = "CASFORMATS"; value $ missfmt ' '="Missing" other="Not Missing"; value nmissfmt .="Missing" other="Not Missing"; run;

Apply formats with the ALTERTABLE action:

proc cas; table.altertable / columns{{name = "Var1", format = "$missfmt." {name = "Var2", format = "nmissfmt."}}, name='PROFILE_PORTFOLIO'; action freqTab.freqTab / table={name='PROFILE_PORTFOLIO', caslib="mkt", ...

Documentation:

Manage Your User-Defined Formats

Applying Labels and Formats

topic Re: format _numeric_ _character_ in cas actions possible? in SAS Programming

format _numeric_ _character_ in cas actions possible?

Re: format _numeric_ _character_ in cas actions possible?