topic Re: SAS zipcode database in New SAS User

SAS zipcode database

jsaldain33 — Wed, 18 Dec 2019 17:53:25 GMT

SAS provides .cpt files with zipcode county information http://support.sas.com/rnd/datavisualization/mapsonline/html/misc.html. How can I extract from these files a .csv or .txt file that has zipcode and county columns?

Re: SAS zipcode database

Kurt_Bremser — Wed, 18 Dec 2019 18:23:21 GMT

@jsaldain33 wrote:

SAS provides .cpt files with zipcode county information http://support.sas.com/rnd/datavisualization/mapsonline/html/misc.html. How can I extract from these files a .csv or .txt file that has zipcode and county columns?

You use proc cimport to import this transport file to a SAS dataset, and then a data step to export the data to the desired text format.

Re: SAS zipcode database

jsaldain33 — Fri, 20 Dec 2019 23:27:31 GMT

Thanks. I managed to do it:

libname sasfiles 'C:\Users\Joaquin\Desktop';
filename intrans 'C:\Users\Joaquin\Desktop\zipcode_q1_2005.cpt' ;
proc cimport infile=intrans library=sasfiles;
run;

proc export data=sasfiles.zipcode_q1_2005
    outfile='C:\Users\Joaquin\Desktop\zipcode_q1_2005.csv'
    dbms=csv
    replace;
run;

Any suggestions to execute this block of code for each file in a directory?