Hi Everyone, For each date, I lookback 3 days and find the max value using this proc expand below. Now I want to find the day that rolling max occurs.  So I use the loop to get it done. However, it is quite slow. I wonder if there is better option. Thank you, HHC   data have; input date id value ; datalines; 1 1 1 2 1 9 3 1 0 4 1 7 5 1 5 1 2 100 2 2 0 3 2 -2 4 2 2 5 2 0 6 2 1 ;run; data have; set have; drop lid; lid=lag(id); if lid^=id then change_id=1; run; proc sort data=have; by id descending date;run; data want; set have; drop id_1 date1 value1 count i change_id; count=0; i+1; max_value=value; max_date=date; do j =i to nobs until (change_id=1); set have(rename=(id=id_1 date=date1 value=value1)) point=j nobs=nobs; if count=3 then leave; else if value1>max_value then do; max_value=value1; max_date=date1; end; count=count+1; end; run; ... View more

Hi Everyone, I have panel data with date, id and values. For a give day and id, I want to look back 3 days (so including current day, there are 4 days in total) and find the 1st, 2nd, 3rd largest. It is like moving largest(n). So for day 6 and id = 1, the desired result should be: 9, 4 , 2 So for day 5 and id = 1, the desired result should be: 12, 9 , 4 Can you please help? Thanks, HHC (My work requires multiple lookback windows (say, 20, 40 days) and apply to multiple columns. For that, I guess a macro can be fine and I think I can handle that) data have; input day id v1 v2 v3 v4; datalines; 6 1 2 15 3 1 5 1 4 50 6 9 4 1 1 0 61 0 3 1 9 0 60 5 2 1 12 3 1 2 1 1 21 2 0 2 6 2 2 5 2 3 5 3 12 15 6 1 4 3 0 1 1 8 3 3 0 4 4 8 2 3 12 6 56 8 1 3 25 5 65 8 ;run;   ... View more

Hi Everyone, I have a timeseries and would like to run a polynomial regression of value on time and save the estimated value and error to a new file. Can you please help? Thank you, HHC /*THIS ONE WORK*/ proc datasets lib=work kill noprint;run;DM "log; clear; ";ods html close;ods html; data test; infile datalines missover; input month Orders; yearMonth = mod(month,12); actual= not missing(orders); datalines; 1 26156 2 32396 3 27415 4 24129 5 30350 6 21992 7 24705 8 36434 9 28858 10 37353 11 43137 12 52119 13 42119 14 42119 15 62119 16 72119 17 42119 18 62119 ; proc sgplot data=test; reg x =month y=orders /degree=10 clm; title 'sgplot'; run; proc glm data=test; model orders = month month*month month*month*month month*month*month*month month*month*month*month*month month*month*month*month*month*month month*month*month*month*month*month*month month*month*month*month*month*month*month*month month*month*month*month*month*month*month*month*month month*month*month*month*month*month*month*month*month*month / PREDICTED E; output out=glm p=pred r=residual; ; title 'GML regression'; run; ... View more

Hi Everyone, I have a csv file as below, and can you please help me to import it. I always have hard time dealing with date and time. Thank you so much. HHC   price,product_code,date,time 100.0,AA,2022-07-27,07:00:00 450.0,AAXGH,2022-07-27,07:30:00 ... View more

Hi Everyone, I would like SAS to return previous working day. Can you please help? Thanks, HHC ... View more

Hi Everyone, I have SAS installed in my Windows PC. I use Jupyter notebook to download data and once the download is completed, I want to run a SAS program that I already written to analyze the data and export report to Excel. I am new to all this and any help is very much appreciated. HHC ... View more

Hi Everyone, I want to import a csv file with 3 columns of the following format: Name, price, time(yyyy-mm-dd hh:mm:sss) and then extract date and time. One of the problem is price sometime has 'N/A' so I have to use guessingrows in my code. I wonder if there is anything else can be used since guessingrows might take too much time if I want to guessing=Max. Thank you, HHC   Ab,117.9,480751.0,2022-07-19 12:48:00.891313 AX,726.2398,16005050.0,2022-07-19 12:48:00.891313 MI,714.075,N/A,2022-07-19 12:48:00.891313 AXxd,726.2398,16005050.0,2022-07-19 12:48:00.891313 proc import datafile='\Downloads\333_12_44.csv' out=have replace; guessingrows=3000 ; run; ... View more

Hi Everyone, When I import a CSV file into SAS, the column datetime having format mm/dd/yyyy hh:mm:ss is imported and in SAS it has: Length 8 Format DATETIME16. Informat ANYDTDTM40.   I use the below code to extract year month date and SAS give errors.   data intra; set intra; year=year(datetime); month=month(datetime); hour=hour(datetime); minute=minute(datetime); second=second(datetime); run; NOTE: Invalid argument to function YEAR(1973854021.9) at line 218 column 6. NOTE: Invalid argument to function MONTH(1973854021.9) at line 219 column 7. _0=A _1=117.871 _2=479962 datetime=19JUL22:12:47:02 year=. month=. hour=12 minute=47 second=1.8895449638 date=. _ERROR_=1 _N_=1   Can you please help me with that? Thanks HHC ... View more