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
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
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;
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
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.