/* maximum length names output using datastep*/
data newdata (keep=Letter_1-Letter_7 name sex );
retain name;
array myvar (*)$ Letter_1-Letter_7;
set sashelp.class;
do i=1 to dim(myvar);
myvar(i)=upcase(substr(name, i, 1));
where max(length(name))=7 ;
end;
proc print noobs;
run;
/*max and min names length using proc sql*/
PROC SQL;
SELECT name,sex,letter_1,letter_2,letter_3,letter_4,letter_5,letter_6,letter_7,MAX(LENGTH(Name)) AS MaxLengthFemale
FROM newdata
WHERE Sex = 'F';
SELECT name,sex,letter_1,letter_2,letter_3,letter_4,letter_5,letter_6,letter_7,MIN(LENGTH(Name)) AS MinLengthMale
FROM newdata
WHERE Sex = 'M';
QUIT;
1.How to get min and max names length output in datastep
... View more
