Hi,   Below is my simple report to export dataset to excel and highlight a row if it has value as null for a particular record, Dataset used has following records,     ods results on ;ods excel file="C:\Data\GENDER.xlsx" options (sheet_interval='none' embedded_titles = 'yes' SHEET_NAME="PROVTYPE_ERR" ); proc report data = UNIQUEPROVIDERTYPES ; column FIELD_NAME VALUE cnt  ; define field_name/display; define value/display; define cnt/display ; compute value; if value = ' ' then do ; call define ('field_name','style','style = {background=red}'); call define ('value','style','style = {background=red}'); call define ('cnt','style','style = {background=red}'); end; endcomp; run;   Case 1: When i run above program , i get report as below without highlighting CNT column,   Case 2: When i replace multiple define statements into one as below ,  call define (_row_,'style','style = {background=red}');   My report looks like below (Highlighting the CNT last column as well)   Case 3: when i replace only my column statement as below , bringing CNT variable in the front (not as last variable) column FIELD_NAME cnt VALUE ;   My report looks like below (Highlighting the CNT but this time it is not the last column because of order changed in column statement)     My doubt is why i am not getting the required results as below during the case 1 scenario. Why CNT variable as last column is not highlighted in case1? Why order changing in column statement in case 3 highlight the column CNT good?    ... View more

I am trying to create a file from SAS with date and timestamp on as below, NAME_201907241615A.TXT   I could able to get the date in YYYYMMDD format using date() function with YYMMDDN8 format. But i am finding difficult to get the time in 24 hr format. Or else if time is 9 AM , space is coming before 9 instead of 09.   So i tried this logic and it is working good as expected,   %let Time = %sysfunc(time(),time.) ; %let Time_HH = %scan(&Time,1,:) ; %let Time_MM = %scan(&Time,2,:) ; HH=PUT(&TIME_HH,2.); if length(hh)<3 and '0'>= hh < '10' then hh=repeat('0',2-length(hh))||strip(hh);  MM =PUT(&TIME_MM,2.); if length(mm)<3 and '0'>= mm < '10' then mm=repeat('0',2-length(mm))||strip(mm); var9="EDS"||"_"||"&VEN"||"_"||"&LOB"||"_"||"&TYP"||TRIM("_")||strip(%sysfunc(date(),YYMMDDN8.))||TRIM(HH)||TRIM(MM)||TRIM("A")||&VER;   The red highlighted portion i tried to get hour and minute as 2 digit (like 09), if the time is single digit. I think there could be a straightforward approach , which i am missing. Is there is any other options to do this simply?Can we do this using picture clause in format?   Thanks, Meenakshi ... View more

Hi,     I wanted to find duplicates based on the entire record of 55 columns. I have done it using SAS procedures like sort with NODUP/ NON UNIQUE KEY option. But i am wondering , can we able to accomplish this using the data step BY group processing.    can we able to use _ALL_ , _NUMERIC_ etc in BY processing. I have used this in the BY statement in procedures. Instead of typing in all 55 columns.    Or is there is any other way in data step processing that we can get the duplicate record(the entire record )  without any specific key field.    Thanks. ... View more