turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Find a Community

- Home
- /
- SAS Programming
- /
- SAS/GRAPH and ODS Graphics
- /
- Regression with restricted cubic splines

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

07-26-2017 06:19 PM

Hi all,

I want to graph the spline functions, so I create a data set to store spline basis functions, and I got the data set that is below. The issue is when I want to call the spl1-spl4 variables (In the data set appear like spl 1 spl 2 spl 3 and spl 4). The program doesn't recognize any form to call them (nor spl 1 spl 2 spl 3 spl4 neither spl_1 spl_2 spl_3 spl_4). Can anyone help me?

/* Create SplineBasis = data set that contains spline basis functions */
proc glmselect data=merged0811dersesdiet outdesign(addinputvars fullmodel)=SplineBasis;
effect spl = spline(lactationbypar / naturalcubic basis=tpf(noint) knotmethod=percentiles(5));
model weightchange2 = spl / selection=none;
quit;
proc sgplot data=SplineBasis;
series x=lactationbypar y=spl1;
series x=lactationbypar y=spl2;
series x=lactationbypar y=spl3;
series x=lactationbypar y=spl4;
run;

Thanks,

Accepted Solutions

Solution

07-26-2017
11:42 PM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to mmazariegos

07-26-2017 06:58 PM - edited 07-26-2017 06:59 PM

Run a proc contents and verify the variable name and label. You need the name. If the name happens to have spaces, then wrap it in qutoes and add an N at the end.

`'SP 1'n`

mmazariegos wrote:

Hi all,

I want to graph the spline functions, so I create a data set to store spline basis functions, and I got the data set that is below. The issue is when I want to call the spl1-spl4 variables (In the data set appear like spl 1 spl 2 spl 3 and spl 4). The program doesn't recognize any form to call them (nor spl 1 spl 2 spl 3 spl4 neither spl_1 spl_2 spl_3 spl_4). Can anyone help me?

/* Create SplineBasis = data set that contains spline basis functions */ proc glmselect data=merged0811dersesdiet outdesign(addinputvars fullmodel)=SplineBasis; effect spl = spline(lactationbypar / naturalcubic basis=tpf(noint) knotmethod=percentiles(5)); model weightchange2 = spl / selection=none; quit; proc sgplot data=SplineBasis; series x=lactationbypar y=spl1; series x=lactationbypar y=spl2; series x=lactationbypar y=spl3; series x=lactationbypar y=spl4; run;

Thanks,

All Replies

Solution

07-26-2017
11:42 PM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to mmazariegos

07-26-2017 06:58 PM - edited 07-26-2017 06:59 PM

Run a proc contents and verify the variable name and label. You need the name. If the name happens to have spaces, then wrap it in qutoes and add an N at the end.

`'SP 1'n`

mmazariegos wrote:

Hi all,

I want to graph the spline functions, so I create a data set to store spline basis functions, and I got the data set that is below. The issue is when I want to call the spl1-spl4 variables (In the data set appear like spl 1 spl 2 spl 3 and spl 4). The program doesn't recognize any form to call them (nor spl 1 spl 2 spl 3 spl4 neither spl_1 spl_2 spl_3 spl_4). Can anyone help me?

/* Create SplineBasis = data set that contains spline basis functions */ proc glmselect data=merged0811dersesdiet outdesign(addinputvars fullmodel)=SplineBasis; effect spl = spline(lactationbypar / naturalcubic basis=tpf(noint) knotmethod=percentiles(5)); model weightchange2 = spl / selection=none; quit; proc sgplot data=SplineBasis; series x=lactationbypar y=spl1; series x=lactationbypar y=spl2; series x=lactationbypar y=spl3; series x=lactationbypar y=spl4; run;

Thanks,

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to Reeza

07-26-2017 11:44 PM

Thank you very much Reeza, It works!

`'spl 1'n`