PROC SQL; /* SELECT Strip(Left(fnd)) INTO :fnd1 -:fnd&fnd_count. Trimmed FROM BS_RAW1 ; */ select trimn(fnd) into :fnd1 -:fnd&fnd_count. FROM BS_RAW1 ; /* SELECT prk_fund INTO :fnd1 -:fnd&fnd_count. Trimmed F
the table name then you can make the code include whatever logic is needed to transform the value into the table name. proc sql noprint;select order_group into :tablename trimmed from table_one ; create table want as select * from &tablename ; quit; 0 Likes Reply big1030 ...
18 select max(age) into :a1 trimmed from sashelp.class; 19 %put a1=|&a1|; a1=|16| 20 quit; The original link is as: Regards, Haikuo 0 Likes nirugh4846 Calcite | Level 5 Re: How do you compress a macro variable created from within PROC SQL Posted 07-11-2014 ...
proc sql noprint; select sum(A_N_ALL) into :EthnicA trimmed from catdem where CAT = 1; select sum(B_N_ALL) into :EthnicB trimmed from catdem where CAT = 1; select sum(A_N_ALL) into :RaceA trimmed from catdem where CAT = 2; select sum(B_N_ALL) into :RaceB trimmed from ...
proc sql; create table allmeans2 as select a.provincia, a.varname, round(a.halfp, 2.5) as pct, a.mean as wmean label='Winsorized mean', b.mean as tmean label='Trimmed mean' from wmeans a, tmeans b where a.provincia=b.provincia & a.varname=b.varname & round(a.halfp,...
proc sql; create table allmeans2 as select a.provincia, a.varname, round(a.halfp, 2.5) as pct, a.mean as wmean label='Winsorized mean', b.mean as tmean label='Trimmed mean' from wmeans a, tmeans b where a.provincia=b.provincia & a.varname=b.varname & round(a.halfp,...