topic Re: How to Create a New Variable Based on Frequency in SAS Programming

Re: How to Create a New Variable Based on Frequency

heatherjae15 — Fri, 25 Oct 2019 17:00:12 GMT

I need help creating a variable for number enrolled. I need a table that has

siteID siteName number enrolled. How can I create a variable that will count each patient so the frequencies turn out correctly?

Thanks

Re: How to Create a New Variable Based on Frequency

PeterClemmensen — Fri, 25 Oct 2019 17:11:08 GMT

@heatherjae15 Hi and welcome to the SAS Community.

Are you able to post some example of what your data looks like along with the desired result based on that data? Makes it much easier to provide a usable code answer.

Re: How to Create a New Variable Based on Frequency

Reeza — Fri, 25 Oct 2019 17:13:49 GMT

/*This demonstrates how to count the number of unique occurences of a variable
across groups. It uses the SASHELP.CARS dataset which is available with any SAS installation.
The objective is to determine the number of unique car makers by origin/
Note: The SQL solution can be off if you have a large data set and these are not the only two ways to calculate distinct counts.
If you're dealing with a large data set other methods may be appropriate.*/

*Count distinct IDs;
proc sql;
create table distinct_sql as
select origin, count(distinct make) as n_make
from sashelp.cars
group by origin;
quit;

*Double PROC FREQ;
proc freq data=sashelp.cars noprint;
table origin * make / out=origin_make;
run;

proc freq data=origin_make noprint;
table origin / out= distinct_freq;
run;

title 'PROC FREQ';
proc print data=distinct_freq;
run;
title 'PROC SQL';
proc print data=distinct_sql;
run;

https://github.com/statgeek/SAS-Tutorials/blob/master/count_distinct_by_group.sas

@heatherjae15 wrote:

I need help creating a variable for number enrolled. I need a table that has

siteID siteName number enrolled. How can I create a variable that will count each patient so the frequencies turn out correctly?

Thanks

Re: How to Create a New Variable Based on Frequency

heatherjae15 — Fri, 25 Oct 2019 17:38:10 GMT

I cant post the data. I currently have sitename and siteId. I need to make a table that shows siteID, sitename and enrolled subjects. so it is a 3 column table with the siteid sitename and number of enrolled subjects.

Re: How to Create a New Variable Based on Frequency

Kurt_Bremser — Fri, 25 Oct 2019 17:43:00 GMT

@heatherjae15 wrote:
I cant post the data. I currently have sitename and siteId. I need to make a table that shows siteID, sitename and enrolled subjects. so it is a 3 column table with the siteid sitename and number of enrolled subjects.

Don't post actual sensible data. Make up a few observations with fake data, just enough to illustrate your issue. Post as data step with datalines.

Don't force us to make guesses, help us to help you.

Re: How to Create a New Variable Based on Frequency

PaigeMiller — Fri, 25 Oct 2019 17:46:32 GMT

@heatherjae15 wrote:
I cant post the data. I currently have sitename and siteId. I need to make a table that shows siteID, sitename and enrolled subjects. so it is a 3 column table with the siteid sitename and number of enrolled subjects.

proc freq data=have;
    table sitename*siteid/list;
run;

This implies that the input data has one record per patient. If that's not the case, then you need to state more about how the data is organized, and follow the advice of @Kurt_Bremser above.

Re: How to Create a New Variable Based on Frequency

heatherjae15 — Fri, 25 Oct 2019 17:51:19 GMT

This creates a diagonal. I just want the variables siteID sitename with
the number of pts enrolled

Re: How to Create a New Variable Based on Frequency

PaigeMiller — Fri, 25 Oct 2019 18:01:24 GMT

You need the LIST option, as I showed in my code.

Re: How to Create a New Variable Based on Frequency

heatherjae15 — Fri, 25 Oct 2019 18:25:16 GMT

Ohhh, thank you

Re: How to Create a New Variable Based on Frequency

heatherjae15 — Fri, 25 Oct 2019 18:30:05 GMT

Paige, I am getting an error that says it can't find my data. Any thoughts?

Re: How to Create a New Variable Based on Frequency

PaigeMiller — Fri, 25 Oct 2019 18:32:06 GMT

show us the LOG from your code, not just the ERROR messages, but the code as it appears in the log, plus the error messages.

Please click on the {i} icon and paste the log AS TEXT into the window that appears. Do not skip this step.

Re: How to Create a New Variable Based on Frequency

heatherjae15 — Fri, 25 Oct 2019 18:32:34 GMT

I fixed that now how do I remove the percent, cum frequency and cum percent?

Re: How to Create a New Variable Based on Frequency

PaigeMiller — Fri, 25 Oct 2019 18:36:43 GMT

@heatherjae15 wrote:
I fixed that now how do I remove the percent, cum frequency and cum percent?

proc freq data=have;
    table sitename*siteid/list nocum nopercent;
run;

You might want to look at the PROC FREQ documentation to see the wide variety of options available.

https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.4&docsetId=procstat&docsetTarget=procstat_freq_toc.htm&locale=en