I am running the below code in SAS university Studio & Keep encountering the below Error.
Error: The data set perm.EX1 must be a CAS engine libref.
I am unable to figure out, how to create a CAS engine libref.
**********************************************************************************************;
libname perm '/folders/myfolders/Data';
data mycas.ex1; length id 8; do id=1 to 1000000; x1 = ranuni(101); x2 = 10*ranuni(201); output; end; run;
proc binning data=mycas.ex1 numbin=10 method=quantile;
input x1-x2;
output out=mycas.out1;
run;
CAS is part of SAS Viya which isn't available in SAS UE. SAS UE is based on SAS 9 only.
Is there a way for me to Quantile Binning on SAS UE?
Since proc Binning only accepts CAS libname statements.
@Sai-Reddy - According to this link PROC HPBIN may provide what you want: https://support.sas.com/kb/30/333.html
Proc HPBin does not work on SAS UE, I tried that before doing Proc Binning.
@Sai-Reddy - Perhaps someone more statistically-minded like @Reeza might be able to help.
PROC RANK should give you the same answer.
You could also do it manually via a data step, see this post here for an example:
https://blogs.sas.com/content/iml/2019/08/05/proc-hpbin-bin-variables-sas.html
proc rank data=mycas.ex1 groups=10;
var x1-x2;
ranks rank1 rank2;
run;
@Sai-Reddy wrote:
I am running the below code in SAS university Studio & Keep encountering the below Error.
Error: The data set perm.EX1 must be a CAS engine libref.
I am unable to figure out, how to create a CAS engine libref.
**********************************************************************************************;
libname perm '/folders/myfolders/Data';
data mycas.ex1; length id 8; do id=1 to 1000000; x1 = ranuni(101); x2 = 10*ranuni(201); output; end; run;
proc binning data=mycas.ex1 numbin=10 method=quantile;
input x1-x2;
output out=mycas.out1;
run;
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.