Hi all, I am using this proc print statement: 3904  proc print data=test_data noobs; 3905     var R1  Cat1 P1 N; 3907     where R1="ClientA"; 3908  run; When I get the table from this - I would like the column name "N" to be replaced by the words "Count of Clients" How would I modify this code to achieve this? Thanks! ... View more

Hi all, I am wondering if this is possible - and if so how? : I have a dataset called test - it contains values like: COL1    COL2         COL3 ABB     Test why     OQSJ AIW     This is ex     QSDJ AIQ     Why Test     KAJL Questions: 1) Is there any way in sas to search COL2 for the word "Test" and then output a new dataset that only contains the rows that had the word "Test" somewhere in COL2. 2) Is there any way in sas for me to search specific sentences in COL2? Example - I want sas to search for "This is ex" and "Why Test" and output a new dataset that only contains rows where these two are true. Please post sample code if possible. Thanks! ... View more

Hi all, I am wondering if there is any way to create a new variable in a sas dataset that just populates the month and year from another variable in datetime9 format. Example of what I mean: Variable 1: 2009JAN14:23:00:00 Variable 2 (the one I want to generate) should look like: JAN 2009 Example code will be much appreciated! ... View more