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;
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.