topic Re: Which modifier to use to in COUNTW function in SAS Programming

Which modifier to use to in COUNTW function

knveraraju91 — Tue, 03 Jan 2017 00:33:18 GMT

Dear,

I am using the following sas statement .

code;

DTF = choosec(countw(date, "-"),"M", "D", " ");

data

OBS date

1 2014-10-10

2 2014-19

3 2014

ouput needed;

OBS DTF

2 D

3 M

I am getting the output I need except fourth OBS. For the fourth OBS I am getting "M"

Which modifier I need to use when the date value is blank to get the output. Please help. Thanks.

Reeza — Tue, 03 Jan 2017 00:43:05 GMT

Shmuel — Tue, 03 Jan 2017 01:29:32 GMT

I have tested it. You can do:

if not missing(date) then

dtf = choosec(countw(date,'-'),'m','d',' ');