Hello, I'm trying to see if I can geocode an address file and get back Fips State, Fips County, Tract, Block, Place, MSA, CBSA, etc. The code below only returns Y, X, Block, Tract, M_ADDR, M_CITY, M_STATE, M_ZIP, M_OBS, _MATCHED_, _STATUS_, _NOTES_, _SCORE_ and then my columns, ID, RAW_ADDRESS, RAW_CITY, RAW_STATE, RAW_ZIP.  I'm not sure how to get the FIPS variables, Place, MSA, CBSA. proc geocode method = street addressvar = RAW_ADDR addresscityvar = RAW_CITY addresszipvar = RAW_ZIP addressstatevar = RAW_ST data = temp out = temp_out attribute_var = (BLOCK, TRACT) lookupstreet = geodata.USM ; run ; Thank you ... View more

Hello, I'm trying to create a report based off of the freq of multiple variables.  This is how I'm currently doing it. filename rptTemp "c:\temp\temp.txt" ; proc printto print=rptTemp new ; run ; title 'Frequency var1 from tempData' ; proc freq data = tempData ;     table var1 /nocol norow nopercent missing; run ; title 'Frequency var2 from tempData' ; proc freq data = tempData ;     table var2 /nocol norow nopercent missing; run ; title 'Frequency var3 from tempData' ; proc freq data = tempData ;     table var3 /nocol norow nopercent missing; run ; title; proc printto; run ; 1. Is there a better way to do this? 2. How can I add a blank row after each proc freq? 3. There are about 10 variables I need to do this for to see exactly what is contained in the dat Thank you ... View more

Hello, I'm importing a text file that has data that comes in as 020100 but I need to format it as 201.00.  So I need it to be a number and then have the 2 decimals. When I try and format the value to F7.2 it shows up 20100.0 and F8.2 shows up as 20100.00. filename temp "C:\temp\test.txt" ; data temp ;        ATTRIB         VAL  FORMAT=F8.2 ; infile temp ; input VAL 1-6 ; run ; Thank you ... View more

Hello, I have a text file I have to read in and in the past it's all been one row per record.  This time I have a multi-line per record and I'm not sure the best way to approach importing the text file into a sas table. Example Data ID:FNAME:MNAME:LNAME:CITY:STATE:ZIP:PHONE:PREV_CITY:PREV_STATE:PREV_ZIP:PREV_PHONE 1:Homer:Jay:Simpson :Springfield:::(222)-333-4444 :Langley Falls:VA:88888:(555)-666-7777 2:Bill:Phil:Williams :New York:NY::(123)-456-7890 ::::(987)-000-1212 How can I change my previous code to bring in the multiple lines? filename temp "c:\temp\temp.txt" ; data temp ;        infile temp dlm=':', mu dsd lrecl=260 missover pad firstobs = 2 ;        length                 ID            8         FNAME        $20         MNAME         $20         LNAME        $30                CITY        $40         STATE       $2         ZIP            $5         PHONE       $15         PREV_CITY    $40         PREV_STATE  $2         PREV_ZIP    $5         PREV_PHONE  $15     ;     input                   ID                  FNAME        $            MNAME         $         LNAME        $         CITY        $         STATE       $         ZIP            $         PHONE       $         PREV_CITY    $         PREV_STATE  $         PREV_ZIP    $         PREV_PHONE  $     ; run ; Thank you ... View more

Hello, I have a situation where I have a date value within a character field.  Ex. 2015-01-20 I have substring that porition out of the text variable but I'm not sure how to convert it to a numeric field with the correct date format so I can select the rows that have a date larger then the 01/19/2015.  In the code below I'm trying to take out the date parts and create a new variable and convert it to numeric but I keep getting "Invalid numeric data, dates='02-01-2015'"  This is listed many times. data temp ;        set temp_ ;     pos = find(text, '[2015') ;     if pos > 0 then do ;         dt = substr(substr(text, pos, 11),2) ;            yr=substr(dt,1,4) ;         mon=substr(dt,6,2) ;         day=substr(dt,9,2) ;         dates=catx('-',mon,day,yr) ;         x = input(datepart(dates), date11.) ;                output ;     end ;     run ; Thank you for any help you can give me. ... View more