topic Re: Read Zip file from a website in SAS Programming https://communities.sas.com/t5/SAS-Programming/Read-Zip-file-from-a-website/m-p/347861#M273354 <P>It works.</P><P>Ty Art.</P> Thu, 06 Apr 2017 18:05:59 GMT MikeAAC 2017-04-06T18:05:59Z Read Zip file from a website https://communities.sas.com/t5/SAS-Programming/Read-Zip-file-from-a-website/m-p/347842#M273352 <P>How can I automatically read this file</P><P><SPAN><A href="http://www.nanpa.com/nanp1/allutlzd.zip" target="_blank"><FONT color="#0563c1" face="Calibri" size="3">http://www.nanpa.com/nanp1/allutlzd.zip</FONT></A></SPAN></P><P>in SAS?</P><P>&nbsp;</P><P>the code below is not working !</P><P>&nbsp;</P><P><FONT color="#0000ff" face="Courier New" size="3">filename</FONT><FONT face="Courier New" size="3"> allstate </FONT><FONT color="#0000ff" face="Courier New" size="3">url</FONT> <FONT color="#800080" face="Courier New" size="3">"<A href="http://www.nanpa.com/nanp1/allutlzd.zip" target="_blank">http://www.nanpa.com/nanp1/allutlzd.zip</A>"</FONT><FONT face="Courier New" size="3"> ;</FONT></P><P><FONT color="#000080" face="Courier New" size="3"><STRONG>data</STRONG></FONT><FONT face="Courier New" size="3"> urlall;</FONT></P><P>LENGTH</P><P><FONT face="Courier New" size="3">State $ </FONT><STRONG><FONT color="#008080" face="Courier New" size="3">2</FONT></STRONG></P><P><FONT color="#800080" face="Courier New" size="3">'NPA-NXX'n</FONT><FONT face="Courier New" size="3"> $ </FONT><STRONG><FONT color="#008080" face="Courier New" size="3">7</FONT></STRONG></P><P><FONT face="Courier New" size="3">OCN $ </FONT><STRONG><FONT color="#008080" face="Courier New" size="3">4</FONT></STRONG></P><P><FONT face="Courier New" size="3">Company $ </FONT><STRONG><FONT color="#008080" face="Courier New" size="3">50</FONT></STRONG></P><P><FONT face="Courier New" size="3">RateCenter $ </FONT><STRONG><FONT color="#008080" face="Courier New" size="3">10</FONT></STRONG></P><P><FONT face="Courier New" size="3">EffectiveDate </FONT><STRONG><FONT color="#008080" face="Courier New" size="3">8</FONT></STRONG></P><P><FONT face="Courier New" size="3">Use $ </FONT><STRONG><FONT color="#008080" face="Courier New" size="3">2</FONT></STRONG></P><P><FONT face="Courier New" size="3">AssignDate </FONT><STRONG><FONT color="#008080" face="Courier New" size="3">8</FONT></STRONG></P><P><FONT color="#800080" face="Courier New" size="3">'Initial/Growth'n</FONT><FONT face="Courier New" size="3"> $ </FONT><STRONG><FONT color="#008080" face="Courier New" size="3">1</FONT></STRONG></P><P><FONT color="#800080" face="Courier New" size="3">'Pooled Code File Updated 04/06/2'n</FONT><FONT face="Courier New" size="3"> $ </FONT><STRONG><FONT color="#008080" face="Courier New" size="3">1</FONT></STRONG><FONT face="Courier New" size="3"> ;</FONT></P><P>LABEL</P><P><FONT color="#800080" face="Courier New" size="3">'Pooled Code File Updated 04/06/2'n</FONT><FONT face="Courier New" size="3"> = </FONT><FONT color="#800080" face="Courier New" size="3">"Pooled Code File Updated 04/06/2017"</FONT><FONT face="Courier New" size="3"> ;</FONT></P><P>FORMAT</P><P><FONT face="Courier New" size="3">State </FONT><FONT color="#008080" face="Courier New" size="3">$CHAR2.</FONT></P><P><FONT color="#800080" face="Courier New" size="3">'NPA-NXX'n</FONT> <FONT color="#008080" face="Courier New" size="3">$CHAR7.</FONT></P><P><FONT face="Courier New" size="3">OCN </FONT><FONT color="#008080" face="Courier New" size="3">$CHAR4.</FONT></P><P><FONT face="Courier New" size="3">Company </FONT><FONT color="#008080" face="Courier New" size="3">$CHAR50.</FONT></P><P><FONT face="Courier New" size="3">RateCenter </FONT><FONT color="#008080" face="Courier New" size="3">$CHAR10.</FONT></P><P><FONT face="Courier New" size="3">EffectiveDate </FONT><FONT color="#008080" face="Courier New" size="3">MMDDYY10.</FONT></P><P><FONT face="Courier New" size="3">Use </FONT><FONT color="#008080" face="Courier New" size="3">$CHAR2.</FONT></P><P><FONT face="Courier New" size="3">AssignDate </FONT><FONT color="#008080" face="Courier New" size="3">MMDDYY10.</FONT></P><P><FONT color="#800080" face="Courier New" size="3">'Initial/Growth'n</FONT> <FONT color="#008080" face="Courier New" size="3">$CHAR1.</FONT></P><P><FONT color="#800080" face="Courier New" size="3">'Pooled Code File Updated 04/06/2'n</FONT> <FONT color="#008080" face="Courier New" size="3">$CHAR1.</FONT><FONT face="Courier New" size="3"> ;</FONT></P><P>INFORMAT</P><P><FONT face="Courier New" size="3">State </FONT><FONT color="#008080" face="Courier New" size="3">$CHAR2.</FONT></P><P><FONT color="#800080" face="Courier New" size="3">'NPA-NXX'n</FONT> <FONT color="#008080" face="Courier New" size="3">$CHAR7.</FONT></P><P><FONT face="Courier New" size="3">OCN </FONT><FONT color="#008080" face="Courier New" size="3">$CHAR4.</FONT></P><P><FONT face="Courier New" size="3">Company </FONT><FONT color="#008080" face="Courier New" size="3">$CHAR50.</FONT></P><P><FONT face="Courier New" size="3">RateCenter </FONT><FONT color="#008080" face="Courier New" size="3">$CHAR10.</FONT></P><P><FONT face="Courier New" size="3">EffectiveDate </FONT><FONT color="#008080" face="Courier New" size="3">MMDDYY10.</FONT></P><P><FONT face="Courier New" size="3">Use </FONT><FONT color="#008080" face="Courier New" size="3">$CHAR2.</FONT></P><P><FONT face="Courier New" size="3">AssignDate </FONT><FONT color="#008080" face="Courier New" size="3">MMDDYY10.</FONT></P><P><FONT color="#800080" face="Courier New" size="3">'Initial/Growth'n</FONT> <FONT color="#008080" face="Courier New" size="3">$CHAR1.</FONT></P><P><FONT color="#800080" face="Courier New" size="3">'Pooled Code File Updated 04/06/2'n</FONT> <FONT color="#008080" face="Courier New" size="3">$CHAR1.</FONT><FONT face="Courier New" size="3"> ;</FONT></P><P><FONT color="#0000ff" face="Courier New" size="3">INFILE</FONT><FONT face="Courier New" size="3"> allstate </FONT><FONT color="#0000ff" face="Courier New" size="3">MISSOVER</FONT> <FONT color="#0000ff" face="Courier New" size="3">DLM</FONT><FONT face="Courier New" size="3">=</FONT><FONT color="#800080" face="Courier New" size="3">' '</FONT> <FONT color="#0000ff" face="Courier New" size="3">DSD</FONT> <FONT color="#0000ff" face="Courier New" size="3">FIRSTOBS</FONT><FONT face="Courier New" size="3">=</FONT><STRONG><FONT color="#008080" face="Courier New" size="3">2</FONT></STRONG><FONT face="Courier New" size="3"> ;</FONT></P><P><FONT color="#0000ff" face="Courier New" size="3">INPUT</FONT></P><P><FONT face="Courier New" size="3">State : </FONT><FONT color="#008080" face="Courier New" size="3">$CHAR2.</FONT></P><P><FONT color="#800080" face="Courier New" size="3">'NPA-NXX'n</FONT><FONT face="Courier New" size="3"> : </FONT><FONT color="#008080" face="Courier New" size="3">$CHAR7.</FONT></P><P><FONT face="Courier New" size="3">OCN : </FONT><FONT color="#008080" face="Courier New" size="3">$CHAR4.</FONT></P><P><FONT face="Courier New" size="3">Company : </FONT><FONT color="#008080" face="Courier New" size="3">$CHAR50.</FONT></P><P><FONT face="Courier New" size="3">RateCenter : </FONT><FONT color="#008080" face="Courier New" size="3">$CHAR10.</FONT></P><P><FONT face="Courier New" size="3">EffectiveDate : ?? </FONT><FONT color="#008080" face="Courier New" size="3">MMDDYY10.</FONT></P><P><FONT face="Courier New" size="3">Use : </FONT><FONT color="#008080" face="Courier New" size="3">$CHAR2.</FONT></P><P><FONT face="Courier New" size="3">AssignDate : ?? </FONT><FONT color="#008080" face="Courier New" size="3">MMDDYY10.</FONT></P><P><FONT color="#800080" face="Courier New" size="3">'Initial/Growth'n</FONT><FONT face="Courier New" size="3"> : </FONT><FONT color="#008080" face="Courier New" size="3">$CHAR1.</FONT></P><P><FONT color="#800080" face="Courier New" size="3">'Pooled Code File Updated 04/06/2'n</FONT><FONT face="Courier New" size="3"> : </FONT><FONT color="#008080" face="Courier New" size="3">$CHAR1.</FONT><FONT face="Courier New" size="3"> ;</FONT></P><P>&nbsp;</P><P>&nbsp;</P><P><FONT color="#000080" face="Courier New" size="3"><STRONG>run</STRONG></FONT><FONT face="Courier New" size="3">;</FONT></P> Thu, 06 Apr 2017 17:14:16 GMT https://communities.sas.com/t5/SAS-Programming/Read-Zip-file-from-a-website/m-p/347842#M273352 MikeAAC 2017-04-06T17:14:16Z Re: Read Zip file from a website https://communities.sas.com/t5/SAS-Programming/Read-Zip-file-from-a-website/m-p/347855#M273353 <P>Include a call to proc http! Here is blog from&nbsp;<a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/53873">@Chris</a>&nbsp;describing the method:&nbsp;<A href="http://blogs.sas.com/content/sasdummy/2014/01/29/using-filename-zip/" target="_blank">http://blogs.sas.com/content/sasdummy/2014/01/29/using-filename-zip/</A></P> <P>&nbsp;</P> <P>Art, CEO, AnalystFinder.com</P> <P>&nbsp;</P> Thu, 06 Apr 2017 17:45:34 GMT https://communities.sas.com/t5/SAS-Programming/Read-Zip-file-from-a-website/m-p/347855#M273353 art297 2017-04-06T17:45:34Z Re: Read Zip file from a website https://communities.sas.com/t5/SAS-Programming/Read-Zip-file-from-a-website/m-p/347861#M273354 <P>It works.</P><P>Ty Art.</P> Thu, 06 Apr 2017 18:05:59 GMT https://communities.sas.com/t5/SAS-Programming/Read-Zip-file-from-a-website/m-p/347861#M273354 MikeAAC 2017-04-06T18:05:59Z