In the the following code, I would like to write a data to the dataset 'oper_flt' only if there is a Observation.   proc sql; create table temp as select * from &table_name where &where ; run; data oper_flt; set temp; /*Need a condition to check for Observation and insert a data only if there is a Observation otherwise do not insert any data*/ run; ... View more

Am I doing something wrong here? How to get rid of the error?   options MINOPERATOR; %macro validation; %if %sysfunc(exist(IFPART.BALANCE_SEGMENT) %then; %do; %if ACCOUNT_PERIOD is . % then %do; data MVP3; ERR_MSG_TXT='ACCOUNT_PERIOD cannot be missing'; FLT_Id=1; FLT_REC_ID=1; FLT_REC_TXT='faulty conctenated Business key values' run; %end; %else %do; data _null_; %put "ACCOUNT_PERIOD is not missing"; run; %end; %mend; %validation; ERROR:   30 %do; ERROR: Macro keyword DO appears as text. ERROR: A dummy macro will be compiled. 31 %if ACCOUNT_PERIOD is . % then ERROR: Macro keyword IF appears as text. 32 %do; 33 data MVP3; 34 ERR_MSG_TXT='ACCOUNT_PERIOD cannot be missing'; 35 FLT_Id=1; 36 FLT_REC_ID=1; 37 FLT_REC_TXT='faulty conctenated Business key values' 38 run; 39 %end; ERROR: Macro keyword END appears as text. 40 %else ERROR: There is no matching %IF statement for the %ELSE. 41 %do; ERROR: Macro keyword DO appears as text. 42 data _null_; 43 %put "ACCOUNT_PERIOD is not missing"; ERROR: Macro keyword PUT appears as text. 44 run; 45 %end; 2 ERROR: Macro keyword END appears as text. 46 47 %mend; ERROR: Macro keyword MEND appears as text. 48 49 %validation;     ... View more

I've a data as follows from one dataset.   COL_NM operant value ACCOUNT_PERIOD_CLOSING_BAL_AMT ne . ACCOUNT_PERIOD_END_DT ne . REPORTING_METHOD_CD eq 'TAX'   Now I need to apply one condition as below in few programs by reading the above variables so that I no need to write the condition manually.   where ACCOUNT_PERIOD_CLOSING_BAL_AMT ne . or ACCOUNT_PERIOD_END_DT ne . or REPORTING_METHOD_CD eq 'TAX' Could you please help me acheive this task? ... View more