-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathload-500cities-2018.sas
57 lines (55 loc) · 1.02 KB
/
load-500cities-2018.sas
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
filename cities ZIP 'C:\sasquatch-data\500Cities.zip';
DATA project.Cities2018;
LENGTH
Year 8
StateAbbr $ 2
StateDesc $ 50
CityName $ 50
GeographicLevel $ 12
DataSource $ 5
Category $ 19
UniqueID $ 19
Measure $ 192
Data_Value_Unit $ 1
DataValueTypeID $ 9
Data_Value_Type $ 23
Data_Value 8
Low_Confidence_Limit 8
High_Confidence_Limit 8
Data_Value_Footnote_Symbol $ 1
Data_Value_Footnote $ 53
PopulationCount 8
GeoLocation $ 33
CategoryID $ 7
MeasureId $ 12
CityFIPS 8
TractFIPS 8
Short_Question_Text $ 40;
INFILE cities(500Cities2018.csv)
delimiter=',' DSD lrecl=32767 firstobs=2 ;
INPUT
Year
StateAbbr
StateDesc
CityName
GeographicLevel
DataSource
Category
UniqueID
Measure
Data_Value_Unit
DataValueTypeID
Data_Value_Type
Data_Value
Low_Confidence_Limit
High_Confidence_Limit
Data_Value_Footnote_Symbol
Data_Value_Footnote
PopulationCount
GeoLocation
CategoryID
MeasureId
CityFIPS
TractFIPS
Short_Question_Text;
RUN;