I am using proc geocode with street method as follows   proc geocode method = street addressvar = ADDR addresscityvar = CITY addressstatevar = ST addresszipvar = ZIP data = address out = addr_out lookupstreet = geo.USM ; run ;   What values it gives if zip code is missing in the input data? I am getting null values.     ... View more

Hello,     I am creating a CSV file using a big SAS dataset. I need to zip the CSV file in multiple smaller zip file. Can it be done using filename statement? I need something similar to zip -s 1000m SPLIT_FILES small_FILE.ZIP   Thanks.   ... View more

Hello,   I am zipping the large text file using filename and ODS package. When I am trying to unzip it using unzip command in putty, getting following error   missing 7329002330 bytes in zipfile    attempt to seek before beginning of zipfile   (please check that you have transferred or created the zipfile in the   appropriate BINARY mode and that you have compiled UnZip properly)   I don't have winzip. This file is transferred to the client and they don't use sas   Following code is used to zip  the file filename newfl "&outpath./abc.zip"; data _null_; if (fexist('newfl')) then rc = fdelete('newfl'); run; filename newfl clear; filename nwzip "&outpath./abc.txt"; ods package(newzip) open nopf; ods package(newzip) add file=nwzip ; ods package(newzip) publish archive properties( archive_name="abc.zip" archive_path="&outpath." ); ods package(newzip) close; ... View more

I have a data with zip code and acc_nbr... when I sorted the data by zip code on different days, got same acct_nbr on different positions in the output data. Is it possible? ... View more