topic How to use if statement inside the define in proc report in SAS Programming

How to use if statement inside the define in proc report

mona4u — Fri, 16 Feb 2018 16:50:28 GMT

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)

Re: How to use if statement inside the define in proc report

PaigeMiller — Fri, 16 Feb 2018 16:54:52 GMT

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

Re: How to use if statement inside the define in proc report

mona4u — Fri, 16 Feb 2018 18:11:00 GMT

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

Re: How to use if statement inside the define in proc report

PaigeMiller — Fri, 16 Feb 2018 18:33:53 GMT

In a data step

if not missing(date) then count+1;