sort second letter in a string

[BrahmanandaRao]

proc sql;
create table t as 
select * from sashelp.class
order by substr(Name,2);
quit;

Hi Guys

i want to get output second letter in ascending order in a string using data step

[ed_sas_member · Accepted solution]

Hi @BrahmanandaRao 

Here is an approach to do this:

data t_temp;
	set sashelp.class;
	second_letter = substr(Name,2);
run;

proc sort data=t_temp out=t (drop=second_letter);
	by second_letter;
run;

[ed_sas_member]

Hi @BrahmanandaRao 

Another approach could be the following one, using a hash object:

data _null_;
	if _n_=1 then do;
		declare hash h(ordered:'a');
		h.definekey('second_letter');
		h.definedata('Name','Sex','Age','Height','Weight');
		h.definedone();
	end;
	set sashelp.class;
	second_letter = substr(Name,2);
	h.add();
	h.output(dataset:'t');
run;