### doitfaster.py
import os

os.system('mode con: cols=100 lines=20')

table = raw_input('input table name: ')
primarykey = raw_input('list primary keys, separated by spaces: ')

with open('sasjob.txt', 'r') as j:
    job = j.read()

job = job.format(table=table, primarykey=primarykey)

with open('sasjob.sas', 'w') as s:
    s.write(job)

with open('finished.txt', 'r') as f:
    fin = f.read()
    fin = fin + '\n' + table

with open('finished.txt', 'w') as f:
    f.write(fin)

with open('horse.txt', 'r') as h:
    horse = h.read()
    print horse
input()


### sasjob.txt
FILENAME WID26 'W:\WID27\batchexport\WID261PLUS.accdb';
FILENAME WID27 'W:\WID27\batchexport\WID27.mdb';

PROC IMPORT OUT = WORK.WID261PLUS
			DATATABLE = {table}
			DBMS = ACCESS REPLACE;
	DATABASE = WID26;
	SCANMEMO = YES;
	USEDATE = NO;
	SCANTIME = YES;
RUN;

PROC IMPORT OUT = WORK.WID27
			DATATABLE = {table}
			DBMS = ACCESS REPLACE;
		DATABASE = WID27;
		SCANMEMO = YES;
		USEDATE = NO;
		SCANTIME = YES;
RUN;

PROC APPEND BASE = WORK.WID27
			DATA = WORK.WID261PLUS
			FORCE;
RUN;

PROC SORT DATA = WORK.WID27
		DUPOUT = WORK.DUPLICATESREMOVED
		NODUPKEY;
	BY {primarykey};
RUN;

PROC EXPORT DATA= WORK.WID27
            OUTTABLE= {table}
            DBMS=ACCESS REPLACE;
     DATABASE=WID27;
RUN;


### horse.txt

               #    #
          %%% ##   ##
       %%%%% ###%%###
      %%%%% ### %%% #
    %%%%%% ### %%% ###
     %%%% ## %% #######
    %%%%% # %% #`#####
  %%%%%% # % #########
%%%%% ##### #########
 %% ####### #########
  ########## ########
 ############# #######
 ############### ######
################# #c###
#################  ###