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 am getting the following error messages when trying to merge two datasets. One of the datasets I am getting from a csv file, so maybe the issue could be there? I was trying to specify the length of the PID variable for the redcap_sort dataset from the redcap one, which is the one we got from the csv file. However, I keep getting messages that the variable has multiple lengths and it keeps truncating the data. Any PID after 999 gets shortened. So 1000 and 1001 become 100, 1010 becomes 101, etc. Any help or a nudge in the right direction would be greatly appreciated, thank you so much. Edit: The programming with the csv file already has: data work.redcap; %let _EFIERR_ = 0;
infile &csv_file delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=1 ;
informat pid $500. ;
informat pid_ini $500. ; and the code for format: format pid $500. ; It has this for all the variables. I thought the above code would make it so that the variables would have that limit of 500 characters?
... View more
I'm trying to follow the code on this site Test for the equality of two proportions in SAS - The DO Loop for the section called A chi-square test for association in SAS. I basically need to compare the proportion in one area which was tested for something to the proportion in another area which was tested and see if they are significantly different proportions, but I can't get the code to work right. I get this error:
NOTE: Invalid data for N in line 79 1-6.
RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0
79 CountyB Yes 71
Group=CountyA Seq=No N=. _ERROR_=1 _N_=2
NOTE: SAS went to a new line when INPUT statement reached past the end of a line.
My full code is:
data underfive; length Group $15 Test $3; input Group Test N; datalines; CountyA Yes 55 CountyA No 45027 CountyB Yes 71 CountyB No 311726;
Once I had that in I figured I would run this:
proc freq data=underfive order=data; weight N; tables Group*Test/chisq; run;
... View more
Hi all,
I am trying to use SAS to append a dataset into a SQL table.
I am using this code (modified the table names). My dates are in YYDDMM10. format, numeric = type, length = 8, informat =10. and they cannot be appended because of type of mismatch. The variables in the SQL table is set to the data type = "date" and it has allow nulls checked off.
any help is appreciated!! >.<
libname Dummy odbc dsn='Dummy_data' schema=stg;
data org.procedures;
set procedures;
RunDate = today();
format RunDate date9.;
if firstobs then Obs_ID = 1;
else Obs_ID +1;
run;
*remove exisiting data from table;
data Dummy.data_Numerators;
modify Dummy.data_Numerators;
if Obs_ID not = '.0y' then
remove Dummy.data_Numerators;
run;
*append new data to table;
proc append data= org.procedures base = Dummy.data_Numerators force; run;
... View more
Hello SAS Community, I am seeking guidance on how to graphically display a multiple linear regression line with a binary*continuous interaction using PROC SURVEYREG. My model is as follows: model continuous_outcome = predictor1 (continuous) + predictor2 (continuous) + predictor3 (continuous) + gender (binary)*predictor1 + gender* predictor2 + gender*predictor3 + covariates (continuous + categorical); My goal is to create multiple graphs to visualize the main effects of the predictors and gender, as well as the interaction effects. Unfortunately, I am currently unable to test the code myself as the SAS Studio is undergoing scheduled maintenance. If anyone has experience with this type of analysis and graphing approach, I would greatly appreciate if you could share helpful links, code snippets, or any guidance that could assist me in achieving this visualization. Any insights or recommendations would be invaluable in helping me effectively present and interpret the results from this moderated regression analysis. Thank you in advance for your assistance!
... View more
Can you guide me the connection setup guide for GoogleBIG Query from SAS9.4 M8 on RHEL?.
We do have license to SAS Access Interface to BigQuery, making direct connection using libname statement through credentail file using BigQuery engine is not working even though we have a 443 port enabled from the server.
... View more