Hi Everyone, I have a code that runs every minutes. I want to add to that code a section (which contain quite a few data steps) that should be run every hour at 00:01 (hh:mm).  Look like this added part could be something a macro inside the big one. Can you please help me with that? Many thanks, HHC   %MACRO _BREAK() ; %DO %WHILE ( %sysevalf(%sysfunc(time())<'16:00:08't,boolean) ) ; /*------ADDED part that run every hour---------*/ /*My MAIN CODE*/ %*Sleep until 5 seconds after the start of the next minute ; %put %sysfunc(wakeup("%sysfunc(putn(%eval(%sysfunc(intnx(minute,"%sysfunc( time(), time )"t,1))+5),time.))"t)); %end ; %mend ;       ... View more

Hi Everyone,   I run proc setinit and look like I have this ---SAS/ACCESS Interface to PC Files (see below). My question is that with the licenses I have, is there any way I can use SAS to import an Excel or CSV file that is opened in my PC.   Thank you, HHC   I try the codes from this thread https://communities.sas.com/t5/SAS-Programming/The-EXCEL-Engine-cannot-be-found-despite-having-SAS-ACCESS/m-p/555718#M154674  I run this below code and received error : libname myRef PCFILES path='E:\Temp file\a.xlsx'; ERROR: Unable to locate pcfserver.exe. Please install PC Files Server. ERROR: Error in the LIBNAME statement.   119 proc setinit; 120 run; NOTE: PROCEDURE SETINIT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds Original site validation data Current version: 9.04.01M5P091317 Site name: '***'. Site number: 70210317. Expiration: 14NOV2023. Grace Period: 45 days (ending 29DEC2023). Warning Period: 46 days (ending 13FEB2024). System birthday: 02NOV2022. Operating System: WX64_WKS. Product expiration dates: ---Base SAS Software 14NOV2023 ---SAS/STAT 14NOV2023 ---SAS/GRAPH 14NOV2023 ---SAS/ETS 14NOV2023 ---SAS/FSP 14NOV2023 ---SAS/OR 14NOV2023 ---SAS/AF 14NOV2023 ---SAS/IML 14NOV2023 ---SAS/QC 14NOV2023 ---SAS/SHARE 14NOV2023 ---SAS/ASSIST 14NOV2023 ---SAS/CONNECT 14NOV2023 ---SAS/EIS 14NOV2023 ---SAS/GIS 14NOV2023 ---SAS/SHARE*NET 14NOV2023 ---SAS Enterprise Miner 14NOV2023 ---MDDB Server common products 14NOV2023 ---SAS Integration Technologies 14NOV2023 ---SAS/Secure 168-bit 14NOV2023 ---SAS/Secure Windows 14NOV2023 ---SAS Text Miner 14NOV2023 ---SAS/Genetics 14NOV2023 ---SAS Enterprise Guide 14NOV2023 ---SAS Bridge for ESRI 14NOV2023 ---OR OPT 14NOV2023 ---OR PRS 14NOV2023 ---OR IVS 14NOV2023 ---OR LSO 14NOV2023 ---SAS/ACCESS Interface to DB2 14NOV2023 ---SAS/ACCESS Interface to Oracle 14NOV2023 ---SAS/ACCESS Interface to SAP ASE 14NOV2023 ---SAS/ACCESS Interface to PC Files 14NOV2023 ---SAS/ACCESS Interface to ODBC 14NOV2023 ---SAS/ACCESS Interface to OLE DB 14NOV2023 ---SAS/ACCESS Interface to R/3 14NOV2023 ---SAS/ACCESS Interface to Teradata 14NOV2023 ---SAS/ACCESS Interface to Microsoft SQL Server 14NOV2023 ---SAS/ACCESS Interface to MySQL 14NOV2023 ---SAS Enterprise Miner for Desktop 14NOV2023 ---SAS/IML Studio 14NOV2023 ---SAS Workspace Server for Local Access 14NOV2023 ---SAS/ACCESS Interface to Netezza 14NOV2023 ---SAS/ACCESS Interface to Aster nCluster 14NOV2023 ---SAS/ACCESS Interface to Greenplum 14NOV2023 ---SAS/ACCESS Interface to SAP IQ 14NOV2023 ---SAS/ACCESS to Hadoop 14NOV2023 ---SAS/ACCESS to Vertica 14NOV2023 ---SAS/ACCESS to Postgres 14NOV2023 ---SAS/ACCESS to Impala 14NOV2023 ---SAS/ACCESS to Salesforce 14NOV2023 ---SAS/ACCESS to HAWQ 14NOV2023 ---SAS/ACCESS to Amazon Redshift 14NOV2023 ---High Performance Suite 14NOV2023 ---SAS Add-in for Microsoft Excel 14NOV2023 ---SAS/ACCESS to SAP HANA 14NOV2023 ---SAS/ACCESS Interface to the PI System 14NOV2023 ---prod 1304 14NOV2023 ---prod 1312 14NOV2023 ... View more

Hi Everyone, I have SAS9.4 (I think it is Base) and I would like to import an open file of either xlsx, csv or txt or any format that allow me to do so. Can you please help? Thanks, HHC     ... View more

Hi, I use the sashelp.stocks as the input file and I want to run regression of Close = Volume For a given day, say 27Feb2023, I want to run this regression on 30 rows including 27Feb2023. The output I want to have is date, stock, predicted value and residual value as in the code below. Can you please help? Thank you, HHC proc reg noprint data=sashelp.stocks outest=want_test; by stock; model close = volume; output out=want (keep = stock date predicted residual) p=predicted r=residual; run; quit;     ... View more

Hi Everyone, I thought it should be simple to use proc expand to get exponential moving average (EMA), however, look like I am missing something here. In the example of calculating EMA in the link below, I can't add the value of lookback day, say 50 day EMA. Can you please help to get the 50 day EMA? Thank you, HHC https://blogs.sas.com/content/iml/2016/01/27/moving-average-in-sas.html    title "Monthly IBM Stock Price"; proc sort data=sashelp.stocks(where=(STOCK='IBM') rename=(Date=t Close=y)) out=Series; by t; run; proc expand data=Series out=out method=none; id t; convert y = EWMA / transout=(ewma 0.3); run;       ... View more

Hi, I want to generate a column containing time from 8:00 to 16:00 step by 1 minute. So the data should look like: 8:00 8:01 8:02 ... 15:59 16:00 Can you please help? Thanks, HHC ... View more