Frank_Boekamp Tracker

Re: Sorting Data

Frank_Boekamp — Wed, 15 Jan 2020 13:38:34 GMT

Creating s sorted table in CAS seems to be possible using partioning functionality. You can order variables within a partition. So to create an ordered CAS table, you should create one (dummy) partition for the whole table.

/* Examples how to get an ordered CAS table */
cas;
caslib _all_ assign;
 
/* following code uses a 9.4 SAS dataset as input and creates a sorted table in CAS */
data work.unsorted;
     group = "A";       
     w1 = 5; w2 = 6; output;
     w1 = 3; w2 = 3; output;
     w1 = 1; w2 = 2; output;
     w1 = 3; w2 = 4; output;
run;

proc casutil
   outcaslib="casuser";
   load data= "unsorted" casout="sort1" replace partitionby=(group) orderby=(w1 w2) ;
run;

It's also possible to create a sorted CAS table based on a CAS table as input. This routine could replace a proc sort from 9.4:

/* Following code runs in CAS and sorts the columns in a CAS table */

/* A dummy group is added to put all data in the same partition */


data casuser.unsorted;
     group = "A";       
     w1 = 5; w2 = 6; output;
     w1 = 3; w2 = 3; output;
     w1 = 1; w2 = 2; output;
     w1 = 3; w2 = 4; output;
run;

data casuser.sort3 (partition=(group) orderby=(w1 w2));
    set casuser.unsorted ;
run;

You can use this sorted dataset for subsequent datasteps. But: to use constructs like retain and lag() you still have to change the datastep code: you could add the datastep option / single=yes to force CAS to run the datastep single threaded or use some retain logic to deal with multi threading.

One thing that is not working like it should do: order variables in descending order like in following example:

https://documentation.sas.com/?docsetId=casref&docsetTarget=p12eiok32viouqn1huacr2d39nl0.htm&docsetVersion=1.0&locale=en

This example contains some syntax errors and is not sorting variable ch as it should do.

My own example to show this:

/* following code runs in CAS and should order column w2 descending within column w1 */
/* This is not working as expected: column w2 is not ordered descending within w1  */
data casuser.sort4 (partition=(group) orderby=(w1 DESCENDING w2));
    set casuser.unsorted ;
run;

Why is this not working???

Re: Sorting Data

Frank_Boekamp — Mon, 09 Dec 2019 11:12:47 GMT

Sorting data sets in CAS is not even possible, proc sort and order by in proc FEDSQL for example do not exist in CAS.

Be careful using SAS base code in CAS: see running the DATA step in CAS with special attention to RETAIN, LAG, and _N_

https://www.sas.com/content/dam/SAS/support/en/sas-global-forum-proceedings/2018/2184-2018.pdf

Using SAS Studio on Viya, you can use the 'old' style SAS Base code. But then you are not profiting from the big performance gain in CAS which originates from multiple threading and in-memory processing of data.

Re: How do I create an xmr control chart in VA 7.4

Frank_Boekamp — Wed, 04 Dec 2019 17:44:21 GMT

Hear hear

Re: How do I create an xmr control chart in VA 7.4

Frank_Boekamp — Wed, 27 Nov 2019 14:39:09 GMT

In SAS VA 7.4 I don't know but in SAS Viya proc scp is now available in CAS, creating the tables for XMR charts. See

Process Monitoring in SAS Viya with the SPC Procedure https://www.youtube.com/watch?v=HNmJicNznIg

A visual component you have to build yourself though.It would be great to see a visual object in SAS VA someday to create XMR charts OOTB.

Re: SAS VA 8.4 linking section

Frank_Boekamp — Mon, 16 Sep 2019 07:23:50 GMT

Hi Sam,

I don't see any breadcrumb trails in my report.

I'm not opening a new report, I'm linking sections in the same report from text objects.

Best Regards,

Frank

SAS VA 8.4 linking section

Frank_Boekamp — Mon, 09 Sep 2019 07:47:51 GMT

Hi there,

When I open a section by clicking on a link in VA 8.3 I used to get an button-like arrow in the top left which took me back to the section that contained the link. In SAS VA 8.4 that button-like arrow seems to bee missing or am I missing something?

Cheers,

Frank

Re: Measure displayed in geo map using clustering in SAS VA 8.3.1

Frank_Boekamp — Wed, 01 May 2019 12:57:32 GMT

Hi Falko,

That's clear to me.

I hope that this will be realized soon because it will make the geo map with clustering a lot more usable.

Cheers, Frank

Measure displayed in geo map using clustering in SAS VA 8.3.1

Frank_Boekamp — Wed, 01 May 2019 09:21:39 GMT

Hi There,

I'm wondering if you can display some other measure instead of frequency in a geographical map using dynamic clustering based on coordinates. It seems to always display the frequency instead of the selected data item that the geo data item is based on.

Cheers, Frank

Re: Error importing XML file with automap in SAS Viya

Frank_Boekamp — Tue, 30 Apr 2019 17:49:40 GMT

Reading and writing XML is working fine using next code;

filename xml_in filesrvc folderpath='/Users/myname/test/' filename='xml_in.xml';
filename xml_out filesrvc folderpath='/Users/myname/test/' filename='xml_out.xml';

data test;
	length line $ 32676;;
	infile xml_in lrecl=32767;
	file xml_out_out;
	input line;
	put _infile_;
run;

Using complete pathname, filename, and file extension in a filename statement seems not to work in SAS Viya.

So I'm puzzled what to do with the libname statement with the automap option.

libname xml_in xmlv2 xmlfileref=xml_in automap=replace xmlmap=xx_map;

Error importing XML file with automap in SAS Viya

Frank_Boekamp — Tue, 30 Apr 2019 17:12:17 GMT

Hi there,

I'm stuck with a piece of code that always worked on SAS 9.4. It should import a complex hierarchical XML file automatically to several SAS datasets. I can read the xml file in a datastep without any problems. But using the xmlv2 engine combined with automap option gives an error. The code I'm trying is this;

filename xml_in filesrvc folderpath='/Users/myname/test/' filename='xml_in.xml';
filename xx_map temp;
 
libname xml_in xmlv2 xmlfileref=xml_in automap=replace xmlmap=xx_map; 
proc copy in=xml_in out=work;
run; quit;

The error;

ERROR: The AUTOMAP= option accesses files that are specified with either a physical location or associated with a fileref device type of DISK or TEMP only.

any ideas?

Cheers,

Frank

Re: Fontsize titles in VA 8.3.1

Frank_Boekamp — Thu, 28 Mar 2019 08:00:36 GMT

Double the title clicking works fine, thanks

Re: How to import report items from a different report in SAS VA 8.2

Frank_Boekamp — Wed, 27 Mar 2019 15:52:50 GMT

can not find it in version 8.3.1

Re: Import other Report section in the current VA 8.3 report

Frank_Boekamp — Wed, 27 Mar 2019 15:49:49 GMT

I also miss this functionality.

Fontsize titles in VA 8.3.1

Frank_Boekamp — Wed, 27 Mar 2019 15:45:41 GMT

Hi there,

I'm missing a property to set fontsize for titles of graphs in SAS VA 8.3.1. Where can I set this?

Cheers,

Frank

Re: SAS VA 8.3 problem with word wrap in Listtable

Frank_Boekamp — Fri, 22 Feb 2019 13:10:55 GMT

The problem is solved by our hosting provider. Thanks for your support

Re: SAS VA 8.3 problem with word wrap in Listtable

Frank_Boekamp — Thu, 21 Feb 2019 18:25:13 GMT

Hi Madelyn,

I looked more into this issue: it's not just a problem with the 'text wrap' property but it seems to have this effect on certain other properties in the Listtable as well, like properties from the Style group and from Cells and Table group. And the issue also manifests in other objects like in a bar chart with certain properties. I can not open a part of the reports anymore because of this issue.

The behavior is very consistent, some properties never give a problem, others always give a problem. I tried different browsers with same results.

The about dialog box you mention I can not find, can you give me a hint where I can find this?

Maybe following helps you: these are the first two XML lines (from the BIRD editor) of a SAS VA report:

<?xml version="1.0" encoding="UTF-8"?>
<SASReport xmlns="http://www.sas.com/sasreportmodel/bird-4.1.2" label="mytest4" createdLocale="en" createdVersion="4.1.2" dateCreated="2019-02-21T17:17:18Z" dateModified="2019-02-21T18:17:06Z" createdApplication="SAS Visual Analytics 8.3.1" lastModifiedApplication="SAS Visual Analytics 8.3.1" nextUniqueNameIndex="102">

From the Environment Manager I see no log messages at all, so no errors there.

Maybe following will help you: the XML code (from the BIRD editor) of a SAS VA report with an issue after I tried to save it:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?><error errorCode="0" httpStatusCode="500"><details><detail>correlator: 1027d51d-6812-40f3-aa0f-6c67778d85da</detail><detail>traceId: d6484a4db7a82fba</detail><detail>path: /reports/content</detail></details><links/><version>2</version></error>

Cheers,

Frank

Re: SAS VA 8.3 problem with word wrap in Listtable

Frank_Boekamp — Thu, 21 Feb 2019 15:10:48 GMT

I tried different datasets and they all give the same result when checking 'word wrap' in a listtable and saving the report:

'An error was encountered saving the report'

I enclosed print-screens of an example with a good oldie dataset (sashelp.class)

SAS VA 8.3 problem with word wrap in Listtable

Frank_Boekamp — Thu, 21 Feb 2019 13:04:19 GMT

I get an error saving a report with a list table with word wrap property set to yes.

Is this a bug and can this be fixed quickly please?

Re: missing values using AggregateCells operator in SAS VA 8.3?

Frank_Boekamp — Tue, 19 Feb 2019 15:47:04 GMT

Thanks Sam

missing values using AggregateCells operator in SAS VA 8.3?

Frank_Boekamp — Tue, 19 Feb 2019 10:10:50 GMT

I'm using the (new) AggregateCells operator for calculating a moving average in SAS VA 8.3 like below

AggregateCells(_Average_, My measure, default,CellIndex(current, -4), CellIndex(current, 0))

Problem is that the first 4 periods return values instead of missing values. So for example for period 1 the moving average is calculated is an average of just the value of period 1. For period 2 the moving average is calculated is an average of just the values of period 1 and period 2. etc. This is not correct behavior in my opinion: I would not expect to see values for the first 4 periods when using this operator.

What can I do to show correct results?