topic Re: seperate a single column values to each varibles in SAS Programming

seperate a single column values to each varibles

KrishnaChandra — Tue, 22 Jul 2014 06:49:09 GMT

hi i have a simple data set then how can i separate the data set values to each variable like dep_id ,dept_name,dep_qty.Please help ?

data a;

input info $1 - 50;

cards;

101 pencil 57

102 parker pen 24

103 hp studion shuffle n 10

104 samsung galexy ace 29

run;

i already solved the problem.But i need to know any easy way of doing the task simply.

i put my code on below..Please do check it and make some replies

data b;

set a;

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

xyz=substr(info,5);

pdt_nam=length(substr(info,5));

name=input(substr(xyz,1,pdt_nam-2),$20.);

pdt_qty=input(substr(xyz,anydigit(xyz)),2.);

label pdt_id=Product Id

name=Product Name

pdt_qty=Product Quantity;

drop pdt_nam;

drop info;

drop xyz;

runn;

Krishnachandran

Re: seperate a single column values to each varibles

Kurt_Bremser — Tue, 22 Jul 2014 07:37:00 GMT

You might want to introduce a dedicated delimiter into the input data, like the colon. Then you can use the dlm= option in the infile statement and let the input statement do the separation for you.

data want;

infile cards dlm=':'

format

pdt_id 3.

pdt_name $20.

pdt_quantity 2.

;

input

pdt_id

pdt_name

pdt_quantity

;

datalines;

101:pencil:57

102:parker pen:24

103:hp studion shuffle n:10

104:samsung galexy ace:29

;

run;

Re: seperate a single column values to each varibles

Ksharp — Tue, 22 Jul 2014 13:48:57 GMT

How about this :

data a;
input info $ 1-50;
cards;
101 pencil 57
102 parker pen 24
103 hp studion shuffle n 10
104 samsung galexy ace 29
;
run;
data b;
 set a;
 dep_id =scan(info,1,' ');
 dept_name=substr(info,findc(info,' ')+1,findc(trim(info),' ','b') - length(dep_id)-1 );
 dep_qty=substr(info,findc(trim(info),' ','b')+1);
run;

OR this one :

data a;
input info $ 1-50;
cards;
101 pencil 57
102 parker pen 24
103 hp studion shuffle n 10
104 samsung galexy ace 29
;
run;
data b;
 set a;
 dep_id =scan(compress(info,' ','kd'),1,' ');
 dept_name=compress(info,' ','ka');
 dep_qty=scan(compress(info,' ','kd'),-1,' ');
run;

Xia Keshan

Message was edited by: xia keshan

Re: seperate a single column values to each varibles

stat_sas — Tue, 22 Jul 2014 14:22:13 GMT

data a;

input prd_id name & $20. prod_qty;

cards;

101 pencil 57

102 parker pen 24

103 hp studion shuffle n 10

104 samsung galexy ace 29

;

run;

Re: seperate a single column values to each varibles

KrishnaChandra — Wed, 23 Jul 2014 06:28:44 GMT

Thanks Xia Keshan. I got the op