topic sort second letter in a string in SAS Programming

sort second letter in a string

BrahmanandaRao — Sat, 22 Feb 2020 06:52:20 GMT

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

Re: sort second letter in a string

ed_sas_member — Sat, 22 Feb 2020 07:50:15 GMT

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;

Re: sort second letter in a string

ed_sas_member — Sat, 22 Feb 2020 07:55:13 GMT

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;