No idea why you would want such a strange dataset, but perhaps this code can be used to make such a dataset.
filename code temp;
data _null_;
file code;
if 0 then set sashelp.cars(keep=type);
declare hash h(dataset:'sashelp.cars',ordered:'d');
h.definekey('type');
h.definedata('type');
h.definedone();
declare hiter iter('h');
rc = iter.first();
do while (rc = 0);
length nliteral $65 ;
nliteral=nliteral(type);
put 'if type=' type :$quote. 'then ' nliteral '=1;';
rc = iter.next();
end;
stop;
run;
data want;
set sashelp.cars(keep=type);
%include code / source2;
set sashelp.cars(keep=Mpg_City);
drop type;
run;
proc print data=want (obs=10);
run;
proc report data = SasHelp.Cars;
column Type Mpg_City;
define Type/across descending;
define Mpg_City/display;
run;
Results:
... View more