DATA Step, Macro, Functions and more

PROC SQL select into char variable

Accepted Solution Solved
Reply
Contributor
Posts: 32
Accepted Solution

PROC SQL select into char variable

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


Accepted Solutions
Solution
‎05-13-2018 08:11 PM
Super User
Posts: 2,061

Re: PROC SQL select into char variable

[ Edited ]
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 

View solution in original post


All Replies
Solution
‎05-13-2018 08:11 PM
Super User
Posts: 2,061

Re: PROC SQL select into char variable

[ Edited ]
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 

Contributor
Posts: 32

Re: PROC SQL select into char variable

Posted in reply to novinosrin
Thank you novinosrin, worked perfectly! Cheers, Mark
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 163 views
  • 1 like
  • 2 in conversation