Yes, because the other columns are okay. My desired output is in this form, minus the first three variables: data ARBEJDE.TIMETAL2006_2007;
infile datalines dsd truncover;
input aar:11. kommunenr:$3. kommunetx:$17. skolekode:11. skoletx:$100. kltrin:$200. trin:$12. dan:32. eng:32. tys:32. fra:32. kri:32. rel:32. his:32. sam:32. idr:32. mus:32. bil:32. mat:32. fk:32. geo:32. bio:32. nt:32. til:32. bhv:32. kla:32. hsh:32. Elev_normal:32. Elev_special:32. Timer_special:32. _920:32. _60:32. _63:32. _70:32. _800:32. _902:32. insttype:$4.;
datalines4;
2006,101,København,101001,Den Classenske Legatskole,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,750,0,0,,,,,,,,,,1012
2006,101,København,101001,Den Classenske Legatskole,1,1,330,0,0,0,30,0,0,0,60,60,30,150,0,0,0,30,0,0,30,0,,,,,,,,,,1012
2006,101,København,101001,Den Classenske Legatskole,2,2,270,0,0,0,30,0,0,0,60,60,60,150,0,0,0,30,0,0,30,0,,,,,,,,,,1012
2006,101,København,101001,Den Classenske Legatskole,3,3,210,60,0,0,30,0,30,0,60,60,60,150,0,0,0,60,0,0,30,0,,,,,,,,,,1012
2006,101,København,101001,Den Classenske Legatskole,4,4,180,60,0,0,30,0,30,0,60,60,60,120,0,0,0,60,0,0,30,60,,,,,,,,,,1012
2006,101,København,101001,Den Classenske Legatskole,5,5,150,90,0,0,30,0,30,0,90,60,60,120,0,0,0,60,0,0,30,60,,,,,,,,,,1012
2006,101,København,101001,Den Classenske Legatskole,6,6,180,90,0,0,30,0,60,0,60,0,0,120,0,0,0,60,0,0,30,60,,,,,,,,,,1012
2006,101,København,101001,Den Classenske Legatskole,7,7,150,90,90,90,0,0,60,0,60,0,0,120,60,60,60,0,0,0,30,60,,,,,,,,,,1012
2006,101,København,101001,Den Classenske Legatskole,8,8,150,90,90,90,60,0,30,60,60,0,0,120,60,30,30,0,60,0,30,0,,,,,,,,,,1012
2006,101,København,101001,Den Classenske Legatskole,9,9,180,90,90,0,30,0,60,30,60,0,0,120,90,30,30,0,180,0,30,0,,,,,,,,,,1012
2006,101,København,101001,Den Classenske Legatskole,10,10,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,,,,,,,,,,1012
2007,101,København,101001,Den Classenske Legatskole,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,750,0,0,,,,,,,,,,1012
2007,101,København,101001,Den Classenske Legatskole,1,1,390,0,0,0,30,0,0,0,60,60,30,150,0,0,0,30,0,0,30,0,,,,,,,,,,1012
2007,101,København,101001,Den Classenske Legatskole,2,2,300,0,0,0,30,0,0,0,60,60,60,150,0,0,0,30,0,0,30,0,,,,,,,,,,1012
2007,101,København,101001,Den Classenske Legatskole,3,3,240,60,0,0,30,0,30,0,60,60,60,150,0,0,0,60,0,0,30,0,,,,,,,,,,1012
2007,101,København,101001,Den Classenske Legatskole,4,4,180,60,0,0,30,0,30,0,90,60,60,120,0,0,0,60,0,0,30,60,,,,,,,,,,1012
2007,101,København,101001,Den Classenske Legatskole,5,5,150,90,0,0,30,0,30,0,90,60,60,120,0,0,0,60,0,0,30,60,,,,,,,,,,1012
2007,101,København,101001,Den Classenske Legatskole,6,6,180,90,0,0,30,0,60,0,90,60,0,120,0,0,0,60,0,0,30,120,,,,,,,,,,1012
2007,101,København,101001,Den Classenske Legatskole,7,7,150,90,90,90,0,0,60,0,60,0,0,120,60,60,60,0,0,0,30,120,,,,,,,,,,1012
2007,101,København,101001,Den Classenske Legatskole,8,8,150,90,90,90,30,0,30,60,60,0,0,120,90,30,30,0,51,0,30,0,,,,,,,,,,1012
2007,101,København,101001,Den Classenske Legatskole,9,9,180,90,90,90,30,0,30,30,60,0,0,120,60,30,30,0,51,0,30,0,,,,,,,,,,1012
2007,101,København,101001,Den Classenske Legatskole,10,10,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,,,,,,,,,,1012
2006,101,København,101003,Nyboder Skole,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,750,0,0,,,,,,,,,,1012
2006,101,København,101003,Nyboder Skole,1,1,330,0,0,0,30,0,0,0,60,60,60,150,0,0,0,30,0,0,30,0,,,,,,,,,,1012
2006,101,København,101003,Nyboder Skole,2,2,330,0,0,0,30,0,0,0,60,60,60,150,0,0,0,30,0,0,30,0,,,,,,,,,,1012
2006,101,København,101003,Nyboder Skole,3,3,210,60,0,0,30,0,30,0,60,60,60,150,0,0,0,60,0,0,30,0,,,,,,,,,,1012
2006,101,København,101003,Nyboder Skole,4,4,180,60,0,0,30,0,30,0,60,60,60,120,0,0,0,60,0,0,30,90,,,,,,,,,,1012
2006,101,København,101003,Nyboder Skole,5,5,180,90,0,0,30,0,30,0,90,30,60,120,0,0,0,60,0,0,30,60,,,,,,,,,,1012
2006,101,København,101003,Nyboder Skole,6,6,150,90,0,0,30,0,60,0,60,30,0,120,0,0,0,60,0,0,30,120,,,,,,,,,,1012
2006,101,København,101003,Nyboder Skole,7,7,150,90,90,90,0,0,60,0,60,0,0,120,60,60,60,0,0,0,30,60,,,,,,,,,,1012
2006,101,København,101003,Nyboder Skole,8,8,180,90,90,90,30,0,30,60,60,0,0,120,90,30,30,0,60,0,30,0,,,,,,,,,,1012
2006,101,København,101003,Nyboder Skole,9,9,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,,,,,,,,,,1012
2006,101,København,101003,Nyboder Skole,10,10,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,,,,,,,,,,1012
2007,101,København,10100
... View more