topic Re: format assignment for computedvars in cas actions in SAS Programming

format assignment for computedvars in cas actions

acordes — Thu, 15 Dec 2022 12:50:22 GMT

I want the newly created variable "combi" to hold the complete string, but it cuts off at length 8.

proc cas;
   session mysession;
   simple.topk /                           
      inputs={"from_gama_agg", "combi"}, topk=5 bottomk=0  aggregator="n"     
      table={
         name="LONGDRIVE_TS", CASLIB="onair"
         where="_FECFACTU=_FULTPATA", 
         computedVars={{name="combi", format='$char44.'}},
         computedVarsProgram="combi=ifc(modsermt in ('D1' 'D2'), 'Mto & desgaste', 'Mto')",                     
         groupBy={"from_brand"}};
run;
quit;

Re: format assignment for computedvars in cas actions

SASJedi — Mon, 19 Dec 2022 13:35:54 GMT

This can be fixed by adding a LENGTH statement to your COMPUTEDVARSPROGRAM, something like this:

proc cas;
   session mysession;
   simple.topk /                           
      inputs={"from_gama_agg", "combi"}, topk=5 bottomk=0  aggregator="n"     
      table={
         name="LONGDRIVE_TS", CASLIB="onair"
         where="_FECFACTU=_FULTPATA", 
         computedVars={{name="combi", format='$char44.'}},
         computedVarsProgram="length combi varchar(44); combi=ifc(modsermt in ('D1' 'D2'), 'Mto & desgaste', 'Mto')",                     
         groupBy={"from_brand"}};
run;
quit;

Re: format assignment for computedvars in cas actions

Tom — Mon, 19 Dec 2022 19:08:08 GMT

Is there some reason you attached the $CHAR format to the variable? Does it have leading spaces that you want SAS to preserve when it prints the values?