Use Merged Synonym Data Sets

In this set of tasks, you will create a new data set that contains all the observations from both the Mylib.Vaerextsyns and Mylib.Vaer_abbrev data sets. You will examine the results by using the merged synonym data set. Complete the following steps:
  1. Select the Utility tab on the node toolbar and drag a SAS Code node into the diagram workspace.
  2. Right-click the SAS Code node, and select Rename.
  3. Enter SAS Code — Merge SL in the Node Name field, and then click OK.
    SL stands for Synonym Lists.
  4. Connect the SAS Code — %TEXTSYN node to the SAS Code — Merge SL node.
    Process flow diagram
  5. Select the SAS Code — Merge SL node.
  6. Click the Ellipses icon for the Code Editor property.
    The Code Editor appears.
  7. Enter the following code in the Code Editor: 
    data mylib.vaerextsyns_new;
     set mylib.vaerextsyns mylib.vaer_abbrev;
run;
    This code merges the resulting synonyms data set from the first SAS Code — %TEXTSYN node with the abbreviations data set.
  8. Click Save icon.
  9. Close the Code Editor window.
  10. Right-click the SAS Code — Merge SL node, and select Run. Click Yes in the Confirmation dialog box.
  11. Click Results in the Run Status dialog box when the node has finished running.
  12. From the Results window, select Viewthen select SAS Resultsthen select Log to see the SAS code where the new data set is created.
    Close the Results window.
  13. Right-click the Text Parsing — Symptom Text node, and then select Copy.
    Note: It is important to copy the Text Parsing — Symptom Text node instead of creating a new Text Miner node. You do this in order to keep the same property settings you previously configured for the Text Parsing — Symptom Text node.
  14. Right-click an empty space in the diagram workspace and select Paste.
  15. Right-click the new Text Parsing node, and select Rename.
  16. Enter Text Parsing — CST in the Node Name field.
    CST stands for Cleaned Symptom Text.
  17. Click OK.
  18. Right-click the Text Filter — Symptom Text node, and then select Copy.
  19. Right-click an empty space in the diagram workspace and select Paste.
  20. Right-click the new Text Filter node, and select Rename.
  21. Enter Text Filter — CST in the Node Name field.
  22. Click OK.
  23. Connect the Data Partition node to the Text Parsing — CST node.
  24. Connect the Text Parsing — CST node to the Text Filter — CST node.
    Process flow diagram
  25. Select the Text Parsing — CST node.
  26. Click the Ellipses icon for the Synonyms property.
  27. Click Import.
  28. Click Mylib in the SAS Libraries tree.
    The contents of the Mylib library appear.
  29. Select Mylib.Vaerextsyns_new.
  30. Click OK.
    The contents of the data set appear in the dialog box.
  31. Click OK.
  32. Right-click the Text Filter — CST node, and select Run. Click Yes in the Confirmation dialog box.
  33. Click OK in the Run Status dialog box when the node has finished running.
  34. Select the Text Filter — CST node.
  35. Click the Ellipses icon for the Filter Viewer property.
    The Interactive Filter Viewer window appears.
  36. Select the plus sign (+) next to patient in the Terms table. Note that the misspellings patien, patietn, and paitent are included as child terms.
    Terms window
  37. Close the Interactive Filter Viewer.
Copyright © SAS Institute Inc. All rights reserved.