topic Variable in ODS text in SAS Programming

Variable in ODS text

analyst_work — Tue, 07 Jun 2016 17:34:12 GMT

Hi,

I am trying to include a numeric variable in an ODS text statement. Is there a way to do that?

The code is something like this:

ods text= "^S={just=l} Note: [xxx] subjects are missing data at this time."

I want to substitute the variable count in place of the Xs.

It is part of a macro code and hence do not want to hard code it.

Thanks,

Neha.

Re: Variable in ODS text

Reeza — Tue, 07 Jun 2016 17:38:33 GMT

Create a macro variable that holds the value and then use it in the text.

proc sql noprint;
select count(*) into :n_count from have where missing(var);
quit;

ods text  = "^S={just=l} Note: [&n_count.] subjects are missing data at this time."

Re: Variable in ODS text

analyst_work — Tue, 07 Jun 2016 17:57:06 GMT

Could you please explain this code?

##- Please type your reply above this line. Simple formatting, no
attachments. -##

Re: Variable in ODS text

Reeza — Tue, 07 Jun 2016 18:03:59 GMT

Proc sql creates the macro variable that contains the count. You can use a different method to create the macro variable.

The ODS text statement uses the macro variable.

Re: Variable in ODS text

analyst_work — Tue, 07 Jun 2016 18:09:21 GMT

I tried the code and its working, but I am getting parenthesis around the numbers which I don't want. Also, is it possible to get the numbers in words?

Re: Variable in ODS text

Reeza — Tue, 07 Jun 2016 18:20:56 GMT

The brackets were in your ODS text statement. Remove them.

To get them as words use the WORDS. format.

proc sql noprint;
select put(count(*), words.) into :n_count from have where missing(var);
quit;

Re: Variable in ODS text

analyst_work — Tue, 07 Jun 2016 18:31:41 GMT

Perfect! Getting them in words now without the parenthesis, but the formatting isnt very accurate:

ten subjects not included

How do I get rid of the space and can I capitalize the first letter?

Re: Variable in ODS text

analyst_work — Tue, 07 Jun 2016 19:37:53 GMT

Also, the code does not output zero. Is there a way to fix this?

Re: Variable in ODS text

ballardw — Tue, 07 Jun 2016 19:42:25 GMT

Quick and dirty:

%let n_count=0;

just before the SQL that does the count.