Dear ballardw, thanks for your suggestion. following the codes, data sa_step1.GDP;
infile 'F:\Dataset\Control variables\Source\1.GDP World Development Indicators\Data_Extract_From_World_Development_Indicators.csv' DLM=',' DSD missover lrecl = 32767 firstobs =2 ;
input
Country_Name :$50.
Country_Code :$29.
Series_Name :$250.
Series_Code :$250.
YR1980 :32.16
YR1981 :32.16
YR1982 :32.16
YR1983 :32.16
YR1984 :32.16
YR1985 :32.16
YR1986 :32.16
YR1987 :32.16
YR1991 :32.16
YR1992 :32.16
YR1993 :32.16
YR1994 :32.16
YR1995 :32.16
YR1996 :32.16
YR1997 :32.16
YR1998 :32.16
YR1999 :32.16
YR2000 :32.16
YR2001 :32.16
YR2002 :32.16
YR2006 :32.16
YR2007 :32.16
YR2008 :32.16
YR2009 :32.16
YR2010 :32.16
YR2011 :32.16
YR2012 :32.16
YR2013 :32.16
YR2014 :32.16
YR2015 :32.16
YR2016 :32.16
YR2017 :32.16
;
run; I still get the result like below, NOTE: A byte-order mark in the file "F:\Dataset\Control variables\Source\1.GDP World Development
Indicators\Data_Extract_From_World_Development_Indicators.csv" (for fileref "#LN00044")
indicates that the data is encoded in "utf-8". This encoding will be used to process the file.
NOTE: The infile 'F:\Dataset\Control variables\Source\1.GDP World Development
Indicators\Data_Extract_From_World_Development_Indicators.csv' is:
Filename=F:\Dataset\Control variables\Source\1.GDP World Development
Indicators\Data_Extract_From_World_Development_Indicators.csv,
RECFM=V,LRECL=131068,File Size (bytes)=2451486,
Last Modified=27 September 2018 16:49:31 o'c,
Create Time=27 September 2018 10:56:02 o'c
NOTE: Invalid data for YR1980 in line 2 56-57.
NOTE: Invalid data for YR1981 in line 2 59-60.
NOTE: Invalid data for YR1982 in line 2 62-63.
NOTE: Invalid data for YR1983 in line 2 65-66.
NOTE: Invalid data for YR1984 in line 2 68-69.
NOTE: Invalid data for YR1985 in line 2 71-72.
NOTE: Invalid data for YR1986 in line 2 74-75.
NOTE: Invalid data for YR1987 in line 2 77-78.
NOTE: Invalid data for YR1991 in line 2 80-81.
NOTE: Invalid data for YR1992 in line 2 83-84.
NOTE: Invalid data for YR1993 in line 2 86-87.
NOTE: Invalid data for YR1994 in line 2 89-90.
NOTE: Invalid data for YR1995 in line 2 92-93.
NOTE: Invalid data for YR1996 in line 2 95-96.
NOTE: Invalid data for YR1997 in line 2 98-99.
NOTE: Invalid data for YR1998 in line 2 101-102.
NOTE: Invalid data for YR1999 in line 2 104-105.
NOTE: Invalid data for YR2000 in line 2 107-108.
NOTE: Invalid data for YR2001 in line 2 110-111.
RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9--
2 Afghanistan,AFG,GDP (constant 2010 US$),NY.GDP.MKTP.KD,..,..,..,..,..,..,..,..,..,..,..,..,.
93 .,..,..,..,..,..,..,8013233121.55065,10305228125.1392,11721187594.2052,12144482858.18,146973
185 31940.6464,15936800636.2487,16911126453.2276,19352203805.6294,20107051005.0514,20648035625.4
277 122,20918533234.6796,21413614653.3241,21969414112.4281 330
Country_Name=Afghanistan Country_Code=AFG Series_Name=GDP (constant 2010 US$)
Series_Code=NY.GDP.MKTP.KD YR1980=. YR1981=. YR1982=. YR1983=. YR1984=. YR1985=. YR1986=. YR1987=.
YR1991=. YR1992=. YR1993=. YR1994=. YR1995=. YR1996=. YR1997=. YR1998=. YR1999=. YR2000=. YR2001=.
YR2002=8013233121.6 YR2006=10305228125 YR2007=11721187594 YR2008=12144482858 YR2009=14697331941
YR2010=15936800636 YR2011=16911126453 YR2012=19352203806 YR2013=20107051005 YR2014=20648035625
YR2015=20918533235 YR2016=21413614653 YR2017=21969414112 _ERROR_=1 _N_=1
...
NOTE: Invalid data for YR1980 in line 21 68-69.
NOTE: Invalid data for YR1981 in line 21 71-72.
NOTE: Invalid data for YR1982 in line 21 74-75.
NOTE: Invalid data for YR1983 in line 21 77-78.
NOTE: Invalid data for YR1984 in line 21 80-81.
NOTE: Invalid data for YR1985 in line 21 83-84.
NOTE: Invalid data for YR1986 in line 21 86-87.
NOTE: Invalid data for YR1987 in line 21 89-90.
NOTE: Invalid data for YR1991 in line 21 92-93.
NOTE: Invalid data for YR1992 in line 21 95-96.
NOTE: Invalid data for YR1993 in line 21 98-99.
NOTE: Invalid data for YR1994 in line 21 101-102.
NOTE: Invalid data for YR1995 in line 21 104-105.
NOTE: Invalid data for YR1996 in line 21 107-108.
NOTE: Invalid data for YR1997 in line 21 110-111.
NOTE: Invalid data for YR1998 in line 21 113-114.
NOTE: Invalid data for YR1999 in line 21 116-117.
NOTE: Invalid data for YR2000 in line 21 119-120.
NOTE: Invalid data for YR2001 in line 21 122-123.
WARNING: Limit set by ERRORS= option reached. Further errors of this type will not be printed.
21 Afghanistan,AFG,GDP: linked series (current LCU),NY.GDP.MKTP.CN.AD,..,..,..,..,..,..,..,..,.
93 .,..,..,..,..,..,..,..,..,..,..,185470755700,352307549100,490403496600,519186097400,61508311
185 1900,729900688100,856323131400,1061312099400,1145471405100,1183298415200,1227955128600,13214
277 18997400,1421787000000 298
Country_Name=Afghanistan Country_Code=AFG Series_Name=GDP: linked series (current LCU)
Series_Code=NY.GDP.MKTP.CN.AD YR1980=. YR1981=. YR1982=. YR1983=. YR1984=. YR1985=. YR1986=. YR1987=.
YR1991=. YR1992=. YR1993=. YR1994=. YR1995=. YR1996=. YR1997=. YR1998=. YR1999=. YR2000=. YR2001=.
YR2002=0.0000185471 YR2006=0.0000352308 YR2007=0.0000490403 YR2008=0.0000519186 YR2009=0.0000615083
YR2010=0.0000729901 YR2011=0.0000856323 YR2012=0.0001061312 YR2013=0.0001145471 YR2014=0.0001183298
YR2015=0.0001227955 YR2016=0.0001321419 YR2017=0.0001421787 _ERROR_=1 _N_=20
NOTE: 5285 records were read from the infile 'F:\Dataset\Control variables\Source\1.GDP World
Development Indicators\Data_Extract_From_World_Development_Indicators.csv'.
The minimum record length was 35.
The maximum record length was 713.
NOTE: The data set SA_STEP1.GDP has 5285 observations and 36 variables.
NOTE: DATA statement used (Total process time):
real time 0.58 seconds
cpu time 0.24 seconds
could you please give me more advice?
... View more