Read Zip file from a website

[MikeAAC]

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;

[art297 · Accepted solution]

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

[MikeAAC]

It works.

Ty Art.