I have the following dataset; may I know how to get the desired output? Anyone can help? Thanks. (rate to multiply for similar case no)   data test; input case $ rate; datalines; 110 0.5 110 0.4 111 0.8 112 0.6 112 1.2 ; run;   Desired output   Case  Rate 110    0.2 111    0.8 112    0.72   ... View more

I got this error message "Subquery evaluated to more than one row" in the below codes.  Anyone can help? Thanks. data d1; input id $ name $; datalines; 110 Miller 111 Bush 112 Elliot 113 Ryan ; run;   data d2; Format DATE1 DATE9.; input id $ date1 DATE9.; datalines; 110 01JAN2018 111 01FEB2018 112 01MAR2018 114 01APR2018 ; run; data d3; Format DATE2 DATE9.; input id $ date2 DATE9.; datalines; 110 01JAN2017 111 01FEB2019 112 01MAR2016 113 01APR2019 ; run;   PROC SQL; CREATE TABLE WANT AS SELECT DISTINCT * FROM D2 WHERE ID IN (SELECT ID FROM D1) AND DATE1 < (SELECT DATE2 FROM D3); QUIT; ... View more

data _null_; call symput('period',put(intnx('month',today(),-3),yymmn6.)); run;   May I know how to write the 'period' (201902) into a specific cell in Excel? Let say to cell E3.   Thanks.     ... View more

I would like to do the following: libname concatenation.   libname testyear ("D:\test\1998","D:\test\1999","D:\test\2000","D:\test\2001");   Is there any better to do this as the year will increase? Please advice.  Thanks.     ... View more

When i run the program, period_1 appear in the date1 dataset, may i know how to output period_2 to period_24 into the date1 dataset? Thanks. data date1; date1 = intnx('month',&today,-1,'end'); period_1 = substr(put(date1, yymmddn8.),3,4); do i=2 to 24; call symput(cats("Period_",i),substr(put(intnx('month',date1,-(i-1),'end'),yymmddn8.),3,4)); end; run; ... View more

In the below code, I can get 2018 for variable A and 2019 for variable B.  May I know how to get 2018/2019 for variable C? Thanks.   %LET RUNDATE = TODAY();   data  _null_; call symput("A",put(intnx('YEAR',&RUNDATE,-1),YEAR4.)); call symput("B",put(intnx('YEAR',&RUNDATE,0),YEAR4.)); run;   %PUT A = &A; %PUT B = &B; ... View more

May I know what wrong with the macro below as I can't get the T1 dataset? Thanks. %LET PERIODE=01sep2018; %LET TODATE ="10sep2018"D; DATA _NULL_; IF INTCK('DAY',"&PERIODE"D,&TODATE.) ge 8 THEN call symputx("T", "T1"); ELSE call symputx("T", "T2"); RUN; %PUT T=&T;   %macro check(dsn); %if T = "&dsn" %then %do; DATA T1; SET SASHELP.CARS; IF MAKE EQ 'BMW'; RUN; %end; %else %do; DATA T2; SET SASHELP.CARS; RUN; %end; %mend check; %check(T1); ... View more

May I know how to check if 'class' is an audit dataset, and not 'cars'? Is there any %sysfunc to check? Thanks.   data class; set sashelp.class; run;   data cars; set sashelp.cars; run;   proc datasets library=work nolist nodetails; audit class; initiate; quit; ... View more

Is there a way to delete record in 'master' table if the record is not available in 'transact' table? For below code, id 01 should be deleted as 01 is not available in transact table.   i tried this but not work. if _iorc_ eq 1 then do; _reason_change_ = 'Remove'; remove; end;   /**program start**/ data master; input id $ name $ gender $ weight; datalines; 01 Perry M 165 02 Miller M 145 03 Davis F 127 ; run;   data transact; input id $ name $ gender $ weight; datalines; 02 Miller . 160 03 Bush . 157 05 Elliot F 125 02 . M 170 ; run;   proc sort data=master; BY id; RUN; proc sort data=transact; BY id; RUN;   proc datasets lib=work; audit master; initiate; user_var _reason_change_ $30; quit;   data master; modify master transact; by id; if _iorc_ eq 0 then do; _reason_change_ = 'Update'; replace; end; else if _iorc_ eq 1230013 then do; _reason_change_ = 'new'; output; end; else do; errmsg=IORCMSG(); putlog 'NOTE: ' errmsg= _iorc_=; end; run;   data auditchk; set Master(type=audit); run; ... View more