Hi SASNE,   You can test if the .vbs file works by adding a MsgBox comment inside the script.   Sub dowork() On Error Resume Next '---- ' Start up Enterprise Guide using the project name '---- Dim prjName Dim prjObject Dim containerName ' As String Dim containerObject ' As SASEGuide.Container Dim containerColl ' As SASEGuide.ContainerCollection prjName = "G:\Database_Project.egp" 'Project Name 'Add code here MsgBox "Hi I'm working!" Rest of code below here ...   Now if you double click the file, you should see a dialogue box pop up.   Let me know if it doesn't happen.   Next we want to check that TS is working to run this .vbs file.   The process is that TS creates a batch file that has the path to the .vbs file & it's the .vbs file that triggers the SAS EG project.   Go to your TS & right click to go to Properties >> & on the Actions tab.   Highlight the path in the Actions box & click on 'Edit'   Amend your details in the Actions Tab to what's shown in the Attached picture.   Ensure you add " " around the path of the .vbs file shown in the 'Add arguments (optional)' box.   On the General tab, use the 'Run only when User is logged on & all other stttings can stay the same for now.   We want to get to a stage where the running of the Task in TS gets you a Pop up message from the .vbs file.   So now save everything, go to TS & right click on the task & click 'Run'.   Let me know how you go.   Cheers   ... View more

Hi Shmuel,   I've posted a quick Create table & Insert statement to help.   Note, I've added some punctuation to show that the data is a bit messy but I'm just after the words/phrases regardless of punctuation or case.   I want to find & extract the words/phrases in the 'TEXT TO FIND' table from the UNSTRUCTURED TEXT' Table.   I was thinking of a Loop that runs the first word/phrase from the 'TEXT TO FIND' table through all the records in the UNSTRUCTURED TEXT' Table extract the matches & do the same with the next word/phrase.     Cheers   proc sql; create table RDW.UNSTRUCTURED_TEXT (Check_String char(3000)); insert into RDW.UNSTRUCTURED_TEXT values('The quick brown dog, jumped over-the lazy dog') values('The QUICK GREEN dog jumped over, the lazy dog') values('The quick snake slithered over the lazy dog') values('The dog quickly Jumped over the lazy Fox') values('The Quick; brown_dog! jumped over the Lazy dog'); title 'RDW.UNSTRUCTURED_TEXT'; select * from RDW.UNSTRUCTURED_TEXT; proc sql; create table RDW.TEXT_TO_FIND (Check_String char(300)); insert into RDW.TEXT_TO_FIND values('QUICK GREEN dog') values('quickly Jumped over') values('slithered over the lazy dog') values('The Quick;') values('snake'); title 'RDW.TEXT_TO_FIND'; select * from RDW.TEXT_TO_FIND; proc printto; run;   ... View more

Hi SASNE,   I've found that I need to create the files myself to ensure they all work as required.   If you have scheduled a task, you should see it in the Windows Task Scheduler (TS) program.   If you go the TS >> find your Task >> right click & open the properties >> go to the 'Actions' tab & you'll see the path to the .vbs file that runs the SAS EG Project.   Double click on that file to see if it runs the Project (Make sure the Project runs quickly or coment some parts out so you don't have to wait around to test this).   If it runs the project, the issue is with the Task at the Task Scheduler end (which it usually is I've found).   Try these steps & let me know how you go.     ... View more

I've now tried to create a Word Cloud as a Report but this doesn't have the same Sentiment Analysis as the Visualisation.   Surely there is a way to export all of the Word Cloud details for all Documents as a normal process?? ... View more

Thanks varsha_sas for clarifying.   We can do that once the Visualisation is built.   Thanks again ... View more