Convert SAS Datetime to [R] Datetime

Posted by admin on March 24, 2014

Suppose I import a bunch of SAS dates into R. How well does that work?

Not very. First is the import itself. If you use read.csv, R will try to import the datetime field as factors, which creates a big ol mess. Let's fix that first. When you use read.csv, remember to include this phrase:

stringAsFactor=FALSE 

 

in the read.csv function as a parameter. That will import the SAS datetime field as a string. OK, now lets do our conversion:

 

datetime.field=strptime(SAS_DATE_TIME, "%d%b%Y:%H:%M:%S.%s")

And you're done. Problem solved.

 

 

0 Comments Read full post »

My Windows 7 laptop went haywire this morning, suddenly unrecognizing my USB devices. A short googling of the problem showed it wasn't uncommon. The solution was quite easy, and worked:

 

Unplug the power supply from the laptop and reboot.

That's it. Don't reinstall a bunch of drivers, reinstall your operating system, or any other craziness. Try this first.

0 Comments Read full post »

So I decided to make this web application that a user could create a legal form in Microsoft Word (docx) format, and since my web site is in PHP, and I wanted to learn PHP better. Just a few issues:

1) PHP can't make a Word - .docx document easily. Sure, you can do your bits and bytes and try to decode the entire format. Docx is just an archive, and you can zip up the components, but then you can't get your compression ratio right, and Word tells you the document is malformed when your browser calls it and blah-blah fricken blah. 

OK, so I figure, Java has libraries to do this, and do it easily. So I'll just make a Java program that will take the form data from the PHP generated form and make the docx. No problem at all, did this in a few hours with no knowledge of the java library that I used (docx4j). 

OK, so I jar up the program, make a properties file for paths and so forth, and deploy said jar to the Apache server on a windows system where I'm developing. Now, all I gotta do, is call the Java program from the php.

Whoops.

Calling a java program from php over the host operating system is about as easy as calling the international space station from a tin can with a string on it. To make it worse, I have to deploy on a Linux system making whatever Windows solution I come up with totally worthless. Now I find out about JavaBridge, which my zend php server tells me that it doesn't like, or home made solutions by changing the apache configuration settings which blows up apache and blah blah fricken blah.

OK, then it came to me. Talking to java over the operating system, isn't the only way to talk to java. You can talk to java through the file system. How? Just add a java listener to your java program, leave a marker on the file system from php...a text file with the docx's id number which I had already set up. Have the java listener make the docx, have the php sleep until it sees it. Bada bing bada bang...we have our solution. I wrote the listener in under an hour from scatch. Clean up by deleting the files with a sweep utility after generation. Works faster that any other way too.

 

 

 

1 Comment Read full post »

While downloading a skin for rainmeter, I picked up a nasty little trojan called GorrillaPrice. First off, don't go to this page if you are trying to get BlueVision for Rainmeter:

 

http://g3xter.deviantart.com/art/BlueVision-V0-2-Alpha-RAINMETER-162478234

DO NOT DOWNLOAD ANYTHING FROM THIS PAGE!

Because if you use the link there, BLAM! Trojan! No more internet. The idiot that set up the trojan was trying to set it up so all web transmissions go through a proxy that sets up in your internet connection settings. He screwed that up, so when you try and surf the web and click on a link Chrome tries to download to the page instead of navigating to it.

I read all kinds of crazyness about how to fix this, some people wiped their OS and reloaded it. After a few times trying to reset the connection settings on my Windows 7 x64 box, I figured out the Trojan wasn't going away quietly.

After digging around on my hardrive for a while, I discovered two files

C:\Program Files\GorillaPrice\GorillaPrice.exe

And another one newly added by the trojan at the same time. I deleted them both, reset my internet connection to not use the proxy anymore, and that's it. Everything started working again. That's it. No need to download a thousand adware removal tools, no need to reload the whole damn computer. That's all you need to do.

 

0 Comments Read full post »

Hunter ceiling fan to remote receiver wiring

Posted by admin on February 2, 2014

Wiring up a hunter ceiling fan to a remoter receiver can be a painful mess. I found all kinds of confusing guides on how to do it. Here are some clarifying instructions.

The box in my ceiling has a white wire, a black wire, a red wire, and a green for ground. The black is hot, the red is hot when the wall switch is in the on position, and the white is neutral.

The remoter receiver has black and white wires in, black ,white, and blue out.

The hunter ceiling fan has two black, one white, and one green. All part of the harassment package my friend.

