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 |
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
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
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 |
In a data step
if not missing(date) then count+1;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.