Dear All,
How should I get what I want?
Thank you very much for your input!
data have;
input (a b c) ($);
cards;
dd ee ff
ff hh gg
ss dd hh
;
observations in the dataset I want:
dd
ee
ff
hh
gg
ss
Hi Linlin,
Use a variable list a--c to refer to your 100 variables (assuming they are listed consecutively) :
data have;
input (a b c) ($);
cards;
dd ee ff
ff hh gg
ss dd hh
;
data list;
set have;
array _a{*} a--c;
do i = 1 to dim(_a);
value = _a{i};
output;
end;
run;
proc sql;
create table uniqueValues as
select unique value from list;
select * from uniqueValues;
quit;
PG
Rotate the data into a single column and let proc sort/FREQ/SQL find the distinct values.
data middle / view=middle;
set have;
array _all a b c;
do over _all; value = _all; output; end;
run;
proc freq data=middle ;
tables value / out=want missing;
run;
Or Hash():
data have;
input (a b c) ($);
cards;
dd ee ff
ff hh gg
ss dd hh
;
data _null_;
if _n_=1 then do;
declare hash h();
h.definekey('newvar');
h.definedata('newvar');
h.definedone();
end;
set have end=last;
array t _character_;
length newvar $ 8;
call missing(newvar);
do over t;
rc=h.replace(key:t, data:t);
end;
if last then rc=h.output(dataset:'want');
run;
Haikuo
Hi Linlin,
Use a variable list a--c to refer to your 100 variables (assuming they are listed consecutively) :
data have;
input (a b c) ($);
cards;
dd ee ff
ff hh gg
ss dd hh
;
data list;
set have;
array _a{*} a--c;
do i = 1 to dim(_a);
value = _a{i};
output;
end;
run;
proc sql;
create table uniqueValues as
select unique value from list;
select * from uniqueValues;
quit;
PG
Hi Tom, Haikuo, and PG:
Thank you very much for your help!!! - Linlin
Wow, three excellent ways to solve the problem!
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.