Recently in the SAS Community Library: SAS' @Sundaresh1 highlights a sometimes overlooked task when applying document embeddings for purposes of similarity-based search. Normalisation of vectors helps obtain relevant matches.
hello, I want to find the first record: the value is 1 and lasted 24 hours, like my picture: in obs 1,the value is 1 and the record after 24h is obs 4,but between these two records is a record with AVALCN=0,so obs 1 is N; in obs 2 ,the value is 1 and the record after 24h is obs 5,but between these two records is a record with AVALCN=0,so obs 2 is N; in obs 3,AVALCN=0 ,,so obs 2 is N; in obs 4,,the value is 1 and the record after 24h is obs 6,the value between these two records is 1 ,so obs 4 is Y; in obs 5,the value is 1 ,no records were obtained after 24h,so obs 5 is N;
... View more
proc export
data=sashelp.class
outfile="TEST1"
dbms = xlsx replace;
run;
proc export data=sashelp.class
outfile="TEST1"
dbms=xlsx
replace;
run;
I'm trying to append an existing file using Proc export, but it didn't work.
i want this ouput
... View more
My default region is Europe, but I need to create a course for PharmaSUG on the server for United States 1. How do I create an account away from my default region?
... View more
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