topic Re: How to format SQL fields to SAS SI 3.4 fields in SAS Data Management

How to format SQL fields to SAS SI 3.4 fields

SYN — Thu, 21 Jun 2012 09:28:30 GMT

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	Varchar(20)	DD/MM/YYYY
Field	DateTime	Call Start Time
Field	DateTime	Call End Time
Field	Text
Field	int
Field	numeric(9,2)
Field	numeric(9,2)
Field	numeric(9,0)
Field	Numeric(15,0)
Field	Numeric(15,0)
Field	Decimal (17,2)
Field	Decilmal(10,2)
Field	Decimal(10,2)
Field	BigInt

It will be great help. Thanks in advance.

Re: How to format SQL fields to SAS SI 3.4 fields

SYN — Thu, 21 Jun 2012 09:33:36 GMT

How to format SQL fields to SAS DI 3.4 fields

Re: How to format SQL fields to SAS SI 3.4 fields

shivas — Thu, 21 Jun 2012 10:10:53 GMT

Hi,

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.

Thanks,

Shiva

Re: How to format SQL fields to SAS SI 3.4 fields

SYN — Thu, 21 Jun 2012 10:30:42 GMT

Shiva thank you. What you said is correct.

But I need what is the equalent SAS format for the above fields.

Please help me.

Re: How to format SQL fields to SAS SI 3.4 fields

Patrick — Thu, 21 Jun 2012 12:09:31 GMT

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:

[http://support.sas.com/documentation/cdl/en/acreldb/63647/HTML/default/viewer.htm#a001405621.htm

[http://support.sas.com/documentation/cdl/en/lrcon/62955/HTML/default/viewer.htm#a003209899.htm