You can use PROC IMPORT (SAS/ACCESS not required) on a CSV file to create a SAS program that can be tweaked to cater for things like 99 for missing day or month. The code can be seen in the SAS log after running the PROC IMPORT. All you have to do is copy from the log back to your editor window and you have a ready-made DATA step program that can modified to deal with any data issues. A trick with selecting code in your log is to hold down the Alt key when selecting the code block with your mouse. Then just do a Windows Copy and Paste. That way you avoid copying the line numbers. ... View more