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.
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
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
Hi I am new to proc template . 1. I am displaying bar value at the top of bar using barlabel=true. How to display the value at the center of the bar instead of top? 2. Also, how to wrap x axis value. text variable have one value very long 3. what option in proc template i can use to display P value at the top. Thanks in advance
... View more
Good morning, I'm currently analyzing a much larger database than I'm used to. For this analysis I need to use the proc mixed with repeated measures, however when I test the covariance matrices and use the command DDFM=KR or DDFM=kr2 I have two problems: 1- the script does not work due to lack of memory even using options memsize=; independent of how much memory you use (max obs used 20G) 2- The DEN F appear as infinite, However, I was unable to understand the differences between DDFM= betwithin, contain, kenwardroger, kenwardroger2, residual or satterthwaite. Here is the model used: PROC MIXED; CLASS id_Animal TRT day; MODEL visit = TRT dday trt*ddai / ddfm= ?? ; RANDOM id_Animal ; REPEATED day /TYPE = ?? SUBJECT = id; RUN;
... View more