Hello,   I have a dataset with the following three variables:  branch_address, X, Y   X and Y refer to the coordinates for a company's branch. I want to convert the coordinates to census tracts. I have already downloaded the lookup files from SAS (USM, USP, and USS) and have managed to convert the address to census tracts. However, some addresses have misspelled words and cannot be matched. Using coordinates to find the tract seems more appropriate. Is there a way I can do this in SAS? The code I used to match branch address to census tract is below. Is there a way I can modify it using coordinates from the input file? For the record, the three lookup files SAS I downloaded from here (https://support.sas.com/rnd/datavisualization/mapsonline/html/geocode.html)   Thanks a bunch in advance!   CODE:   proc geocode method=street  lookupstreet=lookup.usm  lookupcity=sashelp.zipcode  data=input_data addressvar=address  attributevar=(tract, block)  out=output_data;  run; ... View more

Hi all,    I am trying to import into SAS a large file in Stata 13 format (12gb, 29 million observations) using proc import. You can see my code and version of SAS at the end. When I run the code I get the following error:    ERROR: Invalid Operation. ERROR: Termination due to Floating Point Exception   I would appreciate any help finding a way around the problem (or finding the cause of the problem). Thanks a bunch.   CODE: proc import datafile= "path\filename.dta" out= lib.filename_new dbms=dta  replace; run;   SAS Version: SAS 9.4TS Level 1M3, on X64_PRO platform ... View more

Hi all,   I have a dataset in SAS (9.4) with a variable that reads with weird characters such as ÁÂÄÇÑÁ, the source language is Greek. When I change the font to "Greek" (right click on column, column attributes, fonts, data font, Script=Greek)  SAS reads the column in Greek language, which is great. However, the cell the values of the variable still contain weird names ÁÂÄÇÑÁ (I see this simply by clicking on a cell). As a result,  when I export the dataset in a txt file, the values still appear with the weird font. Is there a way to export the file in txt or csv or anything else that will use the Greek letters? No other source online can read these characters (ÁÂÄÇÑÁ) other than SAS, so since SAS can read Greek, there has to be a way to export it in Greek, right?    I would really appreciate your help or any advice. Many thanks in advance.      ... View more