topic Re: Parsing Data from Text Fields in SAS Programming

Parsing Data from Text Fields

rmes — Sat, 03 Sep 2016 22:58:40 GMT

Hi,

here is the dataset where all the value are store as single string.

obs info

1 101 pencils 47
2 102 parker pens 28
3 103 apple ipod touch & shuffle 13
4 104 dell studio laptop 03

I want first starting number under id and ending number under qty and rest under name. please help me to solve out this problem.

Re: base sas

Shmuel — Sat, 03 Sep 2016 21:28:18 GMT

With hope I undertood your query:

data want;

infile datalines;

input info $60. ;

id = input(scan (info,1,' '), 3.);

qty_x = scan (info,-1,' ');

qty = input(qty_x,best6.);

name = substr(info,5, length(trim(info) - 4 - length(qty_x)));

drop qty_x;

run;

Re: Parsing Data from Text Fields

Reeza — Sat, 03 Sep 2016 22:59:17 GMT

Are you reading this from a text file or do you have it in a SAS dataset already?

Re: Parsing Data from Text Fields

Ksharp — Sun, 04 Sep 2016 03:29:25 GMT


data have;
infile cards truncover;
input  obs       info $80.;
cards;
    1        101 pencils 47
    2        102 parker pens 28
    3        103 apple ipod touch & shuffle 13
    4        104 dell studio laptop 03
;
run;
data want;
 set have;
 id=scan(info,1);
 name=prxchange('s/^\d+|\d+$//',-1,strip(info));
 qtr=scan(info,-1);
run;

Re: Parsing Data from Text Fields

Haikuo — Sun, 04 Sep 2016 17:15:05 GMT

data test;
infile cards truncover ;
input var $100.;
id=scan(var,1,'0123456789','k');
qty=scan(var,2,'0123456789','k');
name=scan(var,1,,'d');
cards;
101 pencils 47
102 parker pens 28
103 apple ipod touch & shuffle 13
104 dell studio laptop 03
;