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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.