Ok, we're going to wire up the whole fan to the switch on the wall.

1) Pull the circuit breaker to the fan so you don't shock yourself and die. Dying is bad, and you might go to hell. If you're an enemy of the United States, go ahead and leave it on.

2)  Cap off the black wire from the ceiling. We're not going to use that.

3)  Connect the green wire from the ceiling, to the green wire from the fan. This is your ground. You'll know if you didn't connect it right, because if a bulb blows out under the fan all the lights in the house will go out.

4)  Connect the red wire from the ceiling into the black wire into the fan remote receiver. This is the hot wire from the wall switch.

5) Connect the white from ceiling to white into fan remote receiver.

6) White out from remote receiver into white into fan.

7) Blue out from remote receiver into black wire with white stripe. This is the hot into fan light.

8) Black out from remote receiver into black into fan. This is the fan hot.

 

Button up the fan, circuit breaker on, fan wall switch on, remote swith on, and hopefully you got it.

 

 

 

 

0 Comments Read full post »

Excel VBA to find and replace chart title strings

Posted by admin on November 20, 2013

 

Sub changeChartTitles()

Dim c As Chart

ws_count = ThisWorkbook.Worksheets.Count

 

For i = 1 To ws_count

Set ws = ThisWorkbook.worksheets(i)

For j = 1 to ws.ChartObjects(j).Chart

Set c= ws.ChartObjects(j).Chart

c.ChartTitle.Text= Replace(c.ChartTitle.Text, "OldStuff", "NewStuff")

Next 'j

Next 'i

End Sub

 

0 Comments Read full post »

SAS Iterate through comma separated list

Posted by admin on November 20, 2013

There is probably a better way to do this..if you know of one please tell me. This way looks pretty clunky to me:

 

%GLOBAL BP_DESC_VAR BP;
/* MAKE LIST */
PROC SQL;
CREATE TABLE BPS (BP CHAR(100));
QUIT;
PROC SQL;
INSERT INTO BPS(BP) VALUES ('stuff 1');
QUIT;
PROC SQL;
INSERT INTO BPS(BP) VALUES ('stuff 2');
QUIT;
proc sql noprint;
select BP
into :bp SEPARATED BY ','
FROM BPS;
quit;
%MACRO LOOP_BPS;
%LET BP_DESC_VAR='';
%LET I=1;
%LET BP_DESC_VAR=%QSCAN(%SUPERQ(BP),&I.,',');
%PUT &BP_DESC_VAR;

%DO %UNTIL(&BP_DESC_VAR EQ %NRSTR());
%LET I=%EVAL(&I+1);
%LET BP_DESC_VAR=%QSCAN(%SUPERQ(BP),&I.,',');
%PUT &BP_DESC_VAR;
%END;
%MEND;
%LOOP_BPS;

 

4 Comments Read full post »

SAS Table Value into variable

Posted by admin on June 4, 2013

Here's some macro code to put a list of values from a SAS table into a bunch of variables:

 

%LET CURRENT_TABLE_DATE = 'APR2009';

%GLOBAL CURRENT_TABLE_DATE;

%MACRO RUN_DATES;

PROC SQL;

SELECT DISTINCT TABLE_DATE INTO :TABLE_DATE1-:TABLE_DATE100

FROM DATE_LIST;

QUIT;

 

%DO I=1 %TO 100;

%LET CURR_TABLE_DATE=&&TABLE_DATE&I;

%PUT &I &&TABLE_DATE&I &CURR_TABLE_DATE;

%MY_MACRO_THAT_USES_GLOBAL_VARIABLE;

%END;

%MEND RUN_DATES;

%RUN_DATES;

0 Comments Read full post »

I've seen a lot of ugly ways to count the number of words in a comma separated list, most of them involve an overly complicated macro. There is an easier way. Just add a field to your table, then you want to use the LENGTH function to count your comma separated list, and the LENGTH and COMPRESS function to count the string with your commas removed. This will give you the number of words in the list:

 

data temp_stuff;

set temp_stuff;

list_count = length(comma_list)-length(compress(comma_list,","));

run;

 

1 Comment Read full post »

Get Installed Programs from Registry Windows 7

Posted by admin on October 19, 2012

Here's a little batch file utility to get your installed programs from your Windows 7 registry. This was adapted from an online script that doesn't work on Win 7:

 

C:\Windows\System32\reg export  HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall temp1.txt

 

This needs to be all on one line in the batch file, with a space between export and HKEY... my editor broke it into two lines.

 

 

 

 

0 Comments Read full post »