topic Re: How can I split the sentence into different variables? in SAS Data Science https://communities.sas.com/t5/SAS-Data-Science/How-can-I-split-the-sentence-into-different-variables/m-p/868810#M10480 <P>Moved to Data Mining Community for better visibility from DM specialists.</P> Sun, 09 Apr 2023 22:30:26 GMT SASKiwi 2023-04-09T22:30:26Z How can I split the sentence into different variables? https://communities.sas.com/t5/SAS-Data-Science/How-can-I-split-the-sentence-into-different-variables/m-p/868773#M10476 like the following:<BR /><BR />Old dataset:<BR />id room_type description<BR />2818 Private room Quiet room with super fast wifi and garden view<BR />3209 Entire home/apt spacious bright apartment with monumental view<BR />0168 Entire home/apt Cozy studio that have own private room in apartment with beautiful view<BR />…<BR /><BR /><BR />New dataset:<BR />id room_type description_1//description_2//description_3//description_4<BR />2818 Private room Quiet room//super fast wifi//Garden view<BR />3209 Entire home/apt spacious bright apartment//monumental view<BR />0168 Entire home/apt Cozy studio//own private room//apartment//beautiful view<BR />…<BR /><BR /><BR />Tbank you very much! Sun, 09 Apr 2023 14:53:05 GMT https://communities.sas.com/t5/SAS-Data-Science/How-can-I-split-the-sentence-into-different-variables/m-p/868773#M10476 nat1313 2023-04-09T14:53:05Z Re: How can I split the sentence into different variables? https://communities.sas.com/t5/SAS-Data-Science/How-can-I-split-the-sentence-into-different-variables/m-p/868774#M10477 <P>How do you know where to split the sentence?</P> Sun, 09 Apr 2023 14:59:24 GMT https://communities.sas.com/t5/SAS-Data-Science/How-can-I-split-the-sentence-into-different-variables/m-p/868774#M10477 PaigeMiller 2023-04-09T14:59:24Z Re: How can I split the sentence into different variables? https://communities.sas.com/t5/SAS-Data-Science/How-can-I-split-the-sentence-into-different-variables/m-p/868782#M10478 Actually i want to do a link analysis in the sas em with the key words. However, it seems not possible for me to just input the sentence, so decide to split into keywords through sas code. Sun, 09 Apr 2023 15:49:22 GMT https://communities.sas.com/t5/SAS-Data-Science/How-can-I-split-the-sentence-into-different-variables/m-p/868782#M10478 nat1313 2023-04-09T15:49:22Z Re: How can I split the sentence into different variables? https://communities.sas.com/t5/SAS-Data-Science/How-can-I-split-the-sentence-into-different-variables/m-p/868788#M10479 <P>This does not answer my question.</P> Sun, 09 Apr 2023 16:39:18 GMT https://communities.sas.com/t5/SAS-Data-Science/How-can-I-split-the-sentence-into-different-variables/m-p/868788#M10479 PaigeMiller 2023-04-09T16:39:18Z Re: How can I split the sentence into different variables? https://communities.sas.com/t5/SAS-Data-Science/How-can-I-split-the-sentence-into-different-variables/m-p/868810#M10480 <P>Moved to Data Mining Community for better visibility from DM specialists.</P> Sun, 09 Apr 2023 22:30:26 GMT https://communities.sas.com/t5/SAS-Data-Science/How-can-I-split-the-sentence-into-different-variables/m-p/868810#M10480 SASKiwi 2023-04-09T22:30:26Z