Wednesday, 30 March 2011

Gone In Six Seconds - I Hope They Enjoyed My Money

I've been taking cash out of cashpoints (cashpoints are run by banks, ATM's are run by other companies) since, oh, the first one was introduced. Which is a good few years. The other week, I became That Guy. I went up to a cashpoint run by the Nat West on Shaftesbury Avenue at Piccadilly Circus, keyed in my PIN, took the card, and apparently I walked away without taking the money. I have no memory of it. I didn't notice I hadn't taken the money until I came to pay for a magazine in a newsagent on Berwick Street. So back I went, not to see if the money was there, because the machine takes it back after a not very long time. Five or six seconds, according to the bank teller in the branch.

You don't get your money back. What I didn't do was cuss at myself for being an idiot and tell myself that I was useless and my life is a total fuck-up. I used to do that, and over stuff way less costly. I did wonder exactly how a) pre-occupied I was or b) just how badly the pollen is affecting me. I'm not going to starve because of it. I can shrug at it now.

Someone took the money, and they saw it and took it in less than about ten seconds. I hope they enjoyed it.

Monday, 28 March 2011

The Need for Civil Unrest

Sunday morning I drove up to Piccadilly and went to my gym - just because I have a guilty conscience about doing nothing all day. What I saw as I walked along Piccadilly was some paint spattered on the pavements and a few broken windows. These had been targeted: Lloyds Bank had broken windows and paint, Barclays' plate glass was untouched. Of the two banks, Barclays, home of multi-millionaire tax evasion experts Barclays Capital, is by far the worse corporate citizen, but Lloyds is the one that got conned into buying Halifax / Bank of Scotland and taking billions of pounds of "government support" aka "Chinese savings". (There are a handful of countries with net savings - all borrowing is ultimately from them - and China is the largest.) Actually, they should have broken the windows of Sir Victor Blank's and Eric Daniels' mansions - they were the Lloyds senior managers who decided with their egos rather than their brains.

The British establishment is all over the place. How dare a few "anarchists" defile property? Read the reports in the press: the outrage descends into bathos as you look at the targets: John Lewis, the Ritz, Fortnum and Mason. Not hospitals, not fire stations, not surgeries, but some retailers. That isn't "property" - it's a plate glass window, shop fittings and some signage. It's insured. It gets torn out and replaced every eighteen months anyway. The cost of cleaning up the damage is about one millisecond's profits for the owners.

For the French, of course, a few broken windows is nothing. The French don't even blink when they tear up roads or dump cowshit all over motorways. They know how to give a protest in France. In this country, we've only had one French-scale political riot - the Poll Tax riots of 1990 - and something truly terrible happened: it worked. Governments of both colors have lived in fear of a riot like that happening again. Because in a British democracy, the people must never be allowed directly to change political policy. Control of the process must be in the hands of the political class and the process must only respond those who are committed to its continued existence. This is elementary stuff. It means a million people can march and as long as they don't actually make the headlines, it doesn't matter. Let one of them break the windows of a corporate behemoth and that's news. Popular, organised protest must therefore be neutered (peaceful, not newsworthy) or marginalised (newsworthy but the work of "anarchists").

I'm all for violent protest - if that violence is directed towards the property and senior management of the guilty parties. Not the employees. Not your pet-hate coffee shop chain. Not a looting expedition. The actual guilty parties: tax dodgers, bribers, outsourcers, debt-laden utilities who can't even fix water pipes, and so on. Read an issue of Private Eye or look at the Coalition of Resistance or UK Uncut. I don't take part because I'm too old and I can't do the time.

Violent civil unrest is also a tit-for-tat. Because when the government takes money from your income to pay for bail-outs or wars you didn't vote for, it's mugging you. That's violence. It might be by Direct Debit, but it's still violence - the use of force to achieve an aim.

Friday, 25 March 2011

Janet Woititz' Relationship Questions (And My Answers)

Janet Woititz wrote the standard book on ACoA's. I read it about every six months and find something different or react differently to something every time - which is how it should be. These questions were in the section about dealing with the difficulty ACoA's have with "intimate relationships". The questions are in italics, my comments aren't.

