Sometime very recently, probably while you weren’t looking, I changed jobs at SAS (yes, again). This time it’s a bigger change for me, because I’m no longer part of the SAS R&D organization, where I’ve worked for nearly 14 years. Instead, I’m pa…
sas7bdat database reader update
An earlier post (1216) introduced a compatibility study (i.e. reverse engineering) of the sas7bdat database file format. The code and documentation for this are here: http://github.com/biostatmatt/sas7bdat. I’ve recently restructured the code as an R package, and added some functionality. Look for the sas7bdat package on the CRAN. Also, the read.sas7bdat code has been ported to […]
How to generate the month name from a numeric date value
Task: I have a SAS date and wanted to create a variable with the month name.
Here is how to do it……
Using MONNAMEw. format which is simple and easy. MONNAMEw. format is available in SAS 9.X versions.
/*Use MONNAMEw. format*/
data …
How to generate the month name from a numeric date value
Task: I have a SAS date and wanted to create a variable with the month name.
Here is how to do it……
Using MONNAMEw. format which is simple and easy. MONNAMEw. format is available in SAS 9.X versions.
/*Use MONNAMEw. format*/
data …
How to generate the month name from a numeric value
Task: I have a SAS date and wanted to create a variable with the month name.
Here is how to do it……
Use MONNAMEw. Format which is simple and easy. MONNAMEw. Format is available in SAS 9.X versions.
/*Use MONNAMEw. format*/
data month;…
ERROR: The MS Excel table (worksheetname) has been opened for OUTPUT.
I happend to stumbleupon a post from SAS support blog regarding the ERROR message in the LOG file when trying to output a SAS dataset in the form of Excel sheet.
Direct link:
ERROR: The MS Excel table (worksheetname) has been opened for OU…