Canadian, born in Toronto, raised in Yellowknife, trombonist, hockey referee, trivia whiz, Monty Python fanatic, Edmonton Eskimos fan, love snowmobiles and motorcycles, married, father of six, and so on.
I've got a bunch of queries which use a few different dates in different WHERE clauses in PROC SQL statements. Some of those queries are pass-through queries to Teradata. I've gone through documentation and other questions/answers here, and tried different things to figure this out, but I haven't found the solution that works. This is what I want to do: Prompt the user for a month and year (e.g. OCT16, like MONYY. format); Calculate various dates from that prompt result (e.g. calculate 2016-10-31 and 2015-11-01 as &EndDate and &StartDate from OCT16); Format those dates properly in a PROC SQL statement that is a pass-through query to one of our Teradata data warehouses, as in the following: connect to teradata as mycon(server= dwprod3 authdomain=teradataauth mode=teradata ); create table MyTable as select * from connection to mycon ( Select * From COC_V20_NOHAPHI.TABLE WHERE TABLE.RecordDate between &StartDate. and &EndDate. );
... View more
I've got a similar situation here, and I'm not sure what I need. I have SAS EG 6.1 64-bit and 7.1 64-bit, but I don't have SAS itself on my PC (we're running on a GRID server). I need to export to Access (I have Office Professional 2010, 32-bit), but I don't see that option within EG. Can I do it if I install the PC Files Server (and is that something for my PC or for the SAS GRID server?)? Or do I need something else to be able to do this export?
... View more
