topic Re: INFORMAT: How not to read (') ? in SAS Programming

INFORMAT: How not to read (') ?

almmotamedi — Thu, 11 Feb 2016 17:17:05 GMT

Hi SAS users,

I have a data set (csv file) including several variables. The values of the variables include a (') at the begining like below . Could you please advise how to use INFORMAT, and not to read the (') and just the numbers/characters ?

'WV99

Thank you

Re: INFORMAT: How not to read (') ?

PGStats — Thu, 11 Feb 2016 17:29:42 GMT

Share with us the code you tried and a few lines of the csv file.

Re: INFORMAT: How not to read (') ?

mohamed_zaki — Thu, 11 Feb 2016 17:36:40 GMT

You can us COMPRESS function to get rid of all single quotation in your variables. Or you can use SUBSTR if your variable contains other desired single quotation other than the one in the beginning.

For example

data test;
input x $;
x=compress(x,"'");
cards;
're34
'466
'terew
;
run;

Re: INFORMAT: How not to read (') ?

almmotamedi — Thu, 11 Feb 2016 17:36:25 GMT

Here is the code:

data ABC.Entire_database_second;

infile "/v_share/Xiaomin/SCOPES/sas_dataset/Oct-08-2015/ScopesCalculations_SecondaryConstruction_*" linesize = 300 firstobs = 2 DSD ;

Informat
C_ST $3.0
C_DSTRB_AREA $5.0
N_RSK $7.0

input
C_ST $
C_DSTRB_AREA $
N_RSK $

run;

and attached is the csv file. Thank you

Re: INFORMAT: How not to read (') ?

almmotamedi — Thu, 11 Feb 2016 17:53:23 GMT

Thank you

Re: INFORMAT: How not to read (') ?

data_null__ — Thu, 11 Feb 2016 19:58:46 GMT

The $QUOTE informat will also do that. An you can associate the INFORMAT with all character variables.

33         data test;
34            input x:$quote.;
35            put x=;
36            list;
37            cards;

x=re34
RULE:      ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0                     
38         're34
x=466
39         '466
x=terew
40         'terew