The SAS Dummy
A SAS® blog for the rest of us![Which tables contribute to that SAS information map?](https://blogs.sas.com/content/sasdummy/files/2017/01/ProgrammingTips-2.png)
About a year ago (wow, has it been that long?), I posted an example program that lets you report on the contents of a SAS information map. Using my example, you can see the data items, filters, and folder structure within a given information map. Last week a reader posted
![What SAS administrators should know about libraries, metadata, and SAS Enterprise Guide](https://blogs.sas.com/content/sasdummy/files/2017/01/ProgrammingTips-2.png)
We sometimes take it for granted, but the concept of the "SAS library" is just about one of the most awesome aspects of The SAS System. You can give your library a name (a library reference, or libref), tell the system how to get to your data (options on a
![How to use SAS DATA step to copy a file from anywhere](https://blogs.sas.com/content/sasdummy/files/2017/02/ProgrammingTips-4.png)
SAS-based processes are critical to many organizations, but sometimes the trickiest part of your job falls into one or both of these activities: Getting stuff from the outside world "into" SAS. (Once it's in SAS, as many of you know, the world is your oyster.) Getting the output of your
![SAS Enterprise Guide options: my favorite 5](https://blogs.sas.com/content/sasdummy/files/2017/01/ProgrammingTips-2.png)
SAS Enterprise Guide has about 150 options that you can customize in the Tools->Options window. With each release, the development team adds a few more options that have been asked for by customers, and they rarely decommission any existing options. It's getting quite crowded on some of those options windows!
![Behind the scenes: importing Excel files using SAS Enterprise Guide](https://blogs.sas.com/content/sasdummy/files/2017/02/ProgrammingTips-3.png)
I hope that the following statement is not too controversial...but here it goes: Microsoft Excel is not a database system. That is, I know that people do use it as a database, but it's not an application that supports the rigor and discipline of managing data in the same way
![Calculating the number of working days between two dates](https://blogs.sas.com/content/sasdummy/files/2017/02/ProgrammingTips-4.png)
It's a simple task to use SAS to compute the number of weekdays between two dates. You can use the INTCK function with the WEEKDAY interval to come up with that number. diff = intck('WEEKDAY', start_date, end_date); If you want to compute the number of working days between two dates,