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 used to work on SAS base desktop where I was able to export SAS data to external excel files. However, I am currently working on SAS Viya on Linux server. How could I do the same and export from SAS Viya to physical disk? ... View more

Proc export giving additional quotes to the quoted char values.and if u use data step for that it is giving a space or . To numeric values which is not required . Needs to change nothing.now it is , , but want ,, no space no .for missing numeric value. ... View more

Could someone please clarify for me the difference between table probability and two-sided PR in a Fischer's exact test?   which result should be consider as a p-value indicating the probability that the distribution in the table is random?   Zachi   ... View more

When I converted the dataset with %xpt2loc I found that creating the XPT in V8 format via %loc2xpt was missing the dataset labels. Dose anyone know about it? Thanks! ... View more