topic Re: comma and countc in SAS Programming

comma and countc

pacman94 — Fri, 14 May 2021 00:09:11 GMT

I have the following dataset. if the value is blank I need the count variable to be to be blank. Otherwise count all the comma + 1

Have

ID	VALUE
ABC	2
CDE
EEA	2,3
AWE	4,5,6
DDE	5
QWE
WQE	5,3,2

Have:

iD	VALUE	count
ABC	2	1
CDE
EEA	2,3	2
AWE	4,5,6	3
DDE	5	1
QWE
WQE	5,3,2	3

Here's what I have

if missing(VALUE) then count = .;

else count = countc(VALUE, ',') + 1;

Re: comma and countc

ChrisNZ — Fri, 14 May 2021 01:41:07 GMT

Have you looked at function COUNTW ?

Re: comma and countc

r_behata — Fri, 14 May 2021 01:58:14 GMT

data have;
input ID $ VALUE $;
infile cards truncover;
cards;
ABC 2
CDE 
EEA 2,3
AWE 4,5,6
DDE 5
QWE 
WQE 5,3,2
;
run;


data want;
	set have;

	count=ifc(^ missing(VALUE),left(countw(VALUE,',')),'');
run;