Doing some work to figure out how to remove the Edit tab for a user in WRS 4.3. Found this table of roles for WRS on the SAS Support site here: Predefined Roles and Capabilities for SAS Web Report Studio By the way the trick on the edit tab is to make sure PUBLIC doesnt […]
SAS makes spreadsheet for reporting
Excel is the last stop in the pipeline of my daily work. Most clients of mine like colorful multi-sheet spreadsheets more than plain CSV files (I guess they all use Windows). I am not a power user of Excel, and honestly I am a little afraid of it: so…
Example 8.37: Read sheets from an excel file
Microsoft Excel is an awkward tool for data analysis. However, it is a reasonable environment for recording and transfering data. In our consulting practice, people frequently send us data in .xls (from Excel 97-2003) or .xlsx (from Excel 2007 or 201…
Tuning SAS on Windows 2008 (watch windows file cache and I/O)
One of the sessions I got a lot out of at the SAS Global Forum was Margaret Crevar’s session where she outlined what options existed for tuning SAS on Windows 2008. Some recommendations I noted where: On Windows 2008 64-bit size: 4Gb of RAM per core. 1.5 x physical RAM for page file change default SORTSIZE to […]
Calculating the number of working days between two dates
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 = intkc(’WEEKDAY’, start_date, end_date);
If you want to c…
Calculating the number of working days between two dates
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 compu…