Hi, This is an URGENT REQUEST as my project is due next week! I am a new SAS user and I am trying to build my Final Exam project but not sure how to proceed. I am a long-time Excel user and have been able to create the real-time currency exchange rate table on MS Excel and used the PROC IMPORT function to import the Excel sheet on the SAS environment. But I am getting a static table instead of the real-time one even after refreshing the output environment. Here are the steps I followed- Step 1- Created the real-time currency exchange rate table on MS Excel using the freely available Currency exchange rate data set on the following site:- https://www.x-rates.com/ Step 2- I uploaded the Excel sheet into my SAS folder Step 3- After that, I use the PROC IMPORT function to import the real-time dataset from the Excel sheet to the SAS environment. But the data output shows a static data table even after refreshing the environment. Not sure how to proceed please help. Code used- FILENAME MONEY "/home/u62057845/SAS Class Fall 2022/u62057845/Final project/currency.xlsx"; LIBNAME MONEY PROC IMPORT OUT=money.currency DATAFILE="/home/u62057845/SAS Class Fall 2022/u62057845/Final project/currency.xlsx" DBMS=XLSX REPLACE; GETNAMES=NO; RUN; PROC PRINT DATA=money.currency; TITLE "Currency exchange rate from USD to other global currencies"; RUN; ----------------------- I have attached the Excel sheet named currency with the real-time currency exchange rate data set and the code above. Please edit the file path accordingly. ------------------------ Q2) Is there a way I can pull data sets from a website directly onto the SAS environment, instead of having to upload it into an Excel/CSV/text file first and then upload it? I know I can do it on R but not sure if SAS allows that. Please help me!! Thanks in advance.
... View more