How do I export a value in a dataset as a macro value to add to a ods text?

Tpham — Thu, 21 Jun 2018 18:37:49 GMT

So basically i have a value (0.126) that I outputted using the out statement from a procedure. It's outputted into a dataset and looks pretty much like this right now:

data have;
infile datalines dsd;
input value label ~ $ 200. ;
datalines;
0.126,XXXX
;
run;

Basically I want to use that 0.126 as a macro value, basically this is what I want:

%let value=0.126;

title "Blah blah blah value=&value";
ods rtf prepage="Blah blah blah value=&value";

Wanted Output from ODS text:

Blah blah blah value=0.126

The disconnect right now, I am unsure how to export the 0.126 into the macro variable value from a dataset, so I can use it in the ODS text above.

I have to do this multiple times for a lot of analyses, so I am trying to build this code somehow into my current macro.. I am unsure if it is possible?

Re: How do I export a value in a dataset as a macro value to add to a ods text?

Kurt_Bremser — Thu, 21 Jun 2018 18:39:38 GMT

Use call symput().

topic How do I export a value in a dataset as a macro value to add to a ods text? in SAS Programming

How do I export a value in a dataset as a macro value to add to a ods text?

Re: How do I export a value in a dataset as a macro value to add to a ods text?