dashes and spaces

SannaSanna — Mon, 28 Jul 2014 20:38:10 GMT

Hello-

Looking for some assistance in putting together a new string variable. Due to bad data entry from various sources, I need to somehow make the data element consistent. Currently I have data sample #1- under column heading 'p_ds' there are dashes and spaces within the character string. I would like to create a new variable that would 1) eliminate the dash '-' in obs 1, 2 and 4. and 2) eliminate the space in position 3 and position 9 in obs 5.

obs	p_ds	count
1	01-100017-6002000	5
2	01-611436090211	25
3	4159512368424	8
4	0461549-6003362	3
5	05 61564 6003420	8

I would like my final dataset to look like sample #2. How can I best approach this?

1	11000176002000	5
2	1611436090211	25
3	4159512368424	8
4	04615496003362	3
5	5615646003420	8

Re: dashes and spaces

slchen — Mon, 28 Jul 2014 20:57:19 GMT

string=compress(p_ds,,'kd');

Re: dashes and spaces

stat_sas — Mon, 28 Jul 2014 21:00:04 GMT

data want;

set have;

p_ds=compress(p_ds,,'kd');

run;

topic Re: dashes and spaces in SAS Procedures

dashes and spaces

Re: dashes and spaces

Re: dashes and spaces