Thanks for attempting. I just mean by 'only' that I want to do it from 'first principles'
The following has landed me the closest since. I had to create some space between the names of the candidates and use &. But am having a few problems with the numeric variables. May be able to figure it out but I would love to have a solution that does not involve manipulating the data set. Here observations are 22 so it can be done but what if they were more.
Here is the code. See if you can run some variations on it.
data election;
infile datalines truncover dlm=" ";
input pcand & $32. vpcand &$33. polparty & $31. votes comma10. percent percent3.;
datalines;
WEAH, George Manneh JOHNSON, J. Rudolph Congress for Democratic Change (CDC) 275,265 28.3%
JOHNSON-SIRLEAF, Ellen BOAKAI, Joseph Nyuma Unity Party (UP) 192,326 19.8%
BRUMSKINE, Charles Walker WARD, Amelia Angeline Liberty Party (LP) 135,093 13.9%
TUBMAN, Winston A. SULUNTEH, Jeremiah Congbeh National Democratic Party of Liberia (NDPL) 89,623 9.2%
SHERMAN, Harry Varney Gboto-Nambi FANIA, John Kollehlon Coalition for Transformation of Liberia (COTOL) 76,403 7.8%
MASSAQUOI, Roland Chris Yarkpah PAYGAI, SR., Q. Somah National Patriotic Party (NPP) 40,361 4.1%
KORTO, Joseph D. Z. BARCLAY, JR., James Kollie Liberia Equal Rights Party (LERP) 31,814 3.3%
KROMAH, Alhaji G. V. RUSSELL, SR., Emmanuel Mac All Liberian Coalition Party (ALCOP) 27,141 2.8%
TIPOTEH, Togba-Nah DAHN, Marcus S. G. Alliance for Peace and Democracy (APD) 22,766 2.3%
TUBMAN, William Vacanarat Shadrach WILLIAMS, Garlo Isaac Reformed United Liberia Party (RULP) 15,115 1.6%
MORLU, John Sembe DEMEN, Joseph Omaxline United Democratic Alliance (UDA) 12,068 1.2%
BARNES, Milton Nathaniel HARRIS, Parleh Dargbeh Liberia Destiny Party (LDP) 9,325 1.0%
TOR-THOMPSON, Margaret J. MARSH, SR., J. Rudolph Freedom Alliance Party of Liberia (FAPL) 8,418 0.9%
WOAH-TEE, Joseph Mamadee BROH, I., Samuel Washington Labor Party of Liberia (LPL) 5,948 0.6%
CONNEH, Sekou Damate SALI, Edward Yarkpawolo Progressive Democratic Party (PRODEM) 5,499 0.6%
FARHAT, David M. GBOLLIE, Saah Ciapha Free Democratic Party (FDP) 4,497 0.5%
KIEH, JR., George Klay TOKPA, Alaric Kormu New Deal Movement (NDM) 4,476 0.5%
JALLAH, Armah Zolu SAMMY, SR., Isaac G. National Party of Liberia (NPL) 3,837 0.4%
KPOTO, Robert Momo SINGBE, Sylvester Bondo Union of Liberian Democrats (ULD) 3,825 0.4%
KIADII, George Momodu MCGILL, Washington Shadrack National Vision Party of Liberia (NATVIPOL) 3,646 0.4%
DIVINE, SR., Samuel Raymond MAMU, SR., Jacob Gbanalagaye Independent 3,188 0.3%
REEVES, Alfred Garpee SHERIF, Martin Mohammed Njavola National Reformation Party (NRP) 3,156
;
proc print;
run;
... View more