topic Re: how to sort a dataset in SAS VA data steps in SAS Visual Analytics

how to sort a dataset in SAS VA data steps

weibao — Mon, 17 Dec 2018 23:54:08 GMT

I'm new to SAS and creating a plan in SAS data studio. First step I want to sort the dataset.

Here's my code:

proc sort data={{_dp_inputTable}} (caslib={{_dp_inputCaslib}}) out={{_dp_outputTable}} (caslib={{_dp_outputCaslib}});
by geo;
run;

But it's not working somehow. Here's the help from SAS data studio below:

You must use variables in place of table and caslib names. Errors will occur if you use literal values. This is because session table names can change during processing.

The following variables are available: _dp_inputCaslib, _dp_inputTable, _dp_outputCaslib, and _dp_outputTable. For DATA step only, variables must be enclosed in braces, for example, data {{_dp_outputTable}} (caslib={{_dp_outputCaslib}});.

Can anyone help me? much appreciate.

Re: how to sort a dataset in SAS VA data steps

VenuKadari — Mon, 07 Jan 2019 15:58:51 GMT

proc sort will not work in CAS environment.

What is your end goal?

Re: how to sort a dataset in SAS VA data steps

Zengahoe — Thu, 19 Aug 2021 02:00:40 GMT

Hi I am also facing the same problem

/* BEGIN data step with the output table data */
data {{_dp_outputTable}} (caslib={{_dp_outputCaslib}} promote="no");
/* Set the input set */
set {{_dp_inputTable}} (caslib={{_dp_inputCaslib}} );
/* END data step run */
run;

I am trying to proc sort by a Key then to do a First.Key. But I dunno how to refer to the dataset. Thanks.

Re: how to sort a dataset in SAS VA data steps

Madelyn_SAS — Fri, 20 Aug 2021 16:08:43 GMT

I suggest posting this in the SAS Programming or SAS Procedures community instead.