Vulnerability: to what degree am I willing to let down my barriers? To what degree am I willing to let the other person affect my feelings? What you're seeing are the barriers I put around my time: I have a short attention span and a really low boredom threshold. And I used to let other people get to me far too much: now I'm much better at not obsessing.

Understanding. Do I understand the other person? Do I understand what they mean by what they say and do? Being a man, I don't read minds and I don't do girl-games - which explains a lot about my failed sex life. So if you speak plainly, then yes. And if you speak in riddles and allusions, then no. Do I want a relationship with someone who speaks in riddles and allusions? Sounds cute, could get tiresome really quickly.

Empathy: to what extent am I able to allow myself to feel what they feel? Empathy is one of those ancient Greek ideas that hasn't travelled well. I cannot feel what you are feeling any more than I can taste what you are tasting: the closest we can get is to eat the same fish. If you're ever seen one person walk away from a redundancy interview cheerful (lots of money and they're out of there) while the next was shattered (who cares about the money, where am I going to go?) you will know this to be true. And if what you're feeling is a gross over-reaction and toxic waste, why do I want to feel it?

Compassion: do I have a genuine concern for the issues that cause the other person concern? Actually, that isn't compassion - which is about reacting with sympathy to other people's bad luck and suffering, in which case see previous paragraph. I'm a co-dependent, I used to love doing that - to an unhealthy extent. I stop myself before I get more than a couple of steps down that line, and I'm better for it. Again, it depends on what the issue is: it would be totally messed-up to share their concern with immanent nuclear war, and who would want a relationship with someone like that?

Respect: do I treat the other person as if they are of value? We may have different ideas of what "respect" is. If I argue with you, that means I think you're worth bothering with. If I'm polite to you, that means I don't think you're worth the effort. A lot of people think that "respect" means I nod along while they talk crap.

Trust: to what degree and on what levels am I willing to let the other person gain access to the things about me that I don't want everyone to know? If I think you can be trusted to keep your mouth shut, yes. Trust like that has to be earned, not given. This answer is the only correct one. 

Acceptance: am I okay the way I am? Is my partner? If "okay" means "I don't need to get fitter / smarter / better dressed / more polite / lighter / more informed / more charming company / whatever" then I am proud to say I am not okay and I wouldn't want a partner who thought they were either. If this question really means is: "am I a hyper-critical, picky, never-satisfied, moaning bitch?" then the answer is no.

Honesty: is this relationship built on truth, or are there games involved? I was a Nine, so everyone's relationships with me were built on their instantaneous expectations, which were entirely of their own invention. And when they found out I wasn't what they wanted me to be, they walked away, and there was no relationship. 

Communication: are we able to talk freely about issues that are important in the relationship? Do we know how to do it so we are understood and the relationship goes forward as a result of the sharing?  Part one: as much as anybody else is. Part two: only a charlatan pushing a magical communication cure would guarantee that a "relationship goes forward" after every revelation, unless you count divorce as "forward". 

Compatibility: to what degree do we like and dislike the same things? To what degree does it matter if we differ in certain attitudes and beliefs? I have minority tastes in everything. I can guarantee we have almost nothing in common.

Personal integrity: to what degree am I able to maintain myself as well as offer to the other person? You mean, do I wind up doing things I don't want to do and hating myself afterwards? Not very often. 

Consideration: Am I mindful of the the other person's needs as well as my own? What needs? For endless support and re-assurance? For a captive to go drinking with? It tells you something about my experience and life that I'm not sure I've run across anyone with a need that wasn't "needy".  Unless they just needed to know the way to Leicester Square.


Monday, 21 March 2011

And On The Seventh Day I Rest... It Seems

Every Friday I make plans for the weekend, which usually include watching a movie and doing something on Sunday, and every Sunday I do absolutely nothing. I wake up, sometimes at a silly hour like 06:30, and potter around, and at no time do I experience any desire to leave my front door. Not even to go to the local Cineworld.

I listen to CD's on my wonderful Marantz PM / CD 6003 set-up: today I went through a bunch of John Taverner CD's: The Protecting Veil, Song for Athene, and the Choral Works. I read, browse the web or work on some blog posts. I don't even do e-mails. I cook lunch, which I eat while watching an episode or two on my equally wonderful Sony Blu-Ray + Bravia TV set-up. Today it was four episodes of series two of Lie To Me, during which I did Windows updates on the netbook. This merges into afternoon tea, or in this case hot chocolate with toast and jam. I'm currently listening to a bunch of Wagner highlights on CD while ripping some CD's to go on the Nano I use at work.

It's been like this for quite a while. The grey skies do not make me want to leave the front door. Yesterday was a sunny-blue Saturday and I went for a walk in Virginia Water, some shopping, sat in the sun-trap reading Art and Text and saw The Lincoln Lawyer at the local Cineworld. Not today.

I used to do quite a bit more, but then I wasn't working in central London, so it was a treat to see and art show, watch a movie, browse round Foyles and have tea in Soho. Now that's where I work and what I do in the evening. Maybe I need the Day of Rest. And maybe what I need it from isn't so much central London as trains and crowds, and all those housework-y, life-managing things. Which would make sense. I do wake up on Monday feeling, let's say, more ready for the fight than I was Saturday evening.

Friday, 18 March 2011

How To Ease The Pain of SAS in Production - Part 2

In the first part we looked at the some of the data issues that I've found using SAS in production. Here are some of the coding issues.

SAS code is programming. Use descriptive names for variables and tables. Indent. Comment.
Since you’re going to delete all your working tables, don’t re-use them in a proc sort’s, data’s and sql’s. I call the de-duped result of proc sort on table X, “sorted_X”. Then I know where I am and so do you when you read the code.

You should not put usernames and passwords in code. And passwords expire. Use an input form to get those – make friends with the %Window macro.

Unless everyone in the team has the same SAS database modules use CONNECT TO ODBC (PROMPT) to access external databases.

On Mondays and Wednesdays I prefer PROC SQL to DATA steps, and on Tuesdays and Thursdays I prefer DATA steps. On Friday, I have no opinion. DATA steps are usually faster, PROC SQL is brain-space saving cross-use of a skill between SAS and the outside world.

SAS encourages you to fix problems in a production run by hacking at the original script: a quick resubmit here to run that little bit, a change of dates there, a little extra code… Do NOT do this: by the time you’ve finished the whole thing, you’re too tired and confused to un-hack the script. Next time you use it, it will not work. Fix the script. Re-run it from the start EVERY TIME. Then when it works, you know it will work next time.

SAS is too clever for its own good with dates. If it sees that a destination field in another database is a DATE field, it will assume the source field is a SAS date and translate that date into the destination database’s date format. This means you need to get Oracle dates like this: DATE - to_date('1960-01-01','yyyy-mm-dd').

If you’re starting by taking data from a database into a SAS table, do as much processing of the data in the SQL as possible, even data type conversions. I use a lot of pass-through queries to an Oracle database, and I find it a lot easier to write Oracle SQL than work out how to do the same thing in SAS. Also, lots of data manipulation is SAS makes for really scrappy looking code.

Sure, when SAS has a powerful bit of functionality it is really powerful (DATA / UPDATE combines a SQL append and update query in one simple bit of code), but when it doesn't, it hurts. This is how you do a string concatenation that references a couple of variables (startdate and enddate) in VBA…

Dim let dateConditionString as string
dateConditionString = "and DATE_B is null and DATE_A BETWEEN to_date('” & startdate & “,'yyyy-mm-dd') AND to_date('” & enddate &”,'yyyy-mm-dd')”

and this is how you do it in SAS…

%let dateConditionString = "and DATE_B is null and DATE_A BETWEEN to_date('&startdate','yyyy-mm-dd') AND to_date('&enddate','yyyy-mm-dd')";
data _null_;
call symput("dateConditionString", compress(&dateConditionString, '"'));
run;

This is not even scripting. It's DOS-level batch coding.

Wednesday, 16 March 2011

My Non-Alienating Moleskine Cahier

I use a Moleskine cahier to hold my reminder list. Each item gets a number - because I have a little bit of that obsessive-compulsive thing - and when it's done, I draw a line through it. When every item on a page is done, I put a diagonal line across the page. When I change my mind about an item, I put a cross through the number and a line through it. I jot down stuff when it occurs to me. The List is usually on the left page and the right page is for telephone numbers, odd details, books I want to price on Amazon and anything else.

My appointments diary is on iCal on my MacBook Pro, co-ordinated with Google Calendar and transferred to my phone now and again.

My contacts list is in Address Book on my MacBook Pro, co-ordinated with Google Contacts. And I use Gmail and access that through Mail.

That's it. That's how I manage my life. I used to wish I had a life that needed a Time Manager, or even a bulging Filofax, let alone an iPhone and multiple Google Calendars, but I now don't.

You see, reminders are one thing, but To-Do Lists and Plans and Projects are another, and we should not fall for it. My life is not a project, and I am not a project, even though I undertake multi-part activities over a period of time that have a purpose. It's one thing to plan the re-decoration of your hallway, but another to make it a Project. Projects have budgets, plans, targets, and can fail or succeed. Projects make you their servant, and the plans become a way for you to judge yourself. Make something a "project" and you alienate it from yourself.

Stick to re-decorating your hall. Or re-making the garden. Or writing a series of posts on algebraic geometry. Or finding another job. Those are parts of your life.

Monday, 14 March 2011

W H Auden's Canzone

I don't really do poetry. T S Eliot, of course, he's like Beethoven, even if you don't do classical music you like Beethoven, and even if you don't like poetry, you can be impressed by Eliot. And Mayakovsky, of whom I have a two-volume Russian edition of his complete poems. Sylvia Plath, but then I like Joni Mitchell as well, so call me a sensitive girl. And W H Auden. You would think that if I like Auden, I would like Spender and all the war poets and probably Keats as well. But I don't. I just like Auden. Canzone is my favourite - but you have to get the right edition of his works to find it - and I'm not sure I can explain why. It has a view of life and our place in it that rings true to me, but I'm not actually sure it makes a lot of sense, rather like Joni Mitchell's The Jungle Line. It sounds wonderful, so who cares?

Canzone - W H Auden
When shall we learn, what should be clear as day,
We cannot choose what we are free to love?
Although the mouse we banished yesterday
Is an enraged rhinoceros today,
Our value is more threatened than we know:
Shabby objections to our present day
Go snooping round its outskirts; night and day
Faces, orations, battles, bait our will
As questionable forms and noises will;
Whole phyla of resentments every day
Give status to the wild men of the world
Who rule the absent-minded and this world.

We are created from and with the world
To suffer with and from it day by day:
Whether we meet in a majestic world
Of solid measurements or a dream world
Of swans and gold, we are required to love
All homeless objects that require a world.
Our claim to own our bodies and our world
Is our catastrophe. What can we know
But panic and caprice until we know
Our dreadful appetite demands a world
Whose order, origin, and purpose will
Be fluent satisfaction of our will?

Drift, Autumn, drift; fall, colours, where you will:
Bald melancholia minces through the world.
Regret, cold oceans, the lymphatic will
Caught in reflection on the right to will:
While violent dogs excite their dying day
To bacchic fury; snarl, though, as they will,
Their teeth are not a triumph for the will
But utter hesitation. What we love
Ourselves for is our power not to love,
To shrink to nothing or explode at will,
To ruin and remember that we know
What ruins and hyaenas cannot know.

If in this dark now I less often know
That spiral staircase where the haunted will
Hunts for its stolen luggage, who should know
Better than you, beloved, how I know
What gives security to any world.
Or in whose mirror I begin to know
The chaos of the heart as merchants know
Their coins and cities, genius its own day?
For through our lively traffic all the day,
In my own person I am forced to know
How much must be forgotten out of love,
How much must be forgiven, even love.

Dear flesh, dear mind, dear spirit, O dear love,
In the depths of myself blind monsters know
Your presence and are angry, dreading Love
That asks its image for more than love;
The hot rampageous horses of my will,
Catching the scent of Heaven, whinny: Love
Gives no excuse to evil done for love,
Neither in you, nor me, nor armies, nor the world
Of words and wheels, nor any other world.
Dear fellow-creature, praise our God of Love
That we are so admonished, that no day
Of conscious trial be a wasted day.

Or else we make a scarecrow of the day,
Loose ends and jumble of our common world,
And stuff and nonsense of our own free will;
Or else our changing flesh may never know
There must be sorrow if there can be love.