https://communities.sas.com/t5/New-SAS-User/import-a-dat-file-with-the-top-label/m-p/702346#M25893 <PRE>data traffic2;<BR />infile "/folders/myfolders/np_traffic.dat" dlm='|';<BR />input Parkname$ Unitcode$ ParkType$ Region$TrafficCounter$ Reportdate$ TrafficCount;<BR />run;</PRE><P>when I use the codes above to import np.traffic.dat to sas, the top labels (Parkname$ Unitcode$ ParkType$ Region$TrafficCounter$ Reportdate$ TrafficCountis) are exactly repeated as the labels of SAS dataset.&nbsp; What is the better way to avoid the repeating label and the first row immediately starts with the real data?</P> Sun, 29 Nov 2020 21:02:08 GMT anming 2020-11-29T21:02:08Z https://communities.sas.com/t5/New-SAS-User/import-a-dat-file-with-the-top-label/m-p/702346#M25893 <PRE>data traffic2;<BR />infile "/folders/myfolders/np_traffic.dat" dlm='|';<BR />input Parkname$ Unitcode$ ParkType$ Region$TrafficCounter$ Reportdate$ TrafficCount;<BR />run;</PRE><P>when I use the codes above to import np.traffic.dat to sas, the top labels (Parkname$ Unitcode$ ParkType$ Region$TrafficCounter$ Reportdate$ TrafficCountis) are exactly repeated as the labels of SAS dataset.&nbsp; What is the better way to avoid the repeating label and the first row immediately starts with the real data?</P> Sun, 29 Nov 2020 21:02:08 GMT https://communities.sas.com/t5/New-SAS-User/import-a-dat-file-with-the-top-label/m-p/702346#M25893 anming 2020-11-29T21:02:08Z https://communities.sas.com/t5/New-SAS-User/import-a-dat-file-with-the-top-label/m-p/702351#M25894 <P>Adding OBS = 2 to your INFILE statement tells SAS to start reading data from the second record:</P> <PRE><CODE class=" language-sas">infile "/folders/myfolders/np_traffic.dat" dlm='|' obs = 2;</CODE></PRE> Sun, 29 Nov 2020 21:32:49 GMT https://communities.sas.com/t5/New-SAS-User/import-a-dat-file-with-the-top-label/m-p/702351#M25894 SASKiwi 2020-11-29T21:32:49Z https://communities.sas.com/t5/New-SAS-User/import-a-dat-file-with-the-top-label/m-p/702353#M25895 should be added "firstobs=2". Thanks! Sun, 29 Nov 2020 21:46:10 GMT https://communities.sas.com/t5/New-SAS-User/import-a-dat-file-with-the-top-label/m-p/702353#M25895 anming 2020-11-29T21:46:10Z https://communities.sas.com/t5/New-SAS-User/import-a-dat-file-with-the-top-label/m-p/702354#M25896 <P><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/356091">@anming</a>&nbsp; - Yes, FIRSTOBS.</P> Sun, 29 Nov 2020 21:49:42 GMT https://communities.sas.com/t5/New-SAS-User/import-a-dat-file-with-the-top-label/m-p/702354#M25896 SASKiwi 2020-11-29T21:49:42Z