topic Re: copying obs with different name in SAS Procedures

copying obs with different name

podarum — Wed, 14 Dec 2011 19:51:46 GMT

I know the title line is confusing, but here's what I need. I have a Variable 1 that has a whole bunch of provinces. But if a province = A then I want 3 more provinces to also = a... still confused.. see below:

HAVE:

Prov Data

A 12

B 11

C 19

D 14

I want 3 new Prov's (E, F and G) that now only adopt the values from C:

WANT:

Prov Data

A 12

B 11

C 19

D 14

E 19

F 19

G 19;

Thanks

Re: copying obs with different name

Sebastian — Thu, 15 Dec 2011 01:25:29 GMT

Hello,

Consider using something like the following code:

data new_prov;
set prov;

/* retain original provs */
output;

/* add some more provs based on current one if it matches the pattern */
if prov="C" then
do;
   prov="E";
   output;
   prov="F";
   output;
   prov="G";
   output;
end;
run;

It's probably not perfect but I hope it can give you some idea.

Best regards,

Sebastian

Re: copying obs with different name

Ksharp — Thu, 15 Dec 2011 04:43:08 GMT

A little more brief.

data new_prov;
set prov;

/* retain original provs */
output;

/* add some more provs based on current one if it matches the pattern */
if prov="C" then do;
do prov="E", "F","G";
output;
end;
run;

Ksharp