How to use the PROPCASE function
Using the PROPCASE function
The "old" way to capitalize the first letter of words was to use LOWCASE, UPCASE, and the SUBSTR function, like this:
DATA CAPITALIZE;
INFORMAT FIRST LAST $30.;
INPUT FIRST LAST;
FIRST = LOWCASE (FIRST);
LAST = LOWCASE (LAST);
SUBSTR( FIRST , 1 , 1 ) = UPCASE(SUBSTR( FIRST , 1 , 1 ));
SUBSTR( LAST , 1 , 1 ) = UPCASE(SUBSTR( LAST , 1 , 1 ));
DATALINES;
ronald cODy
THomaS eDISON
albert einstein
;
PROC PRINT DATA=CAPITALIZE NOOBS;
TITLE "Listing of Data Set CAPITALIZE";
RUN ;
With the PROPCASE function in SAS 9.1, it's much easier.
DATA PROPER ;
INPUT NAME $60.;
NAME = PROPCASE (NAME);
DATALINES;
ronald cODy
THomaS eDISON
albert einstein
;
PROC PRINT DATA=PROPER NOOBS;
TITLE "Listing of Data Set PROPER";
RUN;
source:www.support.sas.com
Example:
data test ;
x= lowcase ( ' MY NaMe iS SARaTh ' ) ;
y= propcase (x) ;
z= propcase ( lowcase ( ' ...
