请问: 如何统计数据集中某个词的总频数? 谢谢

大家好，我想请问一下:

如何统计数据集中某个词的总频数?  这个词可能出现在任何一个column.

比如下面这个数据集:

Film	Director	Producer	Starring	Release
Fight Club	David Fincher	Art Linson	Brad  Pitt	1999
The Departed		Brad  Pitt	Leonardo DiCaprio	2006
World War Z	Marc Forster	Brad  Pitt	Brad  Pitt	2013
12 Years a  Slave	Steve McQueen	Brad Pitt	Chiwetel Ejiofor	2013
The Aviator	Martin Scorsese	Michael Mann	Leonardo DiCaprio	2004
Blood Diamond	Edward Zwick		Leonardo DiCaprio	2006
The Wolf of  Wall Street		Martin Scorsese	Leonardo DiCaprio	2013
Brad Pitt	Moneyball	2011
Sleepy Hollow	Tim Burton	Scott Rudin	Johnny Depp	1999
Pirates of the  Caribbean: Dead Man's Chest	Gore Verbinski	Jerry Bruckheimer	Johnny Depp	2006

如何统计 “Brad Pitt” 这个词的出现次数?

列的名字是没有规律的, 观测数是不确定的

谢谢！

p.s.  上面例子的CSV数据集在附件(修改txt为csv即可)

1. data test;
   
2. length Film$100. Director$100. Producer$100. Starring$100.;
   
3. infile datalines dsd missover;
   
4. input Film$ Director$ Producer$ Starring$ Release;
   
5. datalines;
   
6. Fight Club,David Fincher,Art Linson,Brad Pitt,1999
   
7. The Departed,,Brad Pitt,Leonardo DiCaprio,2006
   
8. World War Z,Marc Forster,Brad Pitt,Brad Pitt,2013
   
9. 12 Years a Slave,Steve McQueen,Brad Pitt,Chiwetel Ejiofor,2013
   
10. The Aviator,Martin Scorsese,Michael Mann,Leonardo DiCaprio,2004
    
11. Blood Diamond,Edward Zwick,,Leonardo DiCaprio,2006
    
12. The Wolf of Wall Street,,Martin Scorsese,Leonardo DiCaprio,2013
    
13. Brad Pitt,Moneyball,2011,,
    
14. Sleepy Hollow,Tim Burton,Scott Rudin,Johnny Depp,1999
    
15. Pirates of the Caribbean: Dead Man's Chest,Gore Verbinski,Jerry Bruckheimer,Johnny Depp,2006
    
16. ;
    
17. run;
    
18. 
    
19. data test2;
    
20.         set test;
    
21.         retain cnt 0;
    
22.         array char _character_;
    
23.         do over char;
    
24.                 if char eq "Brad Pitt" then cnt+1;
    
25.         end;
    
26. run;

复制代码