topic Re: Question in New SAS User

Create data set w/ no of contacts per patient/month

11427qvolaf — Fri, 11 Jun 2021 08:53:20 GMT

The dataset Contacts is comprised of several entries for each subject (unique identifier is patient_number). You are asked to create a new dataset containing one row per patient with the number of contacts per month. What sample SAS or SQL code would be used to complete this request.

Re: Question

japelin — Fri, 11 Jun 2021 04:26:20 GMT

Is it possible to provide actual data or sample data that reflects the actual situation?

Re: Question

ballardw — Fri, 11 Jun 2021 06:12:55 GMT

@11427qvolaf wrote:

The dataset Contacts is comprised of several entries for each subject (unique identifier is patient_number). You are asked to create a new dataset containing one row per patient with the number of contacts per month. What sample SAS or SQL code would be used to complete this request.

Look at documentation for Procs Means, Summary, Freq, Report, Tabulate and SQL. All of these can create such a summary. The preferred choice might come with additional requirements.

Or tasks to COUNT.

Re: Question

Kurt_Bremser — Fri, 11 Jun 2021 08:18:36 GMT

Not to forget DATA steps with retained variables or a

do until (last.id);

loop for counting.