## Proc report

Hi,

I have a dataset composed of 1 character (name) and 3 numeric variables (a b N_obs). I want to change a and b values to N/A if N_obs is lower than 10 and name = "X".

Here is my code:

``````proc report nowd data = data;
column (name a b);
define name / display "Name";
define a / display "A";
define B / display "B";
compute A;
if name = "X" and N_obs <= 10 then A = "N/A";
endcomp;
compute B;
if name = "X" and N_obs <= 10 then B = "N/A";
endcomp;
%end;
run;``````

Yet, if name = X and N_obs <= 10 then it gives me A and B = .

I guess this is because A and B are numeric variables. But, would there be a way to replace by N/A instead of .?

1 ACCEPTED SOLUTION

Accepted Solutions

## Re: Proc report

You can't give a character value to a numeric variable. You ought to assign a format to A and B when they are missing, and the format should make the missing appear as "N/A".

I think another problem is that n_obs is not listed in the COLUMNS statement.

UNTESTED CODE

``````proc format;
value myfmt .='N/A' ;
run;
proc report nowd data = data;
column (name n_obs a b);
define name / display "Name";
define n_obs/display noprint;
define a / display "A" format=myfmt.;
define B / display "B" format=myfmt.;
compute A;
if name = "X" and N_obs <= 10 then A = .;
endcomp;
compute B;
if name = "X" and N_obs <= 10 then B = .;
endcomp;
%end;
run;``````
--
Paige Miller
3 REPLIES 3

## Re: Proc report

You can't give a character value to a numeric variable. You ought to assign a format to A and B when they are missing, and the format should make the missing appear as "N/A".

I think another problem is that n_obs is not listed in the COLUMNS statement.

UNTESTED CODE

``````proc format;
value myfmt .='N/A' ;
run;
proc report nowd data = data;
column (name n_obs a b);
define name / display "Name";
define n_obs/display noprint;
define a / display "A" format=myfmt.;
define B / display "B" format=myfmt.;
compute A;
if name = "X" and N_obs <= 10 then A = .;
endcomp;
compute B;
if name = "X" and N_obs <= 10 then B = .;
endcomp;
%end;
run;``````
--
Paige Miller

## Re: Proc report

Hi:
You CANNOT test N_OBS if it is not on the COLUMN statement -- PROC REPORT only has visibility of the variables on the COLUMN statement -- it has NO visibility of variables in the data set. If you want to use a variable, but not show the variable, then you use the NOPRINT option on the DEFINE statement.

Also, the placement of your %end is troublesome because this implies that there is more to your code than you're showing.

Also, since NAME is to the left of A and B in the COLUMN statement, you can test NAME in the COMPUTE blocks, but you cannot test N_OBS unless it were also to the LEFT of A and B:
column name n_obs a b;

And, if N_OBS is numeric, which your code implies, then N_OBS would have to also have a usage of DISPLAY in the DEFINE statement in order for your existing code to work.

Without data, no one can run your code. And with the %end there, your code would cause an error message anyway. And, I completely missed that A and B were numeric...you'll have to make that change with a user defined format and a CALL DEFINE statement.

Cynthia

## Re: Proc report

Why is there an %END statement in there?

Discussion stats
• 3 replies
• 833 views
• 4 likes
• 4 in conversation