Hi All
One of our teams is working on data that must be used in marketing campaigns using SAS CI Studio. The output they produce is stored in parquet files. I need to import that data into SAS using SAS 9.4. Based on my research, it looks like we will need SAS/ACCESS interface to ODBC. I would just like to confirm that this is the only way before I request that (cost implication).
Many thanks!
... View more
Dear All, I was trying to look for references on how to convert SAS script to PMML format but unsuccessful hence I posted here. The SAS script looks like below. The sample below is when PMML script is converted to SAS using proc pscore. Now, I want to know if there is a way if SAS to PMML. Thank you. length "a_segment"n $57 ; length "a_segment_new"n $62 ; "PSCR_TEMP_FINAL_PRED_VAR"n = 0; if ( "cohort"n eq 'AAA' ) then do; if ( missing( "a_score_id"n ) or missing( "a_score"n ) or ( ( "a_score_id"n ne 'XXX' ) & ( "a_score_id"n ne 'YYY' ) ) ) then do; "a_segment"n = 'SEG_A'; end; end; ... else if("a_segment"n eq 'SEG_A') then "a_segment"n = 'SEG_A' ; else if("a_segment"n eq 'SEG_B') then "a_segment"n = 'SEG_B' ; PSCR_EXIT : drop "PSCR_TEMP_FINAL_PRED_VAR"n "PSCR_ATTRIBUTE_MATCH"n;
... View more
I've deleted SAS 9.4M5 in order to install SAS 9.4M8 on my PC.
I've run this program to check my graph setting.
I've tried with SAS Fundation and SAS Enterprise Guide
proc freq data=sashelp.class;
table sex / plots=freqplot;
run;
But get the following error message:
ERROR: The Java proxy is not responding.
ERROR: The Java proxy's JNI call to start the VM failed.
ERROR: Unable to load the Java Virtual Machine. Please see the installation instructions or
system administrator.
ERROR: Unable to load the Java Virtual Machine. Please see the installation instructions or
system administrator.
I've run
proc options option=jreoptions;
run;
Here is my output
JREOPTIONS=( -DPFS_TEMPLATE=C:\Program Files\SASHome\SASFoundation\9.4\tkjava\sasmisc\qrpfstpt.xml
-Djava.class.path=C:\PROGRA~1\SASHome\SASVER~1\eclipse\plugins\SASLAU~1.JAR -Djava.security.auth.login.config=C:\Program
Files\SASHome\SASFoundation\9.4\tkjava\sasmisc\sas.login.config -Djava.security.policy=C:\Program
Files\SASHome\SASFoundation\9.4\tkjava\sasmisc\sas.policy -Djava.system.class.loader=com.sas.app.AppClassLoader
-Dlog4j.configurationFile=file:/C:/Program%20Files/SASHome/SASFoundation/9.4/tkjava/sasmisc/sas.log4j.properties
-Dsas.app.class.path=C:\PROGRA~1\SASHome\SASVER~1\eclipse\plugins\tkjava.jar -Dsas.ext.config=C:\Program
Files\SASHome\SASFoundation\9.4\tkjava\sasmisc\sas.java.ext.config
-Dsas.jre.libjvm=C:\PROGRA~1\SASHome\SASPRI~1\9.4\jre\bin\server\jvm.dll
-Dtkj.app.launch.config=C:\PROGRA~1\SASHome\SASVER~1\picklist -Xms128m -Xmx512m )
Specifies the Java Runtime Environment options for SAS.
I've seen that answer but I don't know which java version to go for? Java 11?
https://communities.sas.com/t5/SAS-Procedures/ERROR-The-Java-proxy-is-not-responding/m-p/149423#M39428
... View more
Esteemed Advisors:
I am trying to interleave two datasets with a condition that the resulting dataset contains only observations that can be found in both of the two datasets.
Below is exemplar code to illustrate the problem. If you run this code and inspect dataset interleave2 you will see that for a group of 3 observations where target=1, two came from Random_A and one came from Random_B. Likewise, for a group of three observations where target=2, two came from Random_B and one came from Random_A. All of these observations need to be retained in the desired dataset.
For the group of 3 observations where target=3, all observations came from Random_B only. These are ones that need to be omitted. All observations for a given target that come from a single source dataset are not to be retained in the desired dataset.
The challenge for me (and now for you) is to come up with the code that will interleave Random_A and Random_B such that the resultant dataset that only contains the groups of targets that are present in both datasets.
Hope this makes sense and thanks for taking a look,
Gene
data Random_A (drop=i);
call streaminit(4786);
do i=1 to 100;
Source="A";
Target=rand("Integer",1,100);
ST=catx('/',Source,Target);
output;
end;
data Random_B (drop=i);
call streaminit(6874);
do i=1 to 150;
Source="B";
Target=rand("Integer",1,100);
ST=catx('/',Source,Target);
output;
end;
Proc sort data=Random_A;
by ST;
run;
Proc sort data=Random_B;
by ST;
run;
data interleave1;
set random_A random_B;
by ST;
run;
proc sort data=interleave1 out=interleave2 nounikey;
by target;
run;
... View more
Some years ago when I installed SAS Studio 3.7 (SAS9.4M5) on Windows 10 (Single User PC Licence), I specified the JRE Location as given in this post.
https://communities.sas.com/t5/SAS-Studio/JRE-location-for-downloaded-SAS-Studio/m-p/327473
I've uninstalled SAS on my PC in order to reinstall SAS 9.4M8 which comes with SAS Studio 3.82.
The SASPrivateJavaRuntime is now named SASPrivateJavaRuntimeEnvironment.
I've tried pointed to:
C:\Program Files\SASHome\SASPrivateJavaRuntimeEnvironment\9.4\jre
C:\Program Files\SASHome\SASPrivateJavaRuntimeEnvironment\9.4\jre\bin
C:\Program Files\SASHome\SASPrivateJavaRuntimeEnvironment\9.4\jre\bin\server
I've also tried to create a copy of the folder and name it as it was named before and test it again i.e.
C:\Program Files\SASHome\SASPrivateJavaRuntime\9.4\jre
C:\Program Files\SASHome\SASPrivateJavaRuntime\9.4\jre\bin
C:\Program Files\SASHome\SASPrivateJavaRuntime\9.4\jre\bin\server
While installing SAS I also got this error which could be the reason for the issue:
I didn't find a way to rerun the installation to attent to complete this step properly.
Do you have any suggestion because I consider creating a ticket by SAS support?
... View more