BookmarkSubscribeRSS Feed
knveraraju91
Barite | Level 11

Dear,

 

In my program, the  COUNTW function counts words as 1 when the values are missing. How to avoid. Please suggest. i am getting    dtf='M' when date is missing.

output needed

id   date                    dtf

1 2018-08-29            
2 2018-08                 D           
3 2018                      M
4

 

output getting

id   date                    dtf

1 2018-08-29            
2 2018-08                 D           
3 2018                      M
4                               M

data one;
input id date $10.;
datalines;
1 2018-08-29
2 2018-08
3 2018
4
;

data two;
set one;
dtf=choosec(countw(date, "-"),"M", "D", " ");
 aaa=countw(date, "-");
 run;
2 REPLIES 2
novinosrin
Tourmaline | Level 20

HI @knveraraju91  You can use the T modifier for countw to count missings as 0. 

 aaa=countw(date, "-",'t');
Tom
Super User Tom
Super User

You could just switch to using COUNTC() to count the number of hyphens.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1158 views
  • 4 likes
  • 3 in conversation