it is how @DMenkveld has proposed.
"Area","pct_2014","pct_2013" "Houston",0.19,0.22 "Miami",0.19,0.24 "Dallas",0.18,0.21 "San Antonio",0.15,0.19 "Atlanta",0.15,0.18 "Los Angeles",0.14,0.2 "Tampa",0.14,0.17 "Riverside, Calif.",0.14,0.19 "Phoenix",0.13,0.17 "Charlotte",0.13,0.15 "San Diego",0.12,0.16 "All Metro Areas",0.11,0.14 "Chicago",0.11,0.14 "New York",0.1,0.12 "Denver",0.1,0.14 "Washington, D.C.",0.09,0.11 "Portland",0.09,0.13 "St. Louis",0.09,0.1 "Detroit",0.09,0.11 "Philadelphia",0.08,0.1 "Seattle",0.08,0.12 "San Francisco",0.08,0.11 "Baltimore",0.06,0.09 "Pittsburgh",0.06,0.07 "Minneapolis",0.06,0.08 "Boston",0.04,0.04
FILENAME REFFILE FILESRVC FOLDERPATH='/Public' FILENAME='health.txt';
PROC IMPORT DATAFILE=REFFILE
DBMS=DLM
OUT=WORK.IMPORT;
delimiter=",";
GETNAMES=YES;
RUN;
PROC CONTENTS DATA=WORK.IMPORT; RUN;
data mkt.hh(promote=yes);
set import;
format pct_2013 pct_2014 miny maxy;
miny=min(pct_2013, pct_2014);
maxy=max(pct_2013, pct_2014);
run;
... View more