topic How to replace value with Another Row value in SAS from Data Set in Developers

How to replace value with Another Row value in SAS from Data Set

Shuail_Ibrahim — Thu, 16 Apr 2020 11:52:57 GMT

How to replace if the value is 1 with the below row value "Weight" find the below image current data set and the final output required,

please any one help how to get the final required dataset

Re: How to replace value with Another Row value in SAS from Data Set

Tom — Thu, 16 Apr 2020 11:59:09 GMT

Why did you post photographs of 25 numbers? Wouldn't it have been easier to just type (or paste) the numbers directly into your question? It certainly would be easier to deal with.

First step is the split the original mish-mash into two datasets. One with the actual employee data. And the other with the WEIGHT data. Now you can combine them. It looks like you just want to multiple the value of TEST1 times the value of WEIGHT1, TEST2 times the value of WEIGHT2 etc. Do not attempt to add the extra row back into the result. If you need to re-create your photograph do that as a report.

Re: How to replace value with Another Row value in SAS from Data Set

Ksharp — Fri, 17 Apr 2020 12:21:22 GMT

Plz post the data step code ,NOT picture , nobody would like to type it for you.

data have;
input id $ test1-test4;
cards;
1 0 0 0 1
2 1 0 0 0
3 0 0 1 0
4 0 0 0 0
weight 1.412 0.207 0.207 0.207
;
data want;
 set have;
 if _n_=1 then set have(keep=test1-test4 
 rename=(test1-test4=t1-t4)) point=nobs nobs=nobs;
array x{*} test1-test4;
array y{*} t1-t4;
do i=1 to dim(x);
 if x{i} then x{i}=y{i};
end;
drop i t1-t4;
run;