topic Re: SAS Function help in SAS Programming

SAS Function help

Kalai2008 — Fri, 16 Oct 2020 14:56:50 GMT

Hello,

I need help here. I have a column that contains names, separated by space.I am trying to count the names.

I have tried Scan function but that returns the nth word from a character string.

scan(name, 1, ' ') as first_name , scan(name, 2, ' ') as second_name

Data have:

Name

HEID LILIAN MARTINEZ SANCHEZ

GIRALDO MONTO ANGELA

Data Want:

Name Count

HEID LILIAN MARTINEZ SANCHEZ 4

GIRALDO MONTO ANGELA 3

Thanks for looking !

novinosrin — Fri, 16 Oct 2020 15:00:19 GMT

data have;
input Name $30.;
cards;
HEID LILIAN MARTINEZ SANCHEZ
GIRALDO MONTO ANGELA
;

data want;
 set have;
 count=countw(name,' ');
run;

JosvanderVelden — Fri, 16 Oct 2020 15:01:17 GMT