<?xml version="1.0" encoding="utf-8"?><!DOCTYPE article  PUBLIC '-//OASIS//DTD DocBook XML V4.4//EN'  'http://www.docbook.org/xml/4.4/docbookx.dtd'><article><articleinfo><title>FAQ/saseg2</title><revhistory><revision><revnumber>2</revnumber><date>2013-03-08 10:17:24</date><authorinitials>localhost</authorinitials><revremark>converted to 1.6 markup</revremark></revision><revision><revnumber>1</revnumber><date>2009-04-08 11:21:55</date><authorinitials>PeterWatson</authorinitials></revision></revhistory></articleinfo><section><title>An example using a text file edited in EXCEL as input into SAS using the INFILE command</title><screen><![CDATA[DATA ONE(keep=id iq y r1 r2 match weight);
  INFILE "C:\Documents and Settings\peterw\Desktop\My Documents\My Do
cuments2\GEES_SAS\gee_import.txt";
  input iq1 iq2 r1 r2;
]]><![CDATA[
ID+1;
Y=r1;
MATCH=1;
IQ=iq1;
OUTPUT;
]]><![CDATA[
Y=r2;
MATCH=2;
IQ=iq2;
OUTPUT;
]]><![CDATA[
DATA TWO;
SET ONE;
]]><![CDATA[
match2=0;
]]><![CDATA[
if match=1 then do;
   match2 = 0;
end;
]]><![CDATA[
if match=2 then do;
   match2 = 1;
end;
]]><![CDATA[
run;
proc genmod data=two;
 class id;   
/* scwgt weight; */
 model y = match2 iq /dist=bin;
 repeated subject=id /type=un corrw;
 make 'geercov' out=rcov;
 make 'GEEEmpPest' out=wt;
 run;]]></screen></section></article>