I am trying to insert values in a table that I create initially: proc sql;
create table blub.Name.
(ModelName char(10),
&s. char(10),
MN_&s. char(30),
/*Coefficients*/
parameter char format=$30. length=100,
DF num,
Estimate num,
StandardizedEst num,
StdErr num,
tValue num,
Probt num
);
run; Then I run a regression analysis: ods exclude all;
proc glmselect data=blub.name2
seed=1
;
partition fraction(validate=0.2);
by &s.;
model &y. =
&x. / selection=none;
output out=residual_dsn residual= r_dsn;
ODS OUTPUT FitStatistics=FitStatistics_DSN;
ODS OUTPUT ParameterEstimates=ParameterEstimates_DSN;
run;
*ods trace off;
ods exclude none; In the table ParameterEstimates_DSN are columns with same header as for the previously defined table, i.e. &s.,parameter, DF, Estimate, StandardizedEst, StdErr, tValue, Probt. I like to insert the values in my initial table: proc sql;
INSERT INTO blub.name (
&s.,
parameter,
DF,
Estimate,
StandardizedEst,
StdErr,
tValue,
Probt)
SELECT &s.,
parameter,
DF,
Estimate,
StandardizedEst,
StdErr,
tValue,
Probt
FROM PARAMETERESTIMATES_DSN;
run; However, when doing so the length of columns defined in the initial step are ignored and the value for parameter for example is cut off after a length of 20 even though I defined the length to be 100. Does anybody know how to fix this issue?
... View more
