I’m trying to import a bunch of excel files (~30 odd files, with over 10 tabs in each.) into SAS using proc import , and I’d then append them into a single SAS file for my analysis. However, I’m facing a few challenges in putting this entire import into a SAS macro because the work sheet names in each of the excel files are different.All of them have the same 2-3 words at the beginning, but can have very different names towards the end. I was wondering if there’s a work around for this? Can we use some function/ operation similar to substr where I can select the worksheets/tabs that start with “Cost Cg PRCH” and then import them? Please do let me know if we can thing about an alternative.    Thanks a lot.       ... View more

Hi there,   I have a big dataset. I want to see no of observations of that dataset. When  I use 'Proc contents' , it gives me a missing value {dot(.)} against the "observations" field.   Is there any other way, I can get this no of observation. I don't want to use Proc sql;select count(*) as it takes a lot of time to display the output .   Thanks, Debi   ... View more

Hi there,   We want to access windows SQL Server (MSSQL) from SAS on unix using windows AD ID as login credentials.   We think for that we nbeed to set up SAS Access to MSSQL and also ODBC Datadirect.    So,could someone help me on these??   1. How can I achieve this and perform the set up being the SAS admin. 2. IF SAS/ Access to MSSQL software needed to be installed,then what would be its cost. 3. Do we need ODBC Datadirect  for this? If yes, then how we can install, configure it in association with SAS Access to MS SQL.   Any other helpful suggestions would be great..   Thanks, Debi ... View more