topic Values from table to variable in Statistical Procedures

Values from table to variable

stanmarciano — Tue, 08 Sep 2015 20:00:28 GMT

Hi,

Could someone please tell me how to assign a set of variables, values from a table. I have a table of parameter estimates of a non linear regression and I want to pass the values of the estimates to the variables for a differetn set of calculation.

Debjit

Re: Values from table to variable

Reeza — Tue, 08 Sep 2015 20:25:49 GMT

I'm not sure what you're asking, can you please clarify your question.

Re: Values from table to variable

stanmarciano — Tue, 08 Sep 2015 20:37:36 GMT

I have a table of parameter estimates of variables. Lets call the variables a, b,c & d. I wish to know if there is a way to save the values of the parameter estimates of a, b, c, d in a set of different variables a1,b1,c1 & d1. I think my question is how to pass the values from a table to some other variables.

Re: Values from table to variable

ballardw — Tue, 08 Sep 2015 23:04:52 GMT

By table do you mean a SAS dataset? A table in a non-SAS data base or other electronic file? A table of values generated by somether software in a report? A printed document?

Re: Values from table to variable

KachiM — Wed, 09 Sep 2015 00:50:53 GMT

There may be elegant way for this. But a hardway is to use ods output and proc transpose as:

proc reg data = sashelp.class;
model weight = height age ;
ods output ParameterEstimates = param(keep = Estimate);
run;

proc transpose data = param out = see(keep =Col:);
run;

proc print data = see;
run;

Re: Values from table to variable

Rick_SAS — Wed, 09 Sep 2015 20:02:25 GMT

If you post your code, it will easier to know what you are trying to do.

One interpretation: You are running a regression and you get a parameter estimates table. You can write the table to a SAS data set by submitting the statement:

ods output ParameterEstimate; /* or whatever the table name is */

You can find the name of any ODS table produced by any SAS procedure.

After you have a SAS data set, you can use PROC TRANSPOSE and the RENAME statement in a DATA step to rename the variables.