06-21-2012 05:28 AM
I am getting the data from .CSV files.
Getting all the data in character format.
Can you please help to format the below datatypes to SAS data types.
|Field||DateTime||Call Start Time|
|Field||DateTime||Call End Time|
It will be great help. Thanks in advance.
06-21-2012 06:10 AM
When importing/creating the .csv files you can change to what ever (format/length/type/in format/name) you want.Check the Screen shot below.
06-21-2012 08:09 AM
When reading data from textile into a SAS table you need to use the correct INFORMAT so that SAS converts the strings as required. Especially for date and date time values you also need to apply appropriate formats so that the values are "human readable" when looking at them.
This is very basic stuff and you must understand how this works. It's documented in the Base SAS Language and the Concepts manual. You need to read it.
You also need to understand how SAS stores date and date time values and what variable types SAS uses. It's all in the concepts manual (online available).
Below links should help as well: