thank you Ksharp
it is very interesting to hear how such culture spreads
> 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.
so, best wishes for your new year when it comes
>
> 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.
not in my SAS system![pre]proc sql noprint ; select name into :n1-:n999 from sashelp.class ;[/pre] fills &sqlobs with only one select statement! Have you tested your statement? (or mine?)
On my system &sqlobs does not exist until a "PROC SQL" statement executes. The value is filled by an sql select statement even if it would output no rows, like
select name into :names from sashelp.class where age > 16 ;
Can you demonstrate how or when PROC SQL fails to fill SQLOBS on any valid select statement ?
> Second.You label variable by using data step,
Where-ever I suggested this, I certainly should be reminded about the impact of an unneccessary pass through potentially large data!
Please could you point out or give me a hyperlink to where I provided this bad advice?
>
> Merry Christmas!
> Cheers.
> Ksharp
cheers from London, UK
peterC
fixing bad grammar
Message was edited by: Peter.C