topic Re: Reg:Variable names in SAS Procedures

Reg:Variable names

deleted_user — Tue, 16 Jun 2009 07:07:24 GMT

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)

data a;
input cus_name$;
cards;
nani
run;

data b;
input f_name$;
cards;
rani
run;

data c;
input l_name$;
cards;
raju
run;

output

final_name

nani
rani
raju

Re: Reg:Variable names

deleted_user — Tue, 16 Jun 2009 08:16:49 GMT

Hi,

Please try this..
I didn't get your requirement.
I tried with what i have understood

data d(drop=cus_name f_name l_name);
set a b c;
final=COALESCEC(cus_name,f_name,l_name);
run;

Regrds,
skm

Re: Reg:Variable names

deleted_user — Tue, 16 Jun 2009 19:29:35 GMT

Hi,
You can try the following:

data D;
set a(rename = (cus_name = Final_Name)
b(rename = (f_name = Final_Name)
c(rename = (l_name = Final_Name)
run;

Re: Reg:Variable names

sbb — Tue, 16 Jun 2009 19:36:35 GMT

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.

Scott Barry
SBBWorks, Inc.

Re: Reg:Variable names

deleted_user — Wed, 17 Jun 2009 03:46:05 GMT

I haven't used merge because in the example given, I couldn't find any common key. And the output which is required is 3 rows instead of 1 row.