Hi   I'm trying to convert json from a rest api to a dataset. In the JSON data there is an emoji, which SAS, or the proc json routine is unable to handle. I've played with idea of getting the data with python (don't know why), but not sure if python will handle this better.   Example code: filename input "testjson.json"; %let jsondata = '{"num_records": 1, "data": [[1, "texttexttext \ud83d\udc4d\ud83c\udffb"]], "data_type": "json"}'; libname posts json fileref=input; proc datasets lib=posts ; quit; The data array includes more attributes, but libname statement fails on the 4 encoded values at the end of the provided example and program throws the following error. The field is provided by users so there may be more... ERROR: Invalid JSON in input near line 1 column 71: Some code points did not transcode. ERROR: Error in the LIBNAME statement. Is it possible to handle this in some way besides getting the developer to change their API (probably not feasible)?         ... View more

As a fairly new SAS programmer, coming from a .NET development environment, to SAS Base and then to EG 8.1, I'm always looking to tweak EG to look or feel like what I'm used to, ie. Visual Studio.    Is there a way, in EG 8.1 to define how the split between log and code is set? Right now it is a vertical 50/50-split, but I'd like it to be a vertical split but 70/30 when opening any program file. If I need more space I can always drag the log windows to a different screen or widen the log window.   Can it be preset within EG, or can I manipulate WorkspaceLayout.xml in any way to achieve this? Is the XML-definition for WorkspaceLayout.xml available somewhere? ... View more

Hi   I have a report with multiple sections, and all sections are filtered by a date filter (single select list box). This list box sets a parameter which is then used in a calculated item say  IF ('StartDate'N <= 'MyParameter'p) Return 1 ELSE 0 This works in Section 1. The parameter filters the data and in I can see a parameter interaction when I view all interactions for that section.   However, I want to use the same category fiter in a different section to set a different parameter. Again, a single select list box, with the same category. A new parameter, and a new calculated item (with the same calculation). IF ('StartDate'N <= 'MyParameter2'p) RETURN 1 ELSE 0 Now this doesn't compute the same numbers as in section 1. When I view the interactions I can see a parameter interaction from section 1 to objects in my current sections. Why is there a parameter action from my section "Oversikt" to my vertical container and pivot table? How can I remove it? Deleting it from the interaction screen does not help. There is only one datasource in the report.         ... View more