DATA ALT; SET RCA.CLOSING_STATUS_TEST; ARRAY COLS[*] _CHARACTER_; ARRAY COLS_[*] _CHARACTER_; DO I = 1 TO DIM(COLS); IF MOD(I, 2) = 1 THEN COLS_[(I+1)/2] = COLS[I]; END; DROP I; RUN; Hi, I have been trying to select the alternate columns. If I am using this code then my third column's data shifts to second column and second's values are disappearing.  I want to select alternate columns from my data set and my column names are in following: LOAN_NO, PRODUCT, FINAL_STATUS_05MAY24,DUE_N_TAG_05MAY24, FINAL_STATUS_06MAY24,DUE_N_TAG_06MAY24, FINAL_STATUS_07MAY24,DUE_N_TAG_07MAY24,... and so on. I want to create a table selecting columns:-  LOAN_NO, FINAL_STATUS_05MAY24, FINAL_STATUS_06MAY24, FINAL_STATUS_07MAY24... and so on. If there is any alternate approach for making the selection, please advise me or please help with the given array code.      ... 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=&regi;       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=&regi                    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

Hi all,   I am doing multiple linear regression using proc survreg and want to test interaction between stressors and gender. I want to know if my codes below are correct for the model 1 and model 2. I really appreciate any feedback.   This was a list of variables I used for the analysis. Gen2_cat= gender (binary) ethnicity_group= ethnicity (4 categorical) maritalstatus_dummy=marital status (binary) nativity2=nativity (binary) COVID_ImpactOverall_new= continuous FAsocitalracism= continuous Socialstressors4= continuous materialstressors4 = continuous Age_BirthYear_Calculate= continuous miss_binary('1') = complete sample   /*Model1: Interaction Stressors*Gender – Interaction Testing*/ proc surveyreg data=mental8 alpha=0.05; /*alpha-set alpha level*/ class gen2_cat (ref="0") ethnicity_group (ref="0") maritalstatus_dummy (ref="0") nativity2_cat (ref="0"); /*reference*/ model COVID_ImpactOverall_new= FAsocitalracism socialstressor4_v1 materialstressors4 FAsocitalracism*gen2_cat socialstressor4_v1*gen2_cat materialstressors4*gen2_cat Age_BirthYear_Calculate gen2_cat ethnicity_group maritalstatus_dummy nativity2_cat income_new_n edu5_cat_n/solution CLPARM STB ADJRSQ;/*CLPARM=display 95%CI*/ weight WEIGHTS_A7; domain miss_binary('1'); run; The interaction between stressors and gender I got : FAsocitalracism*gen2_cat : p=0.3537 socialstressor4_v1*gen2_cat : p=0.015 materialstressors4*gen2_cat : p=0.486 Since interaction social stressor and gender was significant, I would like to stratify the model by gender. In this case, should I include all stressors or just social stressor in the stratified model?   /*Model2: Stratified by Gender*/ proc surveyreg data=mental8 alpha=0.05; /*alpha-set alpha level*/ class gen2_cat (ref="0") ethnicity_group (ref="0") maritalstatus_dummy (ref="0") nativity2_cat (ref="0"); /*reference*/ model COVID_ImpactOverall_new= FAsocitalracism socialstressor4_v1 materialstressors4 Age_BirthYear_Calculate ethnicity_group maritalstatus_dummy nativity2_cat income_new_n edu5_cat_n/solution CLPARM STB ADJRSQ;/*CLPARM=display 95%CI*/ weight WEIGHTS_A7; domain miss_binary('1')*gen2_cat; /*stratify by gender*/ run; Also, I want to know how I can get predicted mean mental health by stressors (i.e., FAsocitalracism, socialstressor4, materialstressors4) for female and male in proc surveyreg and create a graph based on the results (like the graph I attached below).      I would appreciate if you could help me with this! Thank you in advance! Looking forward to your response!!!   ... View more

Importing several delimited text files (by pipe: |). actual lengths of fields can vary.   Several character strings contain tabs and carriage return type characters, which is throwing out the INFILE. The records themselves appear on a single row in the file. Character strings are not surrounded by double quotes.   Affected data is free form text fields, from copy-paste (emails and similar).   Proc import was originally tried but even with guessingrows max it isn't processing the file correctly. a basic SAS dataset with INFILE DLM and the like also processes the file incorrectly.   Eventually used SAS Enterprise Guide's inbuilt "Import" function. This does read the correct number of records. But also caused fields to be read in with odd positioning: field A becomes field B and so on.   Any thoughts? ... View more