topic Re: Characters count across many columns in the dataset in SAS Programming

Characters count across many columns in the dataset

Sujithpeta — Wed, 29 Mar 2017 14:06:25 GMT

Hello,

DATA A.IP_Bene;
SET "/sas/raw4/WD1/ccaei121.sas7bdat";
	ARRAY ICD {15} DX1-DX15;
	DO i = 1 to 15;
		IF ICD {i} in ("45341", "45340", "45342", "45350", "45351", "45352", "45181", "45111", "45119", "41511", "41512", "41513", "41519") THEN DO; 
		OUTPUT; 
		LEAVE; 
		END;
	END;
RUN;

Above SAS code creates a dataset whos row have any of these strings ("45341", "45340", "45342", "45350", "45351", "45352", "45181", "45111", "45119", "41511", "41512", "41513", "41519") across 15 columns in the dataset.

How can I modify this code so that I can get count(No.of times the value appeared in the 15 columns) as following:

Description Count

45341 X

45340 Y

45342 Z

and so on....

Thanks

--Sujith

Re: Characters count across many columns in the dataset

art297 — Wed, 29 Mar 2017 14:14:31 GMT

Do you want the overall counts for the file OR separately for each record?

Art, CEO, AnalystFinder.com

Re: Characters count across many columns in the dataset

Sujithpeta — Wed, 29 Mar 2017 14:22:52 GMT

Overall Counts in the file.

Thanks

Re: Characters count across many columns in the dataset

art297 — Wed, 29 Mar 2017 14:28:52 GMT

The following modification of your current code would do what you want:

DATA for_count (keep=_icd rename=(_icd=icd));
  SET ccaei121;
  ARRAY ICD {15} DX1-DX15;
  DO i = 1 to 15;
    IF ICD {i} in ("45341", "45340", "45342", "45350", "45351", "45352", "45181", "45111", "45119", "41511", "41512", "41513", "41519") THEN DO; 
      _icd=icd(i);
      OUTPUT; 
    END;
  END;
RUN;

proc freq data=for_count;
  tables icd;
run;

Art, CEO, AnalystFinder.com