As the first step in the decommissioning of sasCommunity.org the site has been converted to read-only mode.


Here are some tips for How to share your SAS knowledge with your professional network.


Tips:Forcing all Character Variables when Importing a CSV File

From sasCommunity
Jump to: navigation, search

When using PROC IMPORT to read CSV files, the SCANTYPE=MIXED option is not available. This means that we do not have an option to force variables to be character. The GUESSINGROWS option can be used, but it can be costly for large files, or potentially not sufficient. Although it does require two passes of the data, there is a way to force all columns to be character when using PROC IMPORT on a CSV file.

....read more

Submitted By Art Carpenter (talk)