I want to create WANT dataset as mentioned below although if one of source dataset don't exist. I tried the code below but it is not working. In real life HAVE1 dataset exist for sure with some data but HAVE2 dataset will not exist all the time. HAVE1 and HAVE2 dataset will be in same structure.   So I want to dynamically write one code similar to the one mentioned below to create WANT dataset.   data have1; id=1; output; run; /*create dataset want even if have2 dataset don't exist*/ data want; set have1 have2; run; log:   26 data have1; 27 id=1; 28 output; 29 run; NOTE: Compression was disabled for data set WORK.HAVE1 because compression overhead would increase the size of the data set. NOTE: The data set WORK.HAVE1 has 1 observations and 1 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds 30 31 /*create dataset want even if have2 dataset don't exist*/ 32 33 data want; 34 set have1 have2; ERROR: File WORK.HAVE2.DATA does not exist. 35 run; ... View more

I've to test for number of observations in the WANT dataset as per the code (similar) below and I want to output the data to nobs_test dataset only if there is any observation in the WANT dataset. If there is no observation in the source dataset 'WANT' then the code should not create nobs_test dataset.   data nobs_test; set want; if nobs gt 0 then output; /*Need code to test for obs in WANT dataset*/ FLT_Id=&f_id.; run; ... View more

I've  a data as follows in one dataset. Here the mechanism which I want to perform is, CURRENT_ID should be available in RISK_CURVE dataset and INSURANCE_CON. In similar way, GROUP_ID should be available in INSURANCE_CON_GRP and INSURANCE_CON dataset and so on. Here the base dataset is INSURANCE_CON.   In case if there are some values which are not in base table (INSURANCE_CON) but in reference table (INSURANCE_CON_GRP, RISK_CURVE)  then I've to capture that record in the Output.   Checks TBL_NM CURRENT_ID should be available in RISK_CURVE INSURANCE_CON GROUP_ID should be in INSURANCE_CON_GRP INSURANCE_CON LOCK_ID should be available in RISK_CURVE INSURANCE_CON   Output which I'm looking for,   Fault_record_in_reference_table 1,M,Joseph,234 11,F,Nakma,236   Although this mechanism sounds like a look up, challenge which I have is writing the this validation  checks in macro as I've to insert this code in other macro code. Would be grateful if it can be accomplished with minimal code.         ... View more

Assume I've a variable (Var_Name) which has the data as follows. Values of this variable is actually the dataset name. I'd like to know how can I pass that value as a dataset name in SET statement to test for missing values? Datasets Customer, company and Employee are in same structure.   Var_Name Customer Company Employee   Operation which I want to  perform now is,   data output; set <read value from Var_Name variable>; /*like set customer then set company followed by set employee */ if missing (id) then output; run;     ... View more

In the below code, I want the macro variable REPORTINGDATE to resolve as 31MAR2007. So I would like to know what value to be passed as Input for the variable x.     data _null_; x=input(put(&reportingdate,$8.),yymmdd8.); format x date9.; call symput('REPORTINGDATE',x); run; ... View more