Hello Experts,   I am loading a single record with (special character embedded) to Greenplum using the code:     LIBNAME test GREENPLM    PRESERVE_COL_NAMES=NO  PRESERVE_TAB_NAMES=NO  DATABASE=xxx SERVER="xxx"  SCHEMA=xxx  AUTHDOMAIN="xxx" ;   data table; test='aébcabcabc'; run;   proc append base = test.test (BULKLOAD=YES   BL_PROTOCOL= "gpfdist"  BL_HOST = "&BL_HOST" BL_DELETE_DATAFILE=NO BL_PORT = &BL_PORT )       data = table  force ;  run;     and I hit the error:   ERROR: [SAS][ODBC Greenplum Wire Protocol driver][Greenplum]ERROR: invalid byte sequence for encoding "UTF8": 0xe97f00  (seg20        slice1 192.168.99.26:40004 pid=303354)     the underlying dat file generated contains:   aé    abcabc   if directly copy and paste from dat file you get: aé   if open this dat file from Linux then you will have  aé^@^@abcabc   1. Encoding in GP is UTF8 2. Encoding in SAS session is Latin1 3.SAS verions is 9.4 M6 on linux     I want to know why cause the issue and how to solve it?     Thanks Chen Xu ... View more

Hi Experts,   Assume I have the following data and want to create cross table in VA.   Week number(date).       Age group.      Number of people 1                                      1-30                  1 1                                      31-60                  2 1                                    61 and above     3 2                                      31-60                  1 2                                       61 and above      2     My new calculated item will be relative function in period with -1 on week number for number of people   so you have     Week number(date).       Age group.      Number of people.        Week-1(calculated) 1                                      1-30                  1                                         . 1                                      31-60                  2                                        . 1                                    61 and above      3                                        .     2                                      31-60                 1                                       2( from week1) 2                                       61 and above   2                                        3 (from week1)   now i I want to create a cross table in VA 8.3 with filter week=2   the row variable is age group and column variable is week-1 I would get:   Filter is week=2                                           Week-1 age 31-60                          2 age 61 and above.            3   age 1-30 is missing from this cross table as this category does not exist in week2. But I want to see it here as the column I used is week-1. How do I get this missing category displayed in the cross table without manipulating the source data.       thanks ... View more

Hi Expert,   Is there a way to generate numeric column based on the value a string column.   for example, my string column can have the value ABC123 then I want to convert this value into a fixed value 123456 using some SAS functions or format like $hex72.   I tried to format the character column using put(column,$hex72.) but it lost precision when I further convert into a numeric column input(put(column,$72.)).   The reason I want to do this is because our primary key is in character format (ABC123) and I need to generate a numeric primary key to represent each primary key.   Thanks ... View more

Hi Experts,   I have a list of phone number that including both Australia and oversea. the length of the phone number is undefined (can be anything)   I want to know if there is a smart way to find repeated pattern within any phone number without using regular expression.    for example:   04123123123 has repeated pattern 123123123   or 1212121212 has repeated pattern 1212121212    thanks ... View more