[SAS]Hong Kong map

/* Hong Kong Map*/
proc sql;
select unique id into :my_id from maps.china2 where idname="Hong Kong";
quit; run;
data my_map; set maps.china (where=(id=&my_id));
run;

proc gmap data=my_map map=my_map;
id id;
choro id / levels=1 nolegend coutline=same name='map4';
run;

[Excel]In-cell chart

=REPT("|",A3)&CHAR(10)&REPT("|",B3)&CHAR(10)&REPT("|",C3)&CHAR(10)&REPT("|",D3)&CHAR(10)&REPT("|",E3)

Rotate the cell contents by 90 degree

-->Using Aharoni font

reference: http://chandoo.org/wp/excel-basics/

[SAS]Import excel using libname

libname test excel 'your excel path';
data temp;
set test.'excelsheet$'n(firstobs=n obs=m);
run;
libname test clear;