Dear fellow users, I'm tying to load strings that contain emojis via DI Studio (SAS 9.4) into a MySQL database. I understand that MySQL is a bit tricky when it comes to character sets but I changed the target table to utf8mb4 which definitely stores emojis. When I use the table loader transformation to append my datasets to the table in the database it returns an "invalid utf8 character string" error.   Here's what I have tried: 1. check the character sets for all parts of the procedure: my data come from jsons and are loaded via the json libname engine. They are correctly stored in a SAS work table. The mysql library is set to utfbmb4 and so is the mysql table. 2. test the database: when inserted through mysql workbench the emojis are stored just fine. The error only occurs if I use the SAS table loader. 3. check different modes of loading the data: a) If I delete the mysql table, then recreate it and manually set it to utf8mb4 prior to running the load job the character set is reset to utf-8, thus causing the error. b) If I set the table to utf8mb4, then enter a record manually and run the load job afterwards, the table character set isn't reset and the original record is unaffected. The table loader still returns the same error though. c) If I delete the mysql table and then let SAS create a new one by running the table loader the new table is set to utf-8 and again the same error shows.   So this seems to be a problem with how the table loader works. Does anybody know a solution to this? ... View more

Hello, I'm trying to display a live calculated change from last year's parallel month in a Key Value element. The data element works as expected in a table without the filter applied but doesn't display the expected values when assigned to a Key Value object. I think the problem is that the ParallelPeriod function doesn't recognize the report filter as the source for the current month value but I can't find any documentation on how to fix this. Any recommendations? ... View more

Hello, I'm creating a new table using a data step where I need to fill the blanks with values from another table following a non-trivial mapping logic (i. e. I have to use a singular rule for every single combination of line and column).   This is the structure of the new table: DATA newtable; input linename $; DATALINES; line1 line2 line3 ; col1 = .; col2 = .; col3 = .; RUN; My lookup table looks like this: DATA lookuptable; input level1 level2 value; DATALINES; 1 1 10 1 2 10 1 3 20 2 1 20 2 2 10 2 3 45 3 1 41 3 2 12 3 3 14 ; RUN; The task is to be able to fill NEWTABLE with values from LOOKUPTABLE using values of LINENAME and the name of the variable (i. e. col1 to col3) to select which cell to fill and values of LEVEL1 and LEVEL2 to choose which value to use. I can't seem to find a reasonable way of doing this with SAS Base. Any suggestions? ... View more

Hello, I think the title says it all: I would like to store single results from PROC steps (i. e. regression coefficients, p-values ...) and display them later altogether in one table. It would also work for me just to print them as a list with annotations. The important thing here is that I need to display a large amount of results in an overseeable way.   I'm especially thinking of the way you can work with stored results in Stata. Every program you execute generates a number of local macros that contain the single numbers and strings that you can see in the program's output. Afterwards you can store them with custom names and after you finished all your analyses you can easily get an overview over the key outputs. ... View more

Hi,   is there a feasible way (or a good alternative) to do loops in SAS without getting into macros? I need to repeat the same analysis section (a sequence of proc steps) for a lot of variables which are named with single letters in alphabetical order. So I would like to do something like this:   Loop that executes the following code for each i=C to K { PROC whatever; parameter=i; RUN; } What would be the easiest way of doing this in SAS?     ... View more