great ! thank you so much. I am a SQL person, SAS is powerful.         ... View more

DATA OUTC; SET C; BY LOB; LENGTH TYPE $100; IF FIRST.LOB THEN TYPE=CODE; ELSE TYPE =CATX(',',type,CODE); retain type; IF LAST.LOB; drop Code; RUN; ... View more

This result:   0100 MHSC,MHSC1 0400 DEHG 0500 MSDD,HENH ... View more

data C; input LOB $ Code $; cards;   0100 MHSC 0100 MHSC1 0500 MSHD 0500 HENH 0400 DEHG ; proc sort data=C; by lob; run;   　 DATA OUTC; SET C; BY LOB; LENGTH TYPE $100; IF FIRST.LOB THEN TYPE=CODE; ELSE TYPE =CATX(',',TYPE); IF LAST.LOB; DROP Code; RUN;  　 What I should modify , in order to have result as this :   100 MHSC,MHSC1 400 DEHG 500 MSDD,HENH       ... View more

using proc sql, because we need group by LOB,   result should be as this ...     LOB TYPE 100 MHSC,MHO1,MHSA,…….TYPEi…. 200 MHSC,MHO1,MHSA,…….TYPEi…. 300 MNO1 ... View more

PROC TRANSPOSE DATA=a PREFIX=TYPE OUT=b (drop=_name_ _label_); by lob; var typ; RUN;   Result of running above , have Table b: LOB TYpe1 Type2 Type3 ..TYPE..i 100 MHSC MHO1 MHSA ….?   Note: Type..i would be unknown, dynamic.   Want to have a new table C: I am a SQL person ... PROC SQL;  CREATE TABLE c as   SELECT LOB,              CATX(',',of TYPE:) AS Service_Codes,   FROM B; QUIT;   I want result : LOB TYPE 100 MHSC,MHO1,MHSA,…….TYPEi….   would not working ....???   ... View more

oh, I see,      CATX(',', of my_prefix: ) , I have problem to get  'of my_prefix: ' ,   PROC TRANSPOSE DATA=FACETS_PROVIDERa PREFIX=TYPE OUT=FACETS_PROVIDERb (drop=_name_ _label_); by lob service_provider_id; var type_of_service; RUN;   From this code, I could have Type1, type2......typen, 'n' would be my problem, do not know how to get it.   Affect my next step CATX(',',type1, type2...typen)             ... View more

i x1 x2 x3 x4 x5 xi   PROC Transpose result, since xi 'i' is unknown, when I need to use CATX(',',x1,x2,x3....xi), but could not decide 'i'.. ... View more

PROC Transpose the dynamic aspect of this operation result is multiple rows, I need concatenate x1,x2,x3,x4..xi   to one record - one row  separated by ','. ... View more

When I have table A as PROC Transpose result.   Next step need to have table B .   How to have Table B from Table A   After Proc Transpose I have Table A, how many rows are unknown . ...'xi'. But customer need to concatenate xi rows to one recode--- one row. ... View more