Hello, We're having issues removing tabs from our data as after the data massage the export into an Excel file is Unreadable and it's mostly caused by users entering a tab character in the software.   We've tried the following and others without any success:   PROJECT_NOTES=compress(PROJECT_NOTES,' ',s);   In the quotes is a tab. Removing the tab or replacing it with a space is OK. Thoughts?   Adam SAS 9.3 ... View more

First post and I'm a beginner in SAS.   Looking to count the variables in a table. I have them grouped or sorted. Below is my example:   Table_1 ITEM red blue blue yellow yellow yellow   Expected outcome in new table (Table_2) or appended to Table_1:   ITEM    COUNT red            1 blue           2 yellow        3   How can I get Table_1 as above or a new Table_2 with the outcome? Thanks - Adam     ... View more