Thank you so much for all your time and help.   I think I found the issue. My excel has multiple sheets and I'm reading from one sheet where these dates values are referencing from another sheet. When I use import wizard the dates are imported correctly but when I use proc import the dates are importing in numeric format. I have no control of changing the source file, updated by many hands. But I'm in the process of scheduling a job to read from this excel and send email to users with the list of all the products that will expire this month Excel date SAS proc import date 1/10/2024 45301 11/5/2024 45601   proc import out=count_xlsx datafile="c:temp\Inventory.xlsx" dbms=xlsx replace; SHEET="count_Inventory"; getnames=YES; run;     ... View more

Thank you for the quick solution ... View more

Actually, I had 48 bars, so the graph was crowded. Increasing the size of the graph fixed the data labels and centered the std error bar on the top. ods graphics / reset=ALL outputfmt=PNG imagename="GC_All." width=12IN height=12IN; ... View more

AFAIK, CLASSPATH isn't an ODBC LIBNAME option. Please post your current ODBC connection statement.  ... View more

Perfect. Thank you so much ballardw, Dan and Ksharp. This is exactly what I need. @Dan, Sorry for my delayed reposnse, I was trying on my real data where the response values are very low (0.002) for one replicate and 99.9 for another replicate. Having hard time to show on the same scale. All is well now. Thank you ... View more

Thank you. Very helpful ... View more

Thank you so much Clusterwidth is the one I am looking for. ... View more

Thank you so much. FLOW option worked. options papersize=(22in 22in); ods excel file= "C:\temp\gp.xlsx" options(flow="tables"); ... View more

Turn off whatever option it is in Windows Explorer that is hiding the file extensions. Windows does try to use different icons for different file extensions.  But they are often very similar (or even the exact same) for different extensions.     ... View more

Thank you. I tried vaxis with values before and it didn't work ... View more

64-bit SAS but MS Office bitness?  ... View more

Thank you so much. It worked very well. ... View more

@Stalk wrote: Thank you. DIF function works, but is there any similar function to DIF to use in Proc SQL? ERROR: The DIF function is not supported in PROC SQL, it is only valid within the DATA step. I have all my filters in SQL. Just for handling DIF function I have to recreate the whole dataset and order it again.   SQL by its very nature knows nothing about the ORDER of observations so it is a terrible choice to do something like this. Your second statement makes no sense at all.  How are going to create a new VARIABLE without creating a new dataset, whether you use SQL query or a data step? Note that you can create views using either PROC SQL code or data step code you want to avoid making multiple physical copies of the data. ... View more

Patrick, you are right. Your query's results is exactly what I am looking for. My original query took 7 hours to run and there were no records in the original data, so I made up this test data and got messed up. Thank you so much ... View more

Thank you Chris. It worked as desired. &sqlobs is very helpful. Also registered at SAS Explore using the link from your signature line:-) ... View more