Attn. Marek (Was Word Driving Me Nuts!)

Attn. Marek (Was Word Driving Me Nuts!)

Post by Jose » Wed, 04 Feb 2004 02:47:02


On Mon, 02 Feb 2004 04:05:12 GMT, Marek Williams wrote in



Aren't you worried about corruption as a result of round-tripping,
or does the piece generally end with you and you don't need to
send it back? Why not just rely on your AV, particularly if--as
I'm guessing--you don't use the entire MS Office suite? I ask
because I use Word only when necessary for collaboration; I much
prefer Lotus apps as equally powerful but more elegant and stable.


Thanks for the most entertaining and interesting, while also being
the least pompous, post I've read in recent memory.

What types of works do you publish?
 
 
 

1. Database Driven Object Factory - Am I Nuts?

2. Left Join - driving me nuts - am I missing something?

Am I doing something wrong?

I have this code:

proc sql _method;
create table test as
select a.account_no,
a.branch_no,
a.account_open_date,
a.cob_balance,
a.account_limit,
b.loan_repaymt_amt,
b.year_num,
b.month_num

from detail.t_account_2006_12 as a
left join
detail.t_account_loan_details as b
on a.branch_no = b.branch_no
and a.account_no = b.account_no
and a.account_open_date = b.account_open_date

where (b.year_num = 2006 or b.year_num is null)
and (b.month_num = 12 or b.year_num is null)
;
quit;

My aim of course is to generate a table that has every record from the
T_ACCOUNT_2006_12 table and match it to any record from the
T_ACCOUNT_LOAN_DETAILS table where the loan year is 2006 and loan
month is 12.

When I run this I get the wrong number of records: it's running as if
it's an equi-join and the record count is too low.

Am I missing something?

Using SAS 9.1.3 SP4 on Sun Solaris 10. All tables are SPDS tables.

Thanks in advance.

3. Floppy drive (A: drive) is driving me nuts!

4. I have a Norton/Word/XP conflict that is driving me nuts!

5. Word OLE Driving Me Nuts!! - A Solution!

6. Word's gone bananas... driving me nuts!

7. A regex using word boundaries (\b) is driving me nuts ... any takers?

8. Word OLE Driving Me Nuts!!

9. Am I going nuts???? Array problem!?

10. Apple TV in my car. Am I nuts?

11. i am going nuts = new session id just will not work

12. Headers and Footers - I am going NUTS ! !

13. I am gone nuts...

14. Please help me, I am going nuts.

15. I am going nuts!