PROC SQL select into char variable

markc — Sun, 13 May 2018 23:43:33 GMT

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

Re: PROC SQL select into char variable

novinosrin — Sun, 13 May 2018 23:57:07 GMT

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

Re: PROC SQL select into char variable

markc — Mon, 14 May 2018 00:11:28 GMT

Thank you novinosrin, worked perfectly! Cheers, Mark

topic PROC SQL select into char variable in SAS Programming

PROC SQL select into char variable

Re: PROC SQL select into char variable

Re: PROC SQL select into char variable