topic Re: Output as a SAS data set in SAS Programming

Output as a SAS data set

Abimal_Zippi — Tue, 16 Feb 2021 04:49:27 GMT

How to write an interaction between a B-spline basis function and a continuous variable to a SAS data set?

Re: Output as a SAS data set

andreas_lds — Tue, 16 Feb 2021 06:08:19 GMT

What would you expect to be stored in the dataset?

Re: Output as a SAS data set

ballardw — Tue, 16 Feb 2021 09:15:44 GMT

Please at least show the code used to create the B-spline values or function so we have some of chance of providing a solution that uses the approach you used.

Re: Output as a SAS data set

Abimal_Zippi — Tue, 16 Feb 2021 10:24:51 GMT

proc transreg data=have design;
model bspl(x / nknots=2);
id id amount;
output out=spline_design;
run;

Re: Output as a SAS data set

Abimal_Zippi — Tue, 16 Feb 2021 10:31:46 GMT

proc transreg data=have design;
model bspl(x / nknots=2); 
id id amount;
output out=spline_design;
run;

I wanted to store the interaction between spl(x) and amount into SAS data set.

Re: Output as a SAS data set

Ksharp — Tue, 16 Feb 2021 11:43:18 GMT

Try PROC GLMSELECT.
https://communities.sas.com/t5/Japan-SAS-Discussion/%E9%87%8D%E5%9B%9E%E5%B8%B0%E5%88%86%E6%9E%90%E3%81%AEspline%E3%81%AE%E5%9B%B3%E7%A4%BA%E3%81%AE%E6%96%B9%E6%B3%95%E3%81%AB%E3%81%A4%E3%81%84%E3%81%A6/m-p/715534#M451

Re: Output as a SAS data set

Abimal_Zippi — Tue, 16 Feb 2021 13:00:23 GMT

The goal is to output the interaction as a design matrix, not an analysis of the spline effect of a predictor in the model.

Re: Output as a SAS data set

Ksharp — Tue, 16 Feb 2021 14:05:40 GMT

Check option OUTDESIGN= :

proc glmselect data=cars outdesign(addinputvars fullmodel)=SplineBasis;