How to create a tabulated report based on data:
Column CATEGORY in H means a horizontal report. TITLE_LEVELS indicate how many levels of title there are. TITLE_LEVEL1 is the main header, TITLE_LEVEL2 is the sub-header of TITLE_LEVEL1, and TITLE_LEVEL3 is the sub-header of TITLE_LEVEL2.
All columns are Character data type
proc tabulate data=datset;
class TITLE_LEVEL1 TITLE_LEVEL2 TITLE_LEVEL3 Column1 ;
table TITLE_LEVEL1*
TITLE_LEVEL2*TITLE_LEVEL3;
run;
i have data
i want
PFA
... View more
I have a dataset structured as repeated measurement and Mixed model for repeated measurement is used for analysis. The standard code to get average change from baseline (note that here we are comparing baseline with the mean of the last 4 visits) and the associated p-value has been posted below. I wonder based on this, how can I test the non-inferiority using a margin of -1, e.g., change from baseline is greater than -1. The null hypothesis is that this change will be smaller or equal to -1. Can anyone suggest how to write SAS for this test? proc mixed data=mydata;
class id visit sex(ref='F');
model change = age sex baseline visit*baseline/ ddfm=kr fullx;
repeated visit / subject = id type = un;
lsmeans visit ;
estimate 'Average' Intercept 1 age 1 sex 0.5 0.5
visit 0 0 0 0 0 0.25 0.25 0.25 0.25 base & basemean
visit*base 0 0 0 0 0 &basemean1 &basemean1 &basemean1 &basemean1 / cl;
run;
... 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