INFORMAT: How not to read (') ?

[almmotamedi]

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

[PGStats]

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

[almmotamedi]

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

[mohamed_zaki · Accepted solution]

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;

[almmotamedi]

Thank you

[data_null__]

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