Peter. I really adore your spirit of discovery. 😉 Best Regards. Ksharp ... View more

Hi. Not test. And this code is not suited to the dataset with large obs ,because the length of Macro variable is limited. [pre] proc sql; select distinct quote( sex ) into :num separated by ' ' from sashelp.class; quit; Data Target; Set Source; if column in (&num) then do; [/pre] Ksharp ... View more

Just as you said ,The function lenghtc() would be useful,it returned the length of storage of variable. [pre] data _null_; set sashelp.class; len_sex=lengthc(sex); len_name=lengthc(name); put 'NOTE:' len_sex= / 'NOTE:' len_name=; run; [/pre] Ksharp ... View more

No. For the previous SAS release,the number of variables is limited for proc transpose.I am not sure the Current SAS is whether supported unlimited variables. Ksharp Message was edited by: Ksharp ... View more

Hi.Art Carpenter. I have read several books you write, they are pretty good, and learned a lot from them. Regards. Ksharp ... View more

Hi.Peter. I try your code.But it does not find anything. 'not easy' means I try many times and look up the SAS documentation all over. I also think your code is right. Maybe does not suit this situation. Regards. Ksharp ... View more

Yes. There is an easy way to do this . But this way is not suitable for the dataset with large obs. [pre] data data1; input obs (var1 var2 var3) ($); datalines; 1 002 003 001 2 1.02 0.09 0.23 3 0.02 0.56 1.08 run; data data2; input obs id $ name $; datalines; 1 001 Math 2 002 Phys 3 003 Chem ; run; proc transpose data=data1(drop=obs) out=temp; var var1 var2 var3; run; proc sort data=temp; by col1; run; proc sort data=data2(drop=obs); by id; run; data result; merge temp(rename=(col1=id)) data2; by id; drop _name_; run; proc transpose data=result out=op(drop=_name_); id name; var id col2 col3; run; proc print ; run; [/pre] Ksharp ... View more

http://support.sas.com/kb/32/455.html or Maybe you need 'DBMS=EXCELCS ' Ksharp Message was edited by: Ksharp ... View more

Hi. I try many times ,Finally got it. I really think it is no easy to achieve. [pre] data _null_; x=put('10aug2009'd,mmddyy5.); put 'NOTE:' x=; run; [/pre] and [pre] data _null_; x=put('10aug2009'd,mmddyyd5.); put 'NOTE:' x=; run; [/pre] Ksharp Message was edited by: Ksharp ... View more

Hi. Don't say so.I am also a beginner for SAS statistical method. proc PRINCOMP do the principle component analysis which is the oldest multi-variables analysis can use two prin stand for the multi-variables data based on covariance matrix. Then use these two prin as x-axis and y-axis, ploting the observations in this coordination. and you will find some obs very close and some obs very far. Recommend you to look up the SAS documentation about proc princomp. p.s. these two prin demonstrate the the variance this obs can explain. Ksharp ... View more

Hi. For your siduation that has lots of statistical estimator, The 'proc tabulate' is the best choice.And Cynthia@sas can make it very well. [pre] data temp; input id signupdate : mmddyy8. logindate : mmddyy8. activity $; format signupdate mmddyy8. logindate mmddyy8. ; dif=intck('day',signupdate,logindate); interval=floor(dif/30)+1; drop dif ; datalines; 1 11/01/07 11/01/07 open 1 11/01/07 11/06/07 open 1 11/01/07 11/07/07 start 1 11/01/07 11/22/07 open 1 11/01/07 12/06/07 start 1 11/01/07 12/08/07 open 2 12/05/07 01/01/08 start 2 12/05/07 01/22/08 open 2 12/05/07 01/28/08 start 2 12/05/07 01/29/08 open ; run; options missing=0; ods html file='c:\tab.html' style=sasweb; proc tabulate data=temp; class id interval activity; table id*interval='month',activity='Number of activity' all='Number of Login'; keylabel n=' '; run; ods html close; [/pre] Ksharp Message was edited by: Ksharp ... View more

Hi. Maybe you should use Wilcoxon-rank-sum-test ,because it is nonparameter statistical method which is robust for any distribution. And log-rank is most powerful only for the survival curves both paralleled. Ksharp ... View more

Hi. You can use ' proc sort nodup; by name descending maturity;run;' to get it. ... View more

Hi.I think Patrick can do it very well. [pre] data temp; input num rate;; cards; 1 3.0 2 2.9 3 10.0 5 7.7 6 8.9 7 9.1 9 10.0 10 7.6 1 9.8 2 7.0 3 6.3 4 4.9 5 5.5 7 6.3 8 8.9 9 9.9 10 7.9 ; run; data result(drop=num rate); set temp; qnum+1; do while(qnum lt num) ; call missing(rating); output; qnum+1; end; rating=rate; output; if qnum eq 10 then qnum=0; run; proc print noobs;run; [/pre] Ksharp ... View more

Hi.I remebered There is likely a statistical estimator(but i forgot. 😞 ) to decide how many cluster. Before using proc cluster/fastclus ,Recommend to use proc princomp and proc gplort to plot the two prin1 and prin2 to decide how many clusters you want. And there is not best criteria to decide the number of clusters, different method would yield different cluster . Ksharp Message was edited by: Ksharp ... View more