Read Zip file from a website

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

Read Zip file from a website

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;


Accepted Solutions
Solution
‎04-06-2017 02:05 PM
PROC Star
Posts: 7,480

Re: Read Zip file from a website

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

 

View solution in original post


All Replies
Solution
‎04-06-2017 02:05 PM
PROC Star
Posts: 7,480

Re: Read Zip file from a website

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

 

New Contributor
Posts: 2

Re: Read Zip file from a website

It works.

Ty Art.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 132 views
  • 0 likes
  • 2 in conversation