Hi Everyone,   I have an issue with the result produced by the below loop code. Basically, when body_50 =1 bar[i], then look forward when condition: new row's low[j] < low[i] + add_level_1[i] then mark: 1 - entry_time = time[j] 2 - entry_price =ceil(low[i] * 100) / 100+ add_level_1[i]   As shown in the picture attached, on the row 9:27, body_1 =1 with low[i] + add_level_1[i] = 231.13 and SAS starts look forward. BUT it pick row 9:30 where low is 131.50 which is bigger than 231.13. It means the condition is Not met and somehow SAS still pick that row.   Any help is very much appreciated.   Thanks, HHC     proc sort data=ss; by tic date clock_time;run; data ss1; set ss nobs=nobs; drop i j_: out ; format entry_time bigbar time9.; i+1; out=0; by tic; if body_50=1 then do; do j=i+1 to nobs until (out=1); set ss (keep=tic date clock_time low high rename = (tic=J_tic date=J_date clock_time=J_clock_time low=J_low high=J_high) ) point=j; low_plus_add_level_1=low+add_level_1 ; gap=(J_clock_time - clock_time) / 60; if date^=J_date or tic^=J_tic or J_clock_time>'15:30't then do; out=1; leave; end; else if gap<20 and J_low<=low+add_level_1 then do; entry_time=J_clock_time; entry_price=ceil(low * 100) / 100+ add_level_1; bigbar=clock_time; out=1; leave; end; else if gap<60 and J_low<=low+add_level_3 then do; entry_time=J_clock_time; entry_price=ceil(low * 100) / 100+ add_level_3; bigbar=clock_time; out=1; leave; end; else if gap<120 and J_low<=low+add_level_4 then do; entry_time=J_clock_time; entry_price=ceil(low * 100) / 100+ add_level_4; bigbar=clock_time; out=1; leave; end; else if gap<180 and J_low<=low+add_level_5 then do; entry_time=J_clock_time; entry_price=ceil(low * 100) / 100+ add_level_5; bigbar=clock_time; out=1; leave; end; else if gap>=180 and J_low<= low +add_level_6 then do; entry_time=J_clock_time; entry_price=ceil(low * 100) / 100+ add_level_6; bigbar=clock_time; out=1; leave; end; end; end; run;       ... View more

Hi Everyone, So I have a data with ID, date (not continuous) and value. For each row, I create a look back, which is 4 date before. I want to find the max value within that 4 date (excluding current date) My code below gives me the result but I need to run a sort nodupkey. Can you please help me fix it? Thanks, HHC   data have; input id date value; datalines; 1 1 3 1 4 7 1 15 3 1 25 20 1 26 8 1 27 15 1 28 5 1 29 5 1 30 5 1 31 6 ; run; data have; set have; lookback_date=date - 4; run; proc sql; create table want as select a.*, max(b.value) as max from have as a left join have as b on a.id=b.id and a.lookback_date<=b.date and a.date>b.date group by a.id, a.date; quit; proc sort data =want out=want nodupkey; by id date; run;   ... View more

Hi, I got new PC and I install SAS9.4 in my C: drive (C:\Program Files\SASHome\SASFoundation\9.4). I copied my old document from my old PC to the new PC in folder E:\backup as below and in this folder, turns out this back up also has "My SAS Files". Now when run my SAS, it always point to this folder with the below error. How can I fix it? Thanks, HHC   ERROR: Windows error code: 362 in hc_normal_read_uhb for E:\backup\Documents\My SAS Files\9.4\profile.sas7bcat, The cloud file provider is not running. NOTE: Unable to open SASUSER.PROFILE. WORK.PROFILE will be opened instead ... View more

Hi Everyone, I need to import a sheet of an Excel file (xlsx) into SAS using data step (infile rather than import). Also, 1 column is date in the format Feb-25-2019 and I don't know how to read it correctly. Can you please help? Many thanks, HHC ... View more

Hi Everyone, I run the below code to get weight schedule.  The problem is that when I want to get (sum of element)=1, SAS do not return row value such as factor1=0, factor2=0 and factor3=1. I am not sure if it is my SAS issue or else, thus I keep the count in each part so you can can check.  Can you please help to review? Thanks, HHC data have; do factor1 = 0 to 1 by 0.1; do factor2 = 0 to 1 by 0.1; do factor3 = 0 to 1 by 0.1; output; end; end; end; run; /*The data set WORK.HAVE has 1331 observations and 3 variables*/ data weight_schedule; set have; if factor1 + factor2 + factor3 = 1; run; /*The data set WORK.WEIGHT_SCHEDULE has 53 observations*/ /********this return CORRECT count*******/ data CORRECT_COUNT; set have; if 0.99<factor1 + factor2 + factor3<1.01; run; /* The data set WORK.W has 66 observations*/ ... View more

Hi Everyone, I have 2 datasets: 1- specification contain 4 variable name (v1-v4) and it associated weight (weight1-weight4) 2- timeseries contain value of each variable name and its value overtime. What I want is to take 1 row in specification file and multiply with all rows in timeseries. So for the first row in specification, I will create a new dataset from timeseries where I do: if name ='a' then value=value*0; else if name = 'b' then value=value*0.1; else if name = 'c' then value=value*0.1; else if name = 'd' then value=value*0.8; and keep only those with name a b c d. (0, 0.1, 0.1,0.8 is the weight taken from specification file) I will perform further analysis with this new dataset. (This explanation of 1 row is intuition. However, if you can help to create a file that contain all multiplication is great)   Can you please help? Many thanks, HHC   data specification; input var1 $ var2 $ var3 $ var4 $ weight1 weight2 weight3 weight4 ; datalines; a b c d 0 0.1 0.1 0.8 a b v c 0.7 0.1 0.1 0.1 ;run; data timeseries; input name $ value; datalines; a 1 a 1.2 a 1.3 b 2 b 2.1 b 2.2 c 3 c 3.1 c 3.2 c 3.3 d 4.1 d 4.2 d 4.3 v 5.1 v 5.2 v 5.3 ;run; ... View more