## How to split character and numeric data from a single column

Solved
Occasional Contributor
Posts: 9

# How to split character and numeric data from a single column

Hello SAS Community!

I need to split the address column into two new columns, City and ZipCode.

``````data AgentD;
infile '/home/Homework 3/AgentD.txt' firstobs=2;
length Customer 8 Date1 8 Date2 8 Address \$13;
input Customer Date1 : YYMMDD10. Date2 : YYMMDD10. Address \$ &;
run;
proc print data=agentd;
title 'AgentD';
run;``````

Any ideas on how to do this?

Accepted Solutions
Solution
‎02-07-2018 01:44 PM
PROC Star
Posts: 1,595

## Re: How to split character and numeric data from a single column

[ Edited ]

use scan function

``````data AgentD;
infile '/home/Homework 3/AgentD.txt' firstobs=2;
length Customer 8 Date1 8 Date2 8 Address \$13;
input Customer Date1 : YYMMDD10. Date2 : YYMMDD10. Address \$ &;
run;
proc print data=agentd;
title 'AgentD';
run;``````

All Replies
Solution
‎02-07-2018 01:44 PM
PROC Star
Posts: 1,595

## Re: How to split character and numeric data from a single column

[ Edited ]

use scan function

``````data AgentD;
infile '/home/Homework 3/AgentD.txt' firstobs=2;
length Customer 8 Date1 8 Date2 8 Address \$13;
input Customer Date1 : YYMMDD10. Date2 : YYMMDD10. Address \$ &;
run;
proc print data=agentd;
title 'AgentD';
run;``````
Occasional Contributor
Posts: 9

## Re: How to split character and numeric data from a single column

That worked with some formatting. Now how can I make the ZipCode column a numerical value?

``````data AgentD;
infile '/home/Homework 3/AgentD.txt' firstobs=2;
length Customer 8 Date1 8 Date2 8 Address \$24;
input Customer Date1 : YYMMDD10. Date2 : YYMMDD10. Address \$ &;
format Date1 Date2 YYMMDD10.;
keep Customer Date1 Date2 City ZipCode;
run;
proc print data=agentd;
title 'AgentD';
run;``````
PROC Star
Posts: 1,595

## Re: How to split character and numeric data from a single column

use input around the scan like:

``ZipCode=input(strip(scan(address,-1,',')),5.);``

☑ This topic is solved.