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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.