topic Re: How can I tokenize a document using Base SAS? in SAS Data Science

How can I tokenize a document using Base SAS?

DanielDor — Sat, 25 Mar 2017 13:30:56 GMT

Greetings,

1. Tokenization is a way to split text into tokens. I would like to do 2 things:

1.1 Tokenize an entire document (the tokens in my case are words and not phrases or letters).

1.2 Remove Stop Words

2. I Saw Cynthia's solutions to count the Frequency of words in a document -> https://communities.sas.com/t5/SAS-Procedures/Frequency-of-Strings/td-p/41378 -> However, I would like to create tokens and not only to count the frequncy of words

3. I don't have SAS Text Miner or SAS Contextual Analysis for this. I would need to use Base SAS for this task.

4. Any code example or ideas will assist.

Thanks!!

Re: How can I tokenize a document using Base SAS?

art297 — Sat, 25 Mar 2017 18:47:39 GMT

FWIW: There are a number of R packages that do what you want. See, e.g., :

https://www.google.ca/url?sa=t&rct=j&q=&esrc=s&source=web&cd=2&cad=rja&uact=8&ved=0ahUKEwjrmp3Xp_LSAhUJw4MKHZ-wAFQQFggvMAE&url=https%3A%2F%2Fcran.r-project.org%2Fweb%2Fpackages%2FNLP%2FNLP.pdf&usg=AFQjCNHS3vDZ5VmOMtnUUmIVVY8FPEN84g&sig2=8hXJPCVQBeHKEcmwTh8w-g

https://www.google.ca/url?sa=t&rct=j&q=&esrc=s&source=web&cd=3&cad=rja&uact=8&ved=0ahUKEwjrmp3Xp_LSAhUJw4MKHZ-wAFQQFgg2MAI&url=https%3A%2F%2Fwww.rdocumentation.org%2Fpackages%2FkoRpus%2Fversions%2F0.06-5%2Ftopics%2Ftokenize&usg=AFQjCNFweIdY0yRpCCDnSmESQsRMaVj2rw&sig2=C9-XugZZc01bghI6YzWy-g

and

https://www.google.ca/url?sa=t&rct=j&q=&esrc=s&source=web&cd=4&cad=rja&uact=8&ved=0ahUKEwjrmp3Xp_LSAhUJw4MKHZ-wAFQQFgg7MAM&url=http%3A%2F%2Fwww.mjdenny.com%2FText_Processing_In_R.html&usg=AFQjCNF_1qqMeGZGSVVoCKH8Z5P6QFzvoQ&sig2=9KDcJWxO8mSA0SKBENnPNw

Art, CEO, AnalystFinder.com

Re: How can I tokenize a document using Base SAS?

DanielDor — Sat, 25 Mar 2017 19:12:58 GMT

Thanks a lot for the info! But I would like to do this in SAS 🙂

Re: How can I tokenize a document using Base SAS?

art297 — Sat, 25 Mar 2017 19:22:01 GMT

There is a no longer documented procedure that can identify all of the words and obtain frequency distributions of those words .. which would at least provide a base SAS starting point.

I was going to mention it in my last post, but it no longer worked in SAS 9.4 .. at least on SAS University Edition.

However, I just received a note from someone that it was still working in SAS 9.3.

My only suggestion would be to try it. It's called PROC SPELL. Here is an example of how it can be run:

options caps;
filename temp temp;
data _null_;
  file temp;
  informat sentence $100.;
  input sentence &;
  put sentence;
  cards;
Let's see if sas spell procdure can be used
to verify whether tha seperate words in
this, uhm, flie are, uhm, valid against a
stantard internal dictionary and let’s see
how versatile it is
;

proc spell in=temp nomaster verify;
run;

HTH,

Art, CEO, AnalystFinder.com

Re: How can I tokenize a document using Base SAS?

art297 — Sat, 25 Mar 2017 19:44:32 GMT

p.s. Just got confirmation from some of my colleagues that PROC SPELL does indeed work on "regular" versions of SAS 9.3 and 9.4.

For some reason it just isn't working on SAS UE

Art, CEO, AnalystFinder.com

Re: How can I tokenize a document using Base SAS?

Reeza — Sat, 25 Mar 2017 20:21:53 GMT

Here's one way to separate a document, which I'm assuming you've already imported into SAS.

You can find 'corpus' online that include parts of speech or sentiment and then use those to help classify the words. As @art297 has indicated there's an old proc (unsupported) that can help with this.

I store the code here, which is a bit more than what's below, but if you have a corpus read iin, it may be useful. Hope this helps somewhat.

https://github.com/statgeek/SAS-Tutorials/blob/master/text_analysis

*Create sample data;
data random_sentences;
    infile cards truncover;
    informat sentence $256.;
    input sentence $256.;
    cards;
This is a random sentence
This is another random sentence
Happy Birthday
My job sucks.
This is a good idea, not.
This is an awesome idea!
How are you today?
Does this make sense?
Have a great day!
;
    ;
    ;
    ;

*Partition into words;
data f1;
    set random_sentences;
    id=_n_;
    nwords=countw(sentence);
    nchar=length(compress(sentence));

    do word_order=1 to nwords;
        word=scan(sentence, word_order);
        output;
    end;
run;

Re: How can I tokenize a document using Base SAS?

DanielDor — Sat, 25 Mar 2017 20:27:22 GMT

Hi Art,

Thanks again for the assistance and the fast replies.

I've tried PROC SPELL on SAS9.4 and it works. However, it writes the results to report. Do you know by chance if I have a way to write the results to a dataset instead?

Thanks a lot!

D

Re: How can I tokenize a document using Base SAS?

DanielDor — Sat, 25 Mar 2017 20:30:43 GMT

Hi Reeza,

Thanks for your reply! 🙂 In your opinion, what would be the best way to take the F1 dataset, and tokenize or stem it? I need for example that words "goes"/"going"/"go"/"went" will be under the same concept ("go").

Thanks!

D

Re: How can I tokenize a document using Base SAS?

Reeza — Sat, 25 Mar 2017 20:33:31 GMT

You need a mapping document, like a 'corpus' that I mentioned, that maps them to the 'root' of the word.

Once you have those documents set up you can merge the data and assign them to the same group.

Some of these mapping documents are open source but many are not.

Re: How can I tokenize a document using Base SAS?

art297 — Sat, 25 Mar 2017 21:18:15 GMT

I don't think SAS would appreciate my posting it here, but I happen to have a copy of the SPELL procedure's documentation.

I'd be glad to answer any of your questions off-line. Send me a note to: art@analystfinder.com

There isn't an output option, but the documentation says to just save the output and use it as input back to SAS or any text editor. Of course, these days you can accomplish that using proc printto.

You can also create your own dictionaries, thus could create a dictionary of stop words, tokens and whatever.

Art, CEO, AnalystFinder.com

Re: How can I tokenize a document using Base SAS?

DanielDor — Sun, 26 Mar 2017 07:17:08 GMT

Hi Reeza,

Thanks for the information. Are you familiar with a good and effective Corpus which I can use for this Tokenization?

Thanks!

D

Re: How can I tokenize a document using Base SAS?

Reeza — Sun, 26 Mar 2017 19:16:45 GMT

I think the Brown one is considered the best, but I don't think it's free. If you find a free, open source copy, post the link 🙂

Re: How can I tokenize a document using Base SAS?

EricwenLiu — Tue, 28 Mar 2017 14:07:12 GMT

You may try PROC HPTMINE.

Re: How can I tokenize a document using Base SAS?

Rajaram — Tue, 19 May 2020 03:51:46 GMT

Is there any solution to your problem?

Re: How can I tokenize a document using Base SAS?

Rajaram — Tue, 19 May 2020 03:52:58 GMT

PROC HPTMINE is not part of Base SAS