Thoughts of a Crime Show Junkie: Inadmissible Evidence
Recent Library Articles
Recently in the SAS Community Library: SAS' @RhondaWilliams reveals how SAS Law Enforcement Intelligence helps law enforcement agencies expedite detailed data entry using the Evidence Creation feature.
Hello community,
I wanted to ask you if there is a way to read the rows from a csv file if starts with a specific string.
For example in this csv I want just the rows that starts with "2021-01", so the row that starts with 2021-09 will be deleted.
... View more
Hello Wondering if anybody has configured oracle Wallet on SAS Viya 4 on AWS using instant client basic ? If yes can you please share your experience?
... View more
Question 1: My project involves 2 x 2 factorial design where animals were either subjected to treatment A or B and drug C or D. Each treatment combination was housed in 4 different feedlot pens (AC=pen 1; AD=pen 2; BC=pen 3; BD= pen 4). All animals belonged to the same breed, sex, and age and were managed in similar way. Measurements were taken in seven repeated days (day 7, 21, 28, 35, 56, and 57) post-treatment and drug administration. Animal is my experimental unit and the variable response (individual body weight; BW) followed the ANOVA criteria. Is the model below correct? proc mixed data= XX; class animal treatment drug day; model BW = treatment|drug|day initial BW ddfm=kr; random intercept / subject = animal; repeated days / subject = animal type = cs; lsmeans trt|drug|day / adjust = tukey; run; Question 2: when I include the "adjust=tukey", although I observe significant effect (P<0.05) in the model, none of the adjust p-values are significant (only the non-adjusted p-values). Which p-value should I use when interpreting the p-values?
... View more
data two; input name $ qtr amount; datalines; adam 1 10 adam 2 20 adam 3 30 adam 4 40 ; run;
Need a code to produce below output using array and not proc transpose
output must be :
name qtr1 qtr2 qtr3 qtr4 adam 10 20 30 40
... View more
Hi everyone, I'm reaching out to the SAS community today seeking some guidance. Our team is currently in the process of transitioning from base SAS to SAS Studio and migrating our data storage from a local file server to Amazon S3. We've successfully uploaded all our historical datasets (in .sas7bdat format) from the local server to S3. However, we're encountering an issue when trying to load/read this data directly from S3 into CAS using SAS Studio. While I can perform various S3 bucket management tasks like creating, deleting, uploading data from CAS, and copying data between buckets, I'm unable to utilize PROC S3 to directly load data from S3 into CAS using .sas7bdat files. proc s3 keyid= &accesskey secret=&scaccesskey region=®i; get "/viya-data/AAI/Pertape/datasets/pt31mar24.sas7bdat" "/nfsshare/data/sasdata/S3Transit/pt31mar24"; run; While using PROC S3 if a file size smaller than 2MB then i am getting different error than above one ". I cross checked with my sas admin that we have read and write permissions. Here's the interesting part: I can successfully use PROC CASUTIL's LOAD function to read data from S3 in formats like .sashdat, CSV, or Excel. It's specifically the .sas7bdat format that seems to be causing the issue. caslib amz dataSource=(srcType="s3" accesskeyid=&accesskey secretaccesskey=&scaccesskey region=®i bucket="viya-data" objectpath="/AAI/Pertape/datasets/"); proc casutil incaslib=amz outcaslib="S3Transit"; load casdata="pt31mar24.sas7bdat" casout="tl_website_30apr24"; quit; Error message while using PROC CASUTIL : I'm wondering if anyone in the community has faced similar challenges when working with .sas7bdat files in S3 and CAS. If so, any insights or solutions you could share would be greatly appreciated. We are currently using SAS Viya LTS 2023.03 Thank you in advance for your time and assistance! -Bhaskar
... View more