topic Re: Help determining frequency of coded entries within variables. in SAS Procedures

Help determining frequency of coded entries within variables.

5imon — Sun, 04 Nov 2018 03:31:18 GMT

I have a dataset that includes multiple diagnosis codes in one ";" delimited variable sorted by patient and year.

For example.

Patient Year Codes

1 18 0123;4444;2346;0912

2. 17 1234;4444

3 17 0912

4 16 0123;2346;0912

5 15 4444

I would like to know the frequency of the individual codes grouped by year without having to manually enter all of the codes.

Example output

2015 2016 2017 2018 Total

0123 n n n n n

4444

2346

0912

I have tried with proc freq but it will not look within the strings. Proc tabulate will work but only if I manually enter each code.

Any help with a more efficient way of doing this?

Any help would be appreciated.

Simon

Re: Help determining frequency of coded entries within variables.

novinosrin — Sun, 04 Nov 2018 03:49:24 GMT

transpose using scan of codes one by one

proc summary/freq using yearcodes

then transpose again

Re: Help determining frequency of coded entries within variables.

Ksharp — Sun, 04 Nov 2018 10:38:23 GMT

data have;
input Patient  Year      Codes $40.;
cards4;
1             18         0123;4444;2346;0912
2         17          1234;4444
3            17          0912
4            16          0123;2346;0912
5            15          4444
;;;;
run;

data temp;
 set have;
 do i=1 to countw(Codes,';');
   code=scan(Codes,i,';');output;
 end;
run;

proc tabulate data=temp;
class year code;
table code=' ',year=' '*n all='Total';
keylabel n=' ';
run;

Re: Help determining frequency of coded entries within variables.

Astounding — Sun, 04 Nov 2018 14:37:56 GMT

Also note, the form in which you have stored your data is relatively useless. Take a good look at the form that comes out of @Ksharp's DATA step. That would be much more flexible for both calculating and reporting.