I need some help resolving an issue. I am joining two tables by a field called  'policy'.    policy customer 000718124 1001 000714946 1002 000910934 1003 000901672 1004   In table A the policy field is Type: Character and Length: 9 and in the table B it is Type: Character and Length: 20.  Since the field has 9 characters I changed the length of the field in table B in proc sql like below. data test1; length policy $9; set B; run; So now, the field policy in test1 table has length = 9. So, when I join tables A and test1, I do not get any data back.  So, I changed the length of policy field in table A also, even though the character length is 9.    data test2; length policy $9; set A; run; Again I tried join test1 and test2 but I am still not getting any data back. Both tables have the same values for policy field so I know there is data but I do not get anything back. Thank you in advance ... View more

I need help to exclude records with a variable that has values other than numbers and characters. Below is an example.   I have a variable 'test' which has values like below.   Test 00*915174 00*915174 (00)-1234 00(9151.74) 00_915_174 00-9151-74 001234   In the above column, I would like to exclude all the values with special character such as (, ), -, ., * and space. I want to keep values such as '001234' or 'ABC123'.   Thank you   ... View more

Good Afternoon, I have a 7 character variable in a dataset. I want to replace 'X' in the 2nd position from left with a '0'  in this variable. And same way in a different dataset, replace '0' in the 2nd position from left with 'X'.   1st dataset: I have: 0X12345 I want: 0012345   2nd dataset: I have: 0012345 I want: 0X12345   Thank you in advance!     ... View more

Hello, I need some help. I have 8 tables/datasets in SAS that I want to export to Excel using ODS Excel. They all need to go in one excel file with three tabs. Out of these 8 tables, 4 need to go in the 1st tab, two in the 2nd tab and last two need to go in the 3rd tab. I know how to have either all tables in one tab (using sheet_interval='NONE') or have all the tables in a separate tab (using sheet_interval='YES')  but I do not know how to accomplish what I need to do.  I appreciate your help. Thank you ... View more

I have a table XYZ and I am running below code to get frequency of two fields in that table.            proc freq data =  XYZ;            tables Pre_intent*T4 / nopercent norow nocol;    run; I get below output. Table of Pre_intent by T4     Pre_intent T4         1 ER 2 UC 3 OV Total 1 ER 9 1 176 376 2 UC 26 12 1450 4333 3 OV 7 2 539 1576 Total 42 15 2165 6285   I would like to add a 'percentage of total' field so it would look like below. Table of Pre_intent by T4       Pre_intent T4           1 ER 2 UC 3 OV Total Percentage of Total 1 ER 9 1 176 376 0.05982498 2 UC 26 12 1450 4333 0.689419252 3 OV 7 2 539 1576 0.250755768 Total 42 15 2165 6285 1   Also, how do I save this frequency table as a dataset??? Thanks in advance for all your help!   ... View more