format assignment for computedvars in cas actions

[acordes]

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;

[SASJedi · Accepted solution]

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;

[Tom]

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?