Call execute can do it.It is very powerful. [pre] DATA test; length col_EXP $50; col_EXP="intnx('day',today(),2)";output; col_EXP="intnx('day',today(),10)";output; RUN; data _null_; set test end=last; if _n_ eq 1 then call execute('data result;'); call execute('col_EXP=" '||col_EXP||'" ; ' ); call execute(cats('col_DT=',col_EXP,';' )); call execute('format col_DT date9. ;'); call execute('output;'); if last then call execute('run;'); run; [/pre] Ksharp ... View more

Hi. I found another way.It looks like 'call execute' can do it absolutely. [pre] options nonote; data temp; do i=1 to 100; a=2; b=5; c='a*b'; output; a=5; b=6; c='a+b'; output; end; run; data temp; set temp end=last; if _n_ eq 1 then call execute('data result;'); call execute(cats('a=',a,';')); call execute(cats('b=',b,';')); call execute(cats("c='",c,"';")); call execute(cats('d=',c,';')); call execute('output;'); if last then call execute('run;'); run; [/pre] Ksharp ... View more

Hi. In my opinion. There is ' proc varclus' ( the name I have forgetted) which can do cluster analysis for variables which has the same principle with proc cluster but its object analysised is variables not obs. And you also can do primary component analysis for these variable to see which variables influent the whole data's variance. Ksharp ... View more

Hi. What proc you used? You cluster for variables or observation? And In the output there is some statistical index (such as CCC) will display the variance of this obs / variables accounts for whole data's variance. Maybe you can use primary component analysis for the multi-variables data to see which variable is the most important. BTW.Just as Patrick said why not post it in ' Statistical Procedure' forum,There is man named lvm will give you more help, He is an expert about these. Ksharp ... View more

Hi. All make me some sense is 'substr(first,1,7)' is only in PDV ( not write into disk) so SAS will treat it has the same storage length with variable 'First' . and once you write it into dataset (such as ' a=substr(first,1,7) '),it will has 7 length of storage. Ksharp ... View more

Hi. That column input method would be used. [pre] data temp; input a 1 b 3 c 5 d 7; cards; 1 1 1 2 2 2 3 3 3 4 4 4 ;run; [/pre] Ksharp ... View more

Hi. You can remove cats(), directly use max(week). I think Patrick used function cats() is just to want to delete the surplus blanks. Actually ,the macro variable will automatically remove the heading and trailing blanks. Sorry. I am wrong. Actually Proc Sql will keep heading and trailing blanks for the single macro variable. Ksharp Message was edited by: Ksharp ... View more

Hi. In addition to what LAP said, there is another problem in your code. [pre] %let date_from=%sysfunc(mdy(07,01,2010)); [/pre] Ksharp ... View more

Sorry.I found some problem in my code; The following is corrected code. [pre] data i; input ID $ ADATE : MMDDYY10. SERVICE $; format adate mmddyy10.; datalines; 1 12/7/2009 I 2 1/12/2009 I 2 1/13/2009 OP 3 6/5/2009 I 4 7/29/2009 LA 5 3/23/2009 OP ; proc sort data=i nodupkey; by id adate service; run; data index; set i; where service not eq 'I'; run; proc sql feedback; *createing table contained observations which is needed to change into I; create table flag as select a.* from index as a left join i as b on a.id eq b.id where ( b.adate eq a.adate ) or ( b.adate eq (a.adate - 1)) group by a.id,a.service having count(*) ge 2; quit; proc sort data=flag nodupkey; by id adate service; run; data flag; set flag; _service='I'; drop service; run; proc sort data=i; by id adate; run; data result; merge i flag; by id adate; run; data result; set result; if _service eq 'I' then service=_service; drop _service; run; ... View more

Dear Peter. >not in my SAS system! proc sql noprint ; select name into :n1-:n999 from sashelp.class ; fills &sqlobs with only one select statement! Have you tested your statement? (or mine?) Your code is right . It is my fault.I am too careless.Forgives me not careful to see your code. I think I am too confidence and arrogant to check.Sorry. >Please could you point out or give me a hyperlink to where I provided this bad advice? I think you are very seasoned expert about SAS. Cheers. Ksharp Message was edited by: Ksharp ... View more

>I thought & only works if the raw data values are separated by two or more consecutive blanks. The address lines in this case do not have them. Hi. & has some same thing with ' : ', ' &' also stop input when encounter delimiter ( but it is double delimiter not as ' : ' which is single delimiter),So you will input address which contains single delimiter(blank). column input (Address $ 1 - 20) will input all the twenty column even though it encounters delimiter and end character of line. So if you want use column input ,Try to use Patrick suggested(use option 'truncover', it will stop input when encounter end character of line). [pre] filename example 'c:\test.txt'; data address; infile Example truncover; input FirstName $ LastName $ / Address $ 1 - 20 / City & $10. State$ Zip$; run; proc print data=work.address; run; [/pre] Or add some more blanks after address until over 20 columns. Ksharp ... View more

Hi. Function dif() is identical with time-lag(time) [pre] data timeCalculations; input time : time8.; format time NewDiff time8.; NewDiff=dif(time); if NewDiff=. then NewDiff=0; cards; 10:34:37 10:36:03 10:38:56 10:47:35 10:51:54 10:54:47 11:03:25 ; run; proc print;run; [/pre] Ksharp ... View more

Hi.Patrick. Long time no see your posting. Happy Holidays! Ksharp ... View more

Dear Peter. Good Holidays! >I understand some of this culture has spread to other parts of the world so now Santa's task is even bigger ;-)) Yes.You are right . In China (Bei Jing) where I lived in, there are lots of Christmas Trees and Christmas Songs around me,and It is hard to see foreign friends now, maybe they have gone to their homeland to holiday.Unfortunately I have to work even though it is not too heavy,We will get Holidays until February 2,2011 that is Chinese Tradition New Year. After look at your code, I found some problem in it. First,Macro variable &sqlobs is only generated after sql statement executed,that is to mean you need execute the same sql statement twice. Second.You label variable by using data step,which will scan the whole data set and will very slow when this dataset is very big (about 200G),So can use 'proc datasets +modify+label',that will be more efficient than yours ,since 'proc datasets' will not read the dataset in PDV and modify label directly. BTW, the approach I used is what you mentioned. Merry Christmas! Cheers. Ksharp ... View more