Hi i have 3 datasets a,b,c and the names for dataset A=cus_name and in dataset B the name is F_name and in datset C the name is l_name now i want to create a dataset D and set all the three datasets .But i wnat to keep a condition like if cus_name,F_name and l_name then the name of the variable should be made to final_name in the final dataset D.and all the three variable obs should come in to the variable as final_name .The observations are different in all three datasets.(without using rename or label)
The post describes a "data interleave" technique, not a "data merge" requirement? I really don't understand why you would want to create an output file having observations where any one contributing variable name will be blank -- that will be the behavior result when using SET instead of considering somehow doing a MERGE (however you would need to have some BY variable list to use with a merge process.
Honestly, the purpose of this example, as described in your post, appears somewhat curious, given that you have mentioned "set", even though you really mean to do some type of merge, right?
I'm a bit baffled how this point wasn't raised previously with the post/thread, frankly.