topic Re: Use of CAS data step - what functions and features aren't available? in SAS Viya

Use of CAS data step - what functions and features aren't available?

phopkinson — Tue, 04 Jun 2024 14:05:17 GMT

Hi,

I am trying to run some code in compute but am struggling with the runtimes, have tried running the code in CAS but it is coming up with an error, does CAS support the use of macros or not because my process largely relies arrays and macros?

Re: Use of CAS data step - what functions and features aren't available?

Mazi — Tue, 04 Jun 2024 14:35:24 GMT

Hi, Unfortunately Macros do not execute on the CAS server. https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.2/mcrolref/n0ch1ei5629ioxn13clvseqif3wi.htm
Are you able to identify why your code is not executing speedily?
Are your input tables large? searching through an unindexed dataset?

Re: Use of CAS data step - what functions and features aren't available?

phopkinson — Tue, 04 Jun 2024 14:44:55 GMT

Ok, so do macro variables resolve in CAS or not?

Re: Use of CAS data step - what functions and features aren't available?

Mazi — Tue, 04 Jun 2024 14:52:15 GMT

%macro test(name=);
	libname casuser cas caslib="casuser";
	data casuser.test;
		x=1;
		name="&name";
	run;
%mend test;
%test(name=John Doe)

MPRINT(TEST):   data casuser.test;
MPRINT(TEST):   x=1;
MPRINT(TEST):   name="John Doe";
MPRINT(TEST):   run;
NOTE: Running DATA step in Cloud Analytic Services.
NOTE: The DATA step has no input data set and will run in a single thread.
NOTE: The table test in caslib CASUSER(XXXXX) has 1 observations and 2 variables.
NOTE: DATA statement used (Total process time):
      real time           0.52 seconds
      cpu time            0.05 seconds

Does this answer your question?

Re: Use of CAS data step - what functions and features aren't available?

phopkinson — Tue, 04 Jun 2024 14:55:56 GMT

Thanks that's helpful, I'm quite new in terms of using Viya so some of this probably seems quite a dumb question but I do appreciate it.

Re: Use of CAS data step - what functions and features aren't available?

Mazi — Tue, 04 Jun 2024 14:59:36 GMT

No problem at all. If you can share more about what errors you are facing maybe we can advise you accordingly.

Re: Use of CAS data step - what functions and features aren't available?

Rick_SAS — Tue, 04 Jun 2024 16:55:29 GMT

For a discussion of the DATA step and which functions can run in CAS, see the article,

"A list of SAS DATA step functions that do not run in CAS"