topic Re: Counting the number of items within same date in SAS Programming

Counting the number of items within same date

strqimr — Fri, 11 May 2018 08:44:19 GMT

Hi guys,

I am working on a dataset with participants having multiple rows.

I want to know if any participant have used a specific medicare item number more than once in a same day. For example participant T10002 have used "36" twice in the same date (3rd and 4th rows).

Thanks mates

Re: Counting the number of items within same date

jklaverstijn — Fri, 11 May 2018 10:32:53 GMT

In SQL (there are other ways) this would be:

proc sql;
   select participant_id, medicare_item_number, date_of_service, count(date_of_service)
   from have
   group by participant_id, medicare_item_number, date_of_service
   having count(date_of_service) > 1;

quit;

Hope this helps,- Jan.

Re: Counting the number of items within same date

KentaMURANAKA — Fri, 11 May 2018 11:04:15 GMT

How about

data test;
    input subject$ med item$ date$;
    datalines;
    T10002 23 A1 8/3/2009
    T10002 23 A1 10/26/2009
    T10002 36 A1 12/9/2009
    T10002 36 A1 12/9/2009
    T10002 110 A4 12/16/2009
    T10002 116 A4 1/12/2009
    ;
run;
proc sort data=test out=test_1;
    by subject item date;
run;
proc freq data=test_1 noprint;
    tables med / out=cnt;
    by subject item date;
run;

Re: Counting the number of items within same date

ballardw — Fri, 11 May 2018 14:26:06 GMT

Do you want a data set, something that goes into other procedures for analysis, or a report for humans? Do want to see the counts of everything or only the cases where there are two or more of the item on the same date?

And are your "dates" actually SAS date values or just character variables that look like dates?

Re: Counting the number of items within same date

strqimr — Sun, 13 May 2018 23:38:47 GMT

Thanks

Re: Counting the number of items within same date

strqimr — Sun, 13 May 2018 23:39:51 GMT

Thanks