libname path 'C:\Documents and Settings\lpeck1\My Documents\Cross-State Policy\CPS data\TAXSIM' ;

filename raw92 'C:\Documents and Settings\lpeck1\My Documents\Cross-State Policy\CPS data\TAXSIM\TAXSIM92out.txt' ;
filename raw93 'C:\Documents and Settings\lpeck1\My Documents\Cross-State Policy\CPS data\TAXSIM\TAXSIM93out.txt' ;
filename raw94 'C:\Documents and Settings\lpeck1\My Documents\Cross-State Policy\CPS data\TAXSIM\TAXSIM94out.txt' ;
filename raw95 'C:\Documents and Settings\lpeck1\My Documents\Cross-State Policy\CPS data\TAXSIM\TAXSIM95out.txt' ;
filename raw96 'C:\Documents and Settings\lpeck1\My Documents\Cross-State Policy\CPS data\TAXSIM\TAXSIM96out.txt' ;
filename raw97 'C:\Documents and Settings\lpeck1\My Documents\Cross-State Policy\CPS data\TAXSIM\TAXSIM97out.txt' ;
filename raw98 'C:\Documents and Settings\lpeck1\My Documents\Cross-State Policy\CPS data\TAXSIM\TAXSIM98out.txt' ;
filename raw99 'C:\Documents and Settings\lpeck1\My Documents\Cross-State Policy\CPS data\TAXSIM\TAXSIM99out.txt' ;
filename raw00 'C:\Documents and Settings\lpeck1\My Documents\Cross-State Policy\CPS data\TAXSIM\TAXSIM00out.txt' ;
filename raw01 'C:\Documents and Settings\lpeck1\My Documents\Cross-State Policy\CPS data\TAXSIM\TAXSIM01out.txt' ;
filename raw02 'C:\Documents and Settings\lpeck1\My Documents\Cross-State Policy\CPS data\TAXSIM\TAXSIM02out.txt' ;
filename raw03 'C:\Documents and Settings\lpeck1\My Documents\Cross-State Policy\CPS data\TAXSIM\TAXSIM03out.txt' ;
filename raw04 'C:\Documents and Settings\lpeck1\My Documents\Cross-State Policy\CPS data\TAXSIM\TAXSIM04out.txt' ;
filename raw05 'C:\Documents and Settings\lpeck1\My Documents\Cross-State Policy\CPS data\TAXSIM\TAXSIM05out.txt' ;

%macro readin; 
%do i=2 %to 9;
data path.tax9&i ;
infile raw9&i lrecl=352 ;

input 
RECNUM 1-8
TYear 10-13
TState 15-16
TFedTax 18-25
TStTax 27-34
TFICA 36-42
TFMarg 43-49
TSMarg 51-56
TFICAr 58-63
TFAGI 65-72
TFAGIui 74-81
TFAGIss 83-90 
TFzero 92-99
TFPEx 101-108
TFExPh 110-117
TFDePh 119-126
TFDeAl 128-135
TFTInc 137-144
TFRegTax 146-153
TFExSur 155-162
TFGenCred 164-171
TFCCCredA 173-180
TFCCRef 182-189
TFCCCred 191-198
TFEITC 200-207
TFAltInc 209-216
TFLiab 218-225
TFNetTax 227-234
TFICA 236-243
FSHInc 245-252
FSrent 254-261
TSAGI 263-270
TSPEx 272-279
TSStDe 281-288
TSItDe 290-297
TSTInc 299-306
TSPCred 308-315
TSCCCred 317-324
TSGCred 326-333
TSCreds 335-342
TSBRate 344-351;

label
RECNUM='CPS Unicom Record Number'
TYear='TAXSIM Tax Year'
TState='TAXSIM state number'
TFedTax='TAXSIM Federal tax liability'
TStTax='TAXSIM State tax liability'
TFICA='TAXSIM FICA (OADSI and HI)'
TFMarg='TAXSIM Effective federal marginal rate'
TSMarg='TAXSIM Effective state marginal rate'
TFICAr='TAXSIM FICA rate'
TFAGI='TAXSIM Federal AGI'
TFAGIui='TAXSIM UI in AGI'
TFAGIss='TAXSIM Social Security in AGI'
TFzero='TAXSIM Zero Bracket Amount'
TFPEx='TAXSIM Personal Exemptions'
TFExPh='TAXSIM Exemption Phaseout'
TFDePh='TAXSIM Deduction Phaseout'
TFDeAl='TAXSIM Deductions allowed'
TFTInc='TAXSIM Federal Taxable Income'
TFRegTax='TAXSIM Federal Regular Tax'
TFExSur='TAXSIM Exemption Surtax'
TFGenCred='TAXSIM General Tax Credit'
TFCCCredA='TAXSIM Child Tax Credit (as adjusted)'
TFCCRef='TAXSIM Refundable Part of Child Tax Credit'
TFCCCred='TAXSIM Child Care Credit'
TFEITC='TAXSIM Earned Income Credit'
TFAltInc='TAXSIM Income for the Alternative Minimum Tax'
TFLiab='TAXSIM AMT Liability (addition to regular tax)'
TFNetTax='TAXSIM Federal Income Tax After Credits'
TFICA='TAXSIM FICA '
/* state variables */
FSHInc='TAXSIM State Household Income'
FSrent='TAXSIM State Rent Payments'
TSAGI='TAXSIM State AGI'
TSPEx='TAXSIM State Exemption amount'
TSStDe='TAXSIM State Standard Deduction'
TSItDe='TAXSIM State Itemized Deductions' 
TSTInc='TAXSIM State Taxable Income'
TSPCred='TAXSIM State Property Tax Credit'
TSCCCred='TAXSIM State Child Care Credit'
TSGCred='TAXSIM State General Credit'
TSCreds='TAXSIM State Total Credits'
TSBRate='TAXSIM State Bracket Rate' ;

proc means; 
   title 'Test Means Taxsim data 199'&i;
run;
%end; %mend; %readin; run;

%macro readin; 
%do i=0 %to 5;
data path.tax0&i ;
infile raw0&i lrecl=352 ;

input 
RECNUM 1-8
TYear 10-13
TState 15-16
TFedTax 18-25
TStTax 27-34
TFICA 36-42
TFMarg 43-49
TSMarg 51-56
TFICAr 58-63
TFAGI 65-72
TFAGIui 74-81
TFAGIss 83-90 
TFzero 92-99
TFPEx 101-108
TFExPh 110-117
TFDePh 119-126
TFDeAl 128-135
TFTInc 137-144
TFRegTax 146-153
TFExSur 155-162
TFGenCred 164-171
TFCCCredA 173-180
TFCCRef 182-189
TFCCCred 191-198
TFEITC 200-207
TFAltInc 209-216
TFLiab 218-225
TFNetTax 227-234
TFICA 236-243
FSHInc 245-252
FSrent 254-261
TSAGI 263-270
TSPEx 272-279
TSStDe 281-288
TSItDe 290-297
TSTInc 299-306
TSPCred 308-315
TSCCCred 317-324
TSGCred 326-333
TSCreds 335-342
TSBRate 344-351;

label
RECNUM='CPS Unicom Record Number'
TYear='TAXSIM Tax Year'
TState='TAXSIM state number'
TFedTax='TAXSIM Federal tax liability'
TStTax='TAXSIM State tax liability'
TFICA='TAXSIM FICA (OADSI and HI)'
TFMarg='TAXSIM Effective federal marginal rate'
TSMarg='TAXSIM Effective state marginal rate'
TFICAr='TAXSIM FICA rate'
TFAGI='TAXSIM Federal AGI'
TFAGIui='TAXSIM UI in AGI'
TFAGIss='TAXSIM Social Security in AGI'
TFzero='TAXSIM Zero Bracket Amount'
TFPEx='TAXSIM Personal Exemptions'
TFExPh='TAXSIM Exemption Phaseout'
TFDePh='TAXSIM Deduction Phaseout'
TFDeAl='TAXSIM Deductions allowed'
TFTInc='TAXSIM Federal Taxable Income'
TFRegTax='TAXSIM Federal Regular Tax'
TFExSur='TAXSIM Exemption Surtax'
TFGenCred='TAXSIM General Tax Credit'
TFCCCredA='TAXSIM Child Tax Credit (as adjusted)'
TFCCRef='TAXSIM Refundable Part of Child Tax Credit'
TFCCCred='TAXSIM Child Care Credit'
TFEITC='TAXSIM Earned Income Credit'
TFAltInc='TAXSIM Income for the Alternative Minimum Tax'
TFLiab='TAXSIM AMT Liability (addition to regular tax)'
TFNetTax='TAXSIM Federal Income Tax After Credits'
TFICA='TAXSIM FICA '
/* state variables */
FSHInc='TAXSIM State Household Income'
FSrent='TAXSIM State Rent Payments'
TSAGI='TAXSIM State AGI'
TSPEx='TAXSIM State Exemption amount'
TSStDe='TAXSIM State Standard Deduction'
TSItDe='TAXSIM State Itemized Deductions' 
TSTInc='TAXSIM State Taxable Income'
TSPCred='TAXSIM State Property Tax Credit'
TSCCCred='TAXSIM State Child Care Credit'
TSGCred='TAXSIM State General Credit'
TSCreds='TAXSIM State Total Credits'
TSBRate='TAXSIM State Bracket Rate' ;

proc means; 
   title 'Test Means Taxsim data 200'&i;
run;
%end; %mend; %readin; run;