Hi @David_Billa ,   Maybe you can try this :   Hope this help   proc sql; create table temp as select * from &table_name where &where; quit; /* -> The macrovariable sqlobs is automatically created and contains the number of observations */ %if &sqlobs > 0 %then %do; /* Test if there are observations in the dataset and process the following data step conditionally to the result */ data oper_flt; set temp; run; %end; ... View more

You can try also this   data want; set have; length important_day $3; important_day="No"; array day(10) $; do i=1 to dim(day); if day(i)= "f402" then do; important_day="Yes"; /* When "f402" is found, change the flag variable to "Yes" */ leave; /* No need to continue checking because "f402" is found */ end; end; run; ... View more

Hi @Dhana18 ,   I believe you want to create a report rather than a SAS dataset as you want to display Gender and MSM categories by Alertype as columns. May be you could try Proc Tabulate as shown below. In the Tables statement, you can specify the structure of your report to display statistics: (rows), (columns) * (statistics eg: n to show frequency) proc tabulate data=have out=want; class AlertType Gender MSM Gender_Sp Race Ethnicity Num_partners Age GCHX SXPharyngeal Discharge Dysuria SXAbdomen; tables (Gender_Sp Race Ethnicity Num_partners Age GCHX SXPharyngeal Discharge Dysuria SXAbdomen),(AlertType *(Gender MSM))*n; run; NB: it seems that you have some data management to perform. For example, Alerttype contains "Alert" and "alert" -> proc tabulate is case-sensitive to identify modalities. So I think you can use a proc format for example to avoid these issues and group similar modalities. Or even to overwrite original data if it is allowed. Hope this help. ... View more

Hi @Jagadeesh2907    A simple way to look for discrepancies between two datasets is to use a PROC COMPARE: proc compare base=dst1 comp=dst2 out=toprint transpose listall outcomp outbase; id app_id ; run; proc print data=toprint noobs; id _Type_; run; More details on the syntax on : https://www.lexjansen.com/pharmasug/2003/Tutorials/tu056.pdf The layout is not pretty cool but the content is very informative.   Hope this help! ... View more