topic How to read a single '.' (Period) into a CHAR column from a File in SAS Procedures

How to read a single '.' (Period) into a CHAR column from a File

deleted_user — Thu, 10 Jun 2010 12:41:10 GMT

Hi,
Can someone suggest how can i read a single '.' (Period) for a CHAR column from a File. When I read a file and there is a single '.' for a column with data type CHAR SAS converts the '.' value to a SPACE. I don't want to read . as space. I want to know when there was a space in the input file and when i get . then i want to retain it as some valid data.

When the input file has two back to back periods ('..') then I am able to read them just fine. The above mentioned problem arises when I try to read a single period into a char data type column.

Re: How to read a single '.' (Period) into a CHAR column from a File

data_null__ — Thu, 10 Jun 2010 14:37:34 GMT

The $w. informat is almost identical to the $CHARw. informat. However, $CHARw. does not trim leading blanks nor does it convert a single period in an input field to a blank, while $w. does both.

Re: How to read a single '.' (Period) into a CHAR column from a File

Ksharp — Fri, 11 Jun 2010 08:32:52 GMT

Hi. I agree with data null;
Try to use $CHARw. informat.

Re: How to read a single '.' (Period) into a CHAR column from a File

deleted_user — Fri, 11 Jun 2010 09:38:38 GMT

Hi data _null_ (dont know your name so will use your community name :))

It works fine now. Thanks for your help.