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
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
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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.