Statisticians use mosaic plots to display hierarchical data, although in practice it works best for three or fewer levels of nesting. PROC FREQ can display a mosaic plot automatically, The plot is often used to accompany an analysis/discussion of whether there is association between variables. ... View more

Out of experience, I DO NOT LIKE possible conditions that are not covered in the code, they tend to come back and bite one in the ass So setting newvar explicitly to "unknown" is good practice. Just relying on empty (missing) values because they happen on their own may lead to unnecessary expensive debugging later on. ... View more

Hi Kyoo, Proc transpose would work fine for your data. But what if the data is like this... 111 1-Jan 1 111 1-Feb 3 111 1-Mar 4 222 1-Jan 1 222 1-Apr 3 Order2 will not be included in your output. For this u have to go with data step as given below, DATA HAVE; INPUT Acct mail_date $ Order; DATALINES; 111 1-Jan 1 111 1-Feb 3 111 1-Mar 4 222 1-Jan 1 222 1-Apr 3 ; RUN; *Selecting the maximum of order; PROC SQL NOPRINT; SELECT MAX(ORDER) INTO :M_ORD FROM HAVE ; QUIT; PROC SORT DATA=HAVE; BY ACCT; RUN; DATA WANT(DROP=ORD MAIL_DATE I); SET HAVE (RENAME=(ORDER=ORD)); ARRAY ORDER(&M_ORD) $  ; BY ACCT; RETAIN ORDER: ; IF FIRST.ACCT THEN DO I = 1 TO &M_ORD; ORDER(I)=" "; END; ORDER(ORD)= MAIL_DATE; IF LAST.ACCT; RUN; ... View more

You could use a regular expression as shown below. data have; string="Hi i want to split a sentence into variables with same length, but i dont want the words to be truncated in the new variable,if it is going to be truncated then it must move on to the next variable.For eg: If i have sentence of length"; output; string="For eg: If i have sentence of length 200 bytes, i want to split the sentence into 4 variables each of 50 bytes and they should not have truncated words.I have done a complex macro to do this but i am looking for a much simpler method"; output; run; data prep /*(drop=_:)*/;   length sub_string $50;   retain _re;   length _start _stop _pos _len 8;   if _N_ = 1 then     _re = prxparse('/(?<=\b)[\w].{0,48}([^\w]|$)/');   set have;   _start=1;   _stop = lengthn(string);   do until (_start>_stop);     call prxnext(_re, _start, _stop, string, _pos, _len);     sub_string = substrn(string, _pos, _len);     output;     if missing(sub_string) then leave;   end; run; proc transpose data=prep out=want(drop=_:) prefix=var;   by string notsorted;   var sub_string; run; ... View more