Hi,
Just let you know that the drop option works in sas 9.3.
data _null_;
if 0 then set sashelp.class;
dcl hash h();
h.definekey('name');
h.definedata('name', 'age');
h.definedone();
do obs = 1 to nobs;
set sashelp.class nobs=nobs;
h.add();
end;
h.output(dataset: "work.class(drop=age)");
stop;
run
;
proc print data=class;
run
;
Obs Name
1 John
2 Alice
3 Henry
4 Joyce
5 Janet
6 Judy
7 William
8 Mary
9 James
10 Barbara
11 Carol
12 Ronald
13 Louise
14 Thomas
15 Alfred
16 Robert
17 Jane
18 Philip
19 Jeffrey
Linlin
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.