topic Re: Frequency of words in char var in SAS Programming

Frequency of words in char var

Ronein — Thu, 13 Jan 2022 06:40:50 GMT

Hello

The data set contain 3 variables: Customer ID, transfer description, amount.

transfer description is a char variable.

Each customer ID can have multiple rows.

I want to do the following :

Find the frequency distribution of separate words from field "transfer description"


data have;
informat transfer_description $5000.;
input ID  transfer_description  amount;
infile datalines delimiter='|';
datalines;
111|Transfer to my friend Joe Kaplan|1000 
111|Salary IBM|2000
111|Salary WIZZ|3980
111|Transfer to my father|500
333|Transfer to my gf|4000
333|Son help|3000
222|Salary IBM|1500
222|Charity|2500
222|Charity|3000
222|transfer to my friend Jula|8000
;
Run;

Re: Frequency of words in char var

andreas_lds — Thu, 13 Jan 2022 07:36:45 GMT

Seems to be dealing with the same problem as https://communities.sas.com/t5/SAS-Programming/split-char-into-multiple-columns-and-then-append-the-values-into/m-p/789913

Do you want the frequencies by id?

Re: Frequency of words in char var

Kurt_Bremser — Thu, 13 Jan 2022 09:08:11 GMT

data long;
set have;
length desc $20; /* set sufficient length as needed */
do i = 1 to countw(transfer_description," ");
  desc = scan(transfer_description,i," ");
  output;
end;
keep desc;
run;

proc freq data=long;
tables desc;
run;