Consider SASHELP.CARS dataset and give the sequence number for MAKE variable. Ex:- in MAKE variable, I want sequence number for AUDI Below is my required Output, that too only with PROC SQL, not with data step, I know how to do with data step. MAKE SEQ -------------- AUDI 1 AUDI 2 AUDI 3 BMW 1 BMW 2 BMW 3
... View more