PROC SQL select into char variable

[markc]

Hello,

I have set up a format for a particular variable, along these lines:

proc format;
          value cost_range
          .                  =         "$0-$5,000"
          0-5000             =         "$0-$5,000"
          5001-10000         =         "$5,001-$10,000";
run;

The underlying variable above is obviously numeric; however, I want to be able to assign the resulting format as a character string to another variable at the same time I do a PROC SQL when creating a table.

For example, I want cost_range_char to actually store $0-$5000 as a character string using this syntax (which is obviously not correct);

proc sql;
 create table new_table as
  select a.*, 
    a.budget as cost_range_char format put(cost_tange_char,cost_band_more_grps.)
   from table1 as a;

quit;

Any advice will be appreciated and liked promptly.

Kind regards,

Mark

[novinosrin · Accepted solution]

proc sql;
 create table new_table as
  select a.*,   put(a.budget,cost_band_more_grps.)
    as cost_range_char 
   from table1 as a;

quit;

basically put(var,formatname.) as newvar 

[markc]

Thank you novinosrin, worked perfectly! Cheers, Mark