How to use if statement inside the define in proc report

[mona4u]

Hi, 

I'm using proc report to produce a report and I need a way to count the number of "Y" in the column  

Site Approved (Y/N)

Y

Y

Y

Y

Y

Y

[PaigeMiller · Accepted solution]

Idea 1:

This could be done easily in a data step before PROC REPORT.

Idea 2:

If the value of the variable is 1 or 0, instead of Y or blank, then you could just sum up the columns in PROC REPORT

[mona4u]

I have same question I have dates in the columns and I need to count how many rows has dates on them I dont know how to use if stament to count one each time there is a date value 

Date Physical Submission Start Up Kit Sent to Site

6-Jun-17

28-Jul-17

12-May-17

6-Sep-17

8-Jun-17

13-Jul-17

N/A

23-May-17

[PaigeMiller]

In a data step

if not missing(date) then count+1;