Sorry it works! I had display=(novalues) previously. Thank you so much! ... View more

Thank you. But it still does not display the first and lat values. ... View more

I formatted the colaxis's data but I cannot use in the proc sgpanel; ods escapechar='~'; proc format lib=work; value col 2007 = "~{style [color=black] 2007}" 2016 = "~{style [color=black] 2016}" 2008 = "~{style [color=white] 2008}" 2009 = "~{style [color=white] 2009}" 2010 = "~{style [color=white] 2010}" 2011 = "~{style [color=white] 2011}" 2012 = "~{style [color=white] 2012}" 2013 = "~{style [color=white] 2013}" 2014 = "~{style [color=white] 2014}" 2015 = "~{style [color=white] 2015}" ; run; ... View more

So cool--it worked:) Thank you very much.   ... View more

Please see the text attached file (I have first rows with all the variables and sample 2-3 observations), there are not always 62 tabs because of missing data and random line breaks (new line). ... View more

When I read the infile with informat option, I still have the wrong data. All line breaks become a new observation.  Thank you. ... View more

Do all of the data lines take exactly two lines?   RE: No   Do all of the files have that structure? RE: No, there are missing data (see attached a sample test data). Do other files have a different number of lines of headers? RE: I think I have tab and line breaks (it was transferred through ftp). Does the number of lines of data per observation always match the number of header lines? Re: I do not think so.  If the number of variables changes between files is it constant per file? Re: Yes, I guess you are asking about if I have missing data? ... View more

FILENAME rawinput "\\ZULA\test.txt" ; data new; retain DOD_YR; infile rawinput dlm='09'X firstobs=2 missover truncover ; informat DOD_YR $4.; informat DSTATE $2.; informat FILENO $6.; informat GNAME $50.; informat MNAME $1.; informat LNAME $50.; informat SEX $1.; informat SSN $9.; informat AGETYPE $1.; informat AGE $3.; informat DOB_YR $4.; informat DOB_MO $2.; informat DOB_DY $2.; informat BPLACE_CNT $2.; informat BPLACE_ST $2.; informat STATEC $2.; informat MARITAL $1.; informat DPLACE $1.; informat DOD_MO $2.; informat DOD_DY $2.; informat DEDUC $1.; informat OCCUP $40.; informat OCCUPC $3.; informat INDUST $40.; informat INDUSTC $3.; informat ACME_UC $5.; informat AUTOP $1.; informat CERTL $30.; informat DINSTI $30.; informat STNUM_R $10.; informat STNAME_R $50.; informat STDESIG_R $10.; informat POSTDIR_R $10.; informat UNITNUM_R $7.; informat CITYTEXT_R $28.; informat ZIP9_R $9.; informat STATETEXT_R $28.; informat ADDRESS_R $50.; informat DETHNICE $3.; informat NCHSBRIDGE $2.; informat HISPOLDC $1.; informat RACEOLDC $1.; informat DMIDDLE $50.; informat COD1A $120.; informat INTERVAL1A $20.; informat COD1B $120.; informat INTERVAL1B $20.; informat COD1C $120.; informat INTERVAL1C $20.; informat COD1D $120.; informat INTERVAL1D $20.; informat OTHERCONDITION $240.; informat CERTFIRST $50.; informat CERTMIDDLE $50.; informat CERTLAST $50.; informat MEC_YR $4.; informat MEC_MO $2.; informat MEC_DAY $2.; informat MEC_NUMBER $8.; informat AGE_CALC $3.; informat MAR_WARD $6.; informat MAR_CENSUS_TRACT $9.; ; input DOD_YR $ DSTATE $ FILENO $ GNAME $ MNAME $ LNAME $ SEX $ SSN $ AGETYPE $ AGE $ DOB_YR $ DOB_MO $ DOB_DY $ BPLACE_CNT $ BPLACE_ST $ STATEC $ MARITAL $ DPLACE $ DOD_MO $ DOD_DY $ DEDUC $ OCCUP $ OCCUPC $ INDUST $ INDUSTC $ ACME_UC $ AUTOP $ CERTL $ DINSTI $ STNUM_R $ STNAME_R $ STDESIG_R $ POSTDIR_R $ UNITNUM_R $ CITYTEXT_R $ ZIP9_R $ STATETEXT_R $ ADDRESS_R $ DETHNICE $ NCHSBRIDGE $ HISPOLDC $ RACEOLDC $ DMIDDLE $ COD1A $ INTERVAL1A $ COD1B $ INTERVAL1B $ COD1C $ INTERVAL1C $ COD1D $ INTERVAL1D $ OTHERCONDITION $ CERTFIRST $ CERTMIDDLE $ CERTLAST $ MEC_YR $ MEC_MO $ MEC_DAY $ MEC_NUMBER $ AGE_CALC $ MAR_WARD $ MAR_CENSUS_TRACT $ ; run;   ... View more

I have informat for all variables, but it is still not working. I think there are many line breaks for many string variables. I used truncover missover, but those do not help. ... View more