data have1; My data have 240 variables that are named sequentially VAR_1 to VAR_240. I want to change the name on the variables to read like this: VAR 001  VAR 002   .....VAR  069..... VAR125.......VAR  240. Below is how the data looks like and I import it using proc import.   Thank you   infile datalines dlm=','; input id $ VAR_1 VAR_2 VAR_3 VAR_4; datalines; 1,4.19855,5.74574,33.46678,6.85391 3,3.48004,6.69138,31.85662,11.73753 4,3.33851,5.74293,36.09064,10.9801 9,3.2966,8.15718,30.27008,7.62836 ; run;    ... View more

I have two separate datasets  of dimension 80x200. Patients and variables are identical and in the same order. We want to compare the two datasets. We want to have the Bland Altman plot on each of the variable.  In the case of comparing only one variable there is a procedure. The two measurements are included in the same dataset  (https://www.tutorialspoint.com/sas/sas_bland_altman_analysis.htm), but my data has 200 variables.   Is this something doable?   I put here two examples of dataset that I made up for illustration on how my data looks like (but with more variables).   Thank you   data1: id,C1,C2,C3,C4 1,4.10855,5.44574,33.16678,6.75791 3,3.48004,6.29138,31.34662,10.38753 4,2.33851,5.84293,35.79064,11.0801 9,3.1966,7.15718,30.27008,7.49836     data2:   id,C1,C2,C3,C4 1,4.19855,5.74574,33.46678,6.85391 3,3.48004,6.69138,31.85662,11.73753 4,3.33851,5.74293,36.09064,10.9801 9,3.2966,8.15718,30.27008,7.62836     ... View more

I have 80 patients measured on 200 variables at two timepoints. Two separate datasets were generated with identical IDs of patients and identical variables in the same order. I'm intrested  in the effect between the two timepoints by substracting each variable from  its corresponding in the other dataset.  I give examples of the datasets.   Thank you   data1: id,C1,C2,C3,C4 1,4.10855,5.44574,33.16678,6.75791 3,3.48004,6.29138,31.34662,10.38753 4,2.33851,5.84293,35.79064,11.0801 9,3.1966,7.15718,30.27008,7.49836     data2:   id,C1,C2,C3,C4 1,4.19855,5.74574,33.46678,6.85391 3,3.48004,6.69138,31.85662,11.73753 4,3.33851,5.74293,36.09064,10.9801 9,3.2966,8.15718,30.27008,7.62836 ... View more

I have dataset with patients' IDs numbered in no sequential way. I want to make change to all the IDs. For example patient 002 would be after the change: F1-1-KIDN-002.  It is just adding  "F1-1-KIDN-" in front of the original ID. I give an example of how the data looks like.   Thank you   id,C1,C2,C3,C4 002,4.19855,5.74574,33.46678,6.85391 007,3.48004,6.69138,31.85662,11.73753 009,3.33851,5.74293,36.09064,10.9801 020,3.2966,8.15718,30.27008,7.62836         ... View more

I have two large data each is 80x200. The values generated during the experiment are 100 % identical.  These two data  were complied by two different indivduals; a statistician and a chemist. After being compiled I want to,compare if the data are identical in terms of the values. The chemist uses an id of the sample that is long to describe location, study name, patient’s id….., Statistician uses only patient’s number. The variables in the column are the same and in the same order. Samples in rows  are  not in the same order. Irrespective of how the smples were named  and in the order I want to verify that the two data are identical. Can this be done? For that I have two examples of very small data that I changed their id and the order of the rows Thank you   id,C1,C2,C3,C4 1,4.19855,5.74574,33.46678,6.85391 3,3.48004,6.69138,31.85662,11.73753 4,3.33851,5.74293,36.09064,10.9801 9,3.2966,8.15718,30.27008,7.62836     id,C1,C2,C3,C4 KIND-009,3.2966,8.15718,30.27008,7.62836 KIND-003,3.48004,6.69138,31.85662,11.73753 KIND-001,4.19855,5.74574,33.46678,6.85391 KIND-004,3.33851,5.74293,36.09064,10.9801   ... View more

My data has dimension of 80x200  patients in rows and variables in column.  I want  to calculate the %RSD of each variable.  %RSD= (standard deviation of each variable / mean of variable)*100   The data looks  like this:    ID,gender,AL,BK,MS,DF 2,F,13.4,7.3,-15.2,9.2 3,M,12.1,5.1,17.2,8.85 5,M,10.8,2.9,49.6,8.5 7,F,9.5,0.7,82,8.15 Thank you ... View more