Hello, i try to know if specific words are within text. i use function findw. the problem is that i defined words inside array and when i run the function findw(text,word(i)) i didn't get answer, but when i write specific words by myself, i get right answer. for example findw(text,'sea').   data for example is :           text                       word1    word2    word3 the car is beautiful           best        car          blue sea                           sea        blue        exist   i saw that length,format and informat of array word is length 8, maybe this is problem? Whta i should do?   my program look like :   data test; set text; array word (3) $ word1-word3; array exist_ind (3); do i=1 to 3;     ind(i)=findw(text,word(i)); end; run;     ... View more

Hello, i have a general question about analytics of text mining. I want to understand how to work with big text data. my aim from text data to get topics.(for example model PLSA) assume i have a data of more then 1 million rows, and two variables : document id and story( every value is text - maybe more than 15000 words). i need from every document to extract words. when i do it i got dataset with number of rows of more than 500 million. example : documentid   word 1                        i  1                      am 1                     work 2                       do  2                      you 2                    work 2                      in   what i should do? maybe to build an array(but still it can be very long)? how can i do text mining in SAS? what is right way to build a data?  Thank you ... View more

Hello, i want to import Json file, i did it and the program work well, but i want to write it in macro. Instead full_address variable i want to put macro variable &comm. but when i write it as is, it's not work, i tried different options, but still i didn't get answer. What i should do?  thank you filename business "&lnk_input2\name.json"; %macro flexdata(data,comm,output); data &output;       infile &data lrecl=255 truncover scanover;       input @ '"full_address": "' &comm $240.;       &comm=substr(&comm,1,index(&comm,'",')-1); run; %mend; %flexdata(data=business,comm=full_address, output=business2); ... View more

Hello, i have a question about Pruning in the Apriori Algorithm. for example, i have a 4-itemset  : Milk-Eggs-Bread-Beer(as abcd) I want to check pruning : if 4-itemset that consist of different 3-itemset, Milk-Eggs-Bread; Milk-Eggs-Beer ;Milk-Bread-Beer ...... was in the last step. how to divide this 4-itemset for all diffrent options 3-itemset? in addition maybe you can advice me how to work and save all the itemsets? i never worked with this kind of algorithms. Thank you ... View more

Hello, i want create a vector of all options from vector of strings : i have to "multiply" every cell to other cell example : i have a variable of characters a b d e i want to create the next variable ab ad ae bd be de how i can do it? thank you ... View more

Hello, i want create a vector of all options from vector of strings : i have to "multiply" every cell to other cell example : i have a variable of characters a b d e i want to create the next variable ab ad ae bd be de how i can do it? thank you ... View more

Hello, i created graphs, by gplot. i want to change scaling for every graph(i create graph for every security - see by) , how can i drp it? i.e for every security i have different scale, i want to use scaling inside dataset and to use in the order statement. can i? for example : axis1 label=none minor=none offset=(0,0); axis2 label=none minor=none offset=(0,0) order=(100 to 150 by 5); proc gplot data=test; plot price*time=1 / overlay vaxis=axis1 haxis=axes2 noframe; by security; run; thank you Alexey ... View more