Hello,   I have a list of locations (both US and Mexico locations) that I would like to create a flag if they are within 100 miles from the US Mexico border.  Question 1: Having the addresses of these locations, is there a way to pull all the latitude longitude from my list of locations from Google Maps into SAS?   Question 2: From here, how would I obtain all the longitude latitude locations for the US Mexico border? Or is there a more efficient way of doing this than grabbing the longitudes latitudes of the border?   I would greatly appreciate any help!   Melanie ... View more

I’m trying to figure out how I can link or import the table called “inbox_linked” in the below MS Access database into SAS. I’m trying to control the database using SAS so I don’t have to open it. I think the only function I need is the “refresh” on the linked table. My purpose is trying to use MS Access to pull emails from Outlook and save in tables that I would then use SAS to process acknowledgments. C:\outlook project\email_content.accdb I can pull it into SAS without a problem. I’m just not sure what to do from here. %let dbname = C:\outlook project\email_content.accdb; libname my_data "C:\outlook project\"; proc import out=work.Inbox    datatable="Inbox test"    dbms=ACCESS   replace;    database="&dbname";    run;     I’ve only been programming for a year now, so any help or advice would be greatly appreciated. ... View more

Hello! I’m still pretty new to SAS. Please bear with me while I ask my question. I created a directory with my libname statement that creates a daily folder named after the date it was created. If I wanted to reference those tables in the last folder created in another program how would I do that? Currently I run the programs on separate days and I’m having to manually change the libname statement to reference the last date ran. I would like to automate it if at all possible. UDIR= My user directory Rundate = 06AUG Program 1 that creates the directory:      options dlcreatedir;      LIBNAME X "&UDIR\SAS TABLES\201408\&RUNDATE"; Program 2:                 What I would like:      LIBNAME X "&UDIR\SAS TABLES\201408\&RUNDATE"                 What I currently have to do:      LIBNAME X "&UDIR\SAS TABLES\201408\05AUG" Thanks! ... View more

Hello! I’m still pretty new to SAS. I was wondering how would I change the libname statement to “read only” after it creates the tables in a program and prevent it from overwriting existing tables if I run the program again?  Also, if the program gets ran again, I would like to prevent it from overwriting existing tables.  I tried running the libname without “ACCESS=READONLY” in the beginning of the program and including the libname again with “ACCESS=READONLY” at the end of the program. It  doesn’t prevent my tables from getting overwritten if the program gets ran again. LIBNAME X "&UDIR\SAS TABLES\&MP1DB_YYMMN6"; My Tables in Program LIBNAME X "&UDIR\SAS TABLES\&MP1DB_YYMMN6" ACCESS=READONLY; Thanks so much! ... View more

Hello! I started this new job in the middle of February and this is my first time using SAS. 'm trying to create macro dates in different formats for a program that we run monthly at our company. This is what I've come up with so far. It runs fine, but I'm unsure if this is the most efficient way to create the dates and with the different formats. Any advice would be greatly appreciated! Thank you!! DATA Dates1;        Rundate = INTNX('DAY', TODAY(), 0, 'B');  /* Today */        MC = INTNX('MONTH', rundate, 0, 'B');  /* Month Current*/        MP = INTNX('MONTH', rundate, -1, 'B'); /* Month Past*/ /* FORMAT DATE9 */        CALL SYMPUT ('MC_DATE9',  CATS(PUT(MC,  DATE9.)));        CALL SYMPUT ('MP_DATE9',  CATS(PUT(MP,  DATE9.))); /* FORMAT DATE11 */        CALL SYMPUT ('MC_DATE11',  CATS(PUT(MC,  DATE11.)));        CALL SYMPUT ('MP_DATE11',  CATS(PUT(MP,  DATE11.))); /* FORMAT YYMMN6 */        CALL SYMPUT ('MC_YYMMN6',  CATS(PUT(MC,  YYMMN6.)));        CALL SYMPUT ('MP_YYMMN6',  CATS(PUT(MP,  YYMMN6.))); /* FORMAT QOUTED DATE9 */        CALL SYMPUT ('MC_QDATE9',  CATS("'",PUT(MC,  DATE9.),"'"));        CALL SYMPUT ('MP_QDATE9',  CATS("'",PUT(MP,  DATE9.),"'")); /* FORMAT QOUTED DATE11 */        CALL SYMPUT ('MC_QDATE11',  CATS("'",PUT(MC,  DATE11.),"'"));        CALL SYMPUT ('MP_QDATE11',  CATS("'",PUT(MP,  DATE11.),"'")); /* FORMAT QOUTED YYMMN6 */        CALL SYMPUT ('MC_QYYMMN6',  CATS("'",PUT(MC,  YYMMN6.),"'"));        CALL SYMPUT ('MP_QYYMMN6',  CATS("'",PUT(MP,  YYMMN6.),"'"));               put MC     = DATE11.;   /* Month Current  */               put MP     = DATE11.;   /* Month Past 1 Date Beginning * RUN; ... View more