New_id     Old_id 1 2              1 3 New_id      Old_id           Updated_Id 1                                            2 2                  1                        2 3                                            3   Need help in updating the new_id when there is an old id exists. In the above case New_Id "2"  has old_id "1". So the updated_id is "2" for the new_ids "1" and "2".    ... View more

ID Visit Test res 1001 Screen Height 170 1001 Screen Weight 82 1001 Screen Height   1001 Screen Weight 82 1001 Day 1 Height 170 1001 Day 1 Weight 89 1001 Day 1 Height 170 1001 Day 1 Weight   1002 Screen Height 180 1002 Screen Weight 95 1002 Day 1 Height 180 1002 Day 1 Weight 95                                   How to get Height and Weight per visit and get them multiple times if they are different as below:   ID 1001 taking the non missing value for height. for weight taking non missng value but the weights are different on screen and day1 visits so we get 3 records. ID 1002 ,height and weight are same during screen and day 1 so we get two records:   ID Visit Test res 1001 Screen Height 170 1001 Screen Weight 82 1001 Day 1 Weight 89 1002 Screen Height 180 1002 Screen Weight 95 ... View more

There are some variables that end in "zz". How to rename only those variables by removing "zz" from variable name? For example Temperaturezz should be renamed to Temperature. ... View more

How to split raw_variable into multiple variables of lengths 20 and not to break a word.   i.e in below example "acerbic soluable dio" is not the way to split it. dioxide;zinc goes to other variable and so on.   raw_variable acerbic soluable dioxide;zinc titanium   Raw_var1                               Raw_Var2                  Raw_var3 acerbic soluable                     dioxide;zinc                 titanium   Thanks for the help! ... View more

If data contains only digits or digits with decimals then would like to create a column "want" and assign those records to the column. tried compress function but it is compressing decimals too.  Rawdata UNKNOWN 37.5/25 37.5-25 0.25 25 10 1000IU Rawdata         want              UNKNOWN                      37.5/25                             0.25                0.25 25                    25 10                   10 1000IU                              ... View more

Hi All,   I have a dataset with same variables starting with underscore and without underscore. I would want to assign (in a loop)all underscore varaibles to those without undsrscore. can you help me on this? For eg. _id     id      _name   name   hardcoding I can do this way: _id=id; _name=name;     ... View more

I would like to make changes in all SAS programs in a folder.  For example I would like to replace "Apple"  with  "Orange" in all the programs that has "Apple". Is there a way to it in one shot? ... View more

  Is there a way to pass macro parameters as shwon below where it can handle a straight assignment or a if statement:     %macro test(var1=);       %mend test; %test(var1=abc); %test(var1= (if x=1 then var1='blah';                      else var1='blah blah');                    ); ... View more