BookmarkSubscribeRSS Feed
weibao
Calcite | Level 5

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.

3 REPLIES 3
VenuKadari
SAS Employee

proc sort will not work in CAS environment.

 

What is your end goal?

Zengahoe
Calcite | Level 5

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.

Madelyn_SAS
SAS Super FREQ

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

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 835 views
  • 0 likes
  • 4 in conversation