How can I automatically read this file
http://www.nanpa.com/nanp1/allutlzd.zip
in SAS?
the code below is not working !
filename allstate url "http://www.nanpa.com/nanp1/allutlzd.zip" ;
data urlall;
LENGTH
State $ 2
'NPA-NXX'n $ 7
OCN $ 4
Company $ 50
RateCenter $ 10
EffectiveDate 8
Use $ 2
AssignDate 8
'Initial/Growth'n $ 1
'Pooled Code File Updated 04/06/2'n $ 1 ;
LABEL
'Pooled Code File Updated 04/06/2'n = "Pooled Code File Updated 04/06/2017" ;
FORMAT
State $CHAR2.
'NPA-NXX'n $CHAR7.
OCN $CHAR4.
Company $CHAR50.
RateCenter $CHAR10.
EffectiveDate MMDDYY10.
Use $CHAR2.
AssignDate MMDDYY10.
'Initial/Growth'n $CHAR1.
'Pooled Code File Updated 04/06/2'n $CHAR1. ;
INFORMAT
State $CHAR2.
'NPA-NXX'n $CHAR7.
OCN $CHAR4.
Company $CHAR50.
RateCenter $CHAR10.
EffectiveDate MMDDYY10.
Use $CHAR2.
AssignDate MMDDYY10.
'Initial/Growth'n $CHAR1.
'Pooled Code File Updated 04/06/2'n $CHAR1. ;
INFILE allstate MISSOVER DLM=' ' DSD FIRSTOBS=2 ;
INPUT
State : $CHAR2.
'NPA-NXX'n : $CHAR7.
OCN : $CHAR4.
Company : $CHAR50.
RateCenter : $CHAR10.
EffectiveDate : ?? MMDDYY10.
Use : $CHAR2.
AssignDate : ?? MMDDYY10.
'Initial/Growth'n : $CHAR1.
'Pooled Code File Updated 04/06/2'n : $CHAR1. ;
run;
Include a call to proc http! Here is blog from @Chris describing the method: http://blogs.sas.com/content/sasdummy/2014/01/29/using-filename-zip/
Art, CEO, AnalystFinder.com
Include a call to proc http! Here is blog from @Chris describing the method: http://blogs.sas.com/content/sasdummy/2014/01/29/using-filename-zip/
Art, CEO, AnalystFinder.com
It works.
Ty Art.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.