Wanted to check if you tested by code on this data ... View more

Did you test the code on the added data lines. you need not use the have variable. ... View more

data have; infile cards truncover; input ID $ DATE_OF_VALUE :ddmmyy10. VALUE HAVE; format DATE_OF_VALUE date9.; cards; 109999999 05/12/2017 42376 1 109999999 05/12/2017 42376 2 109999999 13/12/2017 42521 1 109999999 13/12/2017 42521 2 109999999 19/03/2018 43395 1 109999999 19/03/2018 43395 2 109999999 19/03/2018 43395 3 109999999 19/03/2018 43395 4 109999999 04/06/2018 43953 1 109999999 04/06/2018 43953 2 109999999 17/09/2018 44899 1 109999999 17/09/2018 44899 2 ; proc sort data=have; by id descending DATE_OF_VALUE have; run; data want; set have; by id descending DATE_OF_VALUE have; if first.DATE_OF_VALUE then _want+1; if first.DATE_OF_VALUE and _want ne . then want=_want; drop _want; run; proc sort data=want; by id DATE_OF_VALUE ; run; ... View more

Please run the sas code in the linux environment and a log file will be generated with the same name as that of the sas file name except that the file extension would be different. ... View more

ok then you can alternatively try to create a dataset with all the variables and use that in this code as below so that you could avoid the use of the %let This is an untested code, so you need to test and let me know   data vars; input vars$10.; cards; Bookvalue Earnings Dividends ; %macro test; Data _null_; set vars; call execute("data want;SET have;by permno;%do i = 1 %to 12;If fyr=&i. then "||vars||"=lag%evalf(&i.+3)("||strip(vars)||");%end;RUN;"); %mend; %test ... View more

This is an untested code which could be tried   %let _var=bookvalue; %macro test; Data want; SET have; by permno; %do i = 1 %to 12; If fyr=&i. then &_var=lag%evalf(&i.+3)(&_var); %end; RUN; %mend; %test ... View more

Could try the x command as below   %macro all_codes; data _null_; x "sas &QCPROG.all_codes.sas" ; x "sas &QCPROG.qc_SDTM_ex.sas"; x "sas &QCPROG.qc_SDTM_ec.sas" ; x "sas &QCPROG.qc_SDTM_ds.sas" ; run; %mend deal_codes; %deal_codes; ... View more

for creating the dataset in proc sql try the below code   data have; input REGION $ SI_PRI PRI Return_rate; cards; ATLANTIC 3570 3954 0.903 HQ 10991 12165 0.903 ONTARIO 10301 11830 0.871 PACIFIC 4232 4768 0.888 PRAIRIES 5279 6297 0.838 QUEBEC 4399 4950 0.889 ; proc sql; create table want as select 'Total' as region , sum(SI_PRI) as SI_PRI, sum(PRI) as PRI, sum(Return_rate) from have union select * from have; quit; ... View more

data have; input date :ddmmyy10. time : time8.; maindate=dhms(date,hour(time),minute(time),second(time)); format date date9. time time8. maindate datetime18.; cards; 11-10-2018 08:35:25 11-10-2018 08:40:04 11-10-2018 08:45:27 ; data have2; input Start: datetime16. End : datetime16.; format start datetime18. end datetime18.; cards; 11OCT18:08:31:40 11OCT18:08:32:40 11OCT18:08:32:40 11OCT18:08:33:40 11OCT18:08:33:40 11OCT18:08:34:40 ; proc sql; create table want as select a.maindate, b.start, b.end from have as a left join have2 as b on b.start<=a.maindate<=b.end; quit; ... View more

I am learning from all the legends in this forum including you. I like @novinosrin coding. ... View more