| Date | Title | Type | ||
|---|---|---|---|---|
| 10/13/09 |
37283 - Use a Microsoft Excel file to create a user-defined format If you have an existing Excel spreadsheet containing variables and descriptions, you can easily transform it into a custom format. http://support.sas.com/kb/37/283.html, 20KB |
Sample | ||
| 8/14/09 |
36880 - Pagesize can increase when blank lines are written to a file using the DATA Step and a FOOTNOTE statement In the DATA Step, when writing to a file and using the FOOTNOTE statement, the pagesize setting might be increased by the number of blank lines written to the file ahead of non-blank lines. The initial pagesize setting ... http://support.sas.com/kb/36/880.html, 19KB |
Problem Note | ||
| 7/15/09 |
15639 - Character value of period is not output when DSD specified on FILE statement A character value of period is treated as a missing value instead of a period when DSD is specified on the FILE statement. The sample below illustrates this incorrect behavior. data test; input x $char1. +1 y $ ... http://support.sas.com/kb/15/639.html, 19KB |
Problem Note | ||
| 6/19/09 |
1075 - How to scan more than 20 records to determine variable attributes in EFI In Versions 7 and 8 of the SAS System, by default the Import Wizard, PROC IMPORT and the External File Interface (EFI) scan 20 records to determine variable attributes when reading delimited text files. Changing the ... http://support.sas.com/kb/1/075.html, 18KB |
Usage Note | ||
| 4/28/09 |
7018 - Exercise caution using ENCODING= option with mixed character and binary data The ENCODING= option enables you to dynamically change the character-set encoding for processing external data. This allows you to read or write data in a different encoding than your operating environment's session ... http://support.sas.com/kb/7/018.html, 21KB |
Usage Note | ||
| 4/3/09 |
35412 - ANYDTDTM informat reads datetime values as dates When reading datetime values with PROC IMPORT or the Import Wizard, often the ANYDTDTM informat is used since it can read many different styles of datetime values. When a value that is ambiguous is read, SAS may read ... http://support.sas.com/kb/35/412.html, 19KB |
Problem Note | ||
| 3/17/09 |
24727 - Robust macro to write a delimited file Create a comma delimited text file from a SAS data set using macro functionality. Several parameters can be used to generate a header, use variable labels, and specify the delimiter. http://support.sas.com/kb/24/727.html, 19KB |
Sample | ||
| 3/6/09 |
34480 - DBCS characters in SASŪ Web Report Studio report names might cause problems when publishing to a channel In SAS Web Report Studio, if the name of a report includes DBCS characters, you might have problems when attempting to publish the report to a channel. When you publish to a channel, a SPK (SAS Package) file is created ... http://support.sas.com/kb/34/480.html, 19KB |
Usage Note | ||
| 1/29/09 |
15883 - Length limitations when submitting SAS code There are many ways to submit SAS code and the length limitation is different depending on how you submit your code. The following are the length limitations as imposed by the various submission methods prior to SAS 9.2 ... http://support.sas.com/kb/15/883.html, 22KB |
Usage Note | ||
| 12/18/08 |
34254 - How to allow a numeric value enclosed in quotation marks to be read in as numeric variable with PROC IMPORT or the IMPORT WIZARD When using PROC IMPORT or the Import Wizard to read in an external file, values enclosed in quotation marks are automatically created as character variables. Even if the value is numeric like "12345" and is enclosed in ... http://support.sas.com/kb/34/254.html, 20KB |
Usage Note | ||
