topic Re: Importing coma delimeted text in SAS Programming

Importing coma delimeted text

sg_kr — Wed, 05 Sep 2018 10:58:04 GMT

Hi <

i have 3 columns like below.

Name age sex

kalyan,reddy,27,M

Goutham,reddy,28,M

i want to import the name kalyan,reddy & goutham,reddy under column Name.

Thanks in advance

Re: Importing coma delimeted text

andreas_lds — Wed, 05 Sep 2018 11:01:42 GMT

Import as two variables, then use a cat-function to create the required value in a new variable.

Re: Importing coma delimeted text

sg_kr — Wed, 05 Sep 2018 11:05:08 GMT

thank you, but any other way except this.

Re: Importing coma delimeted text

muratatik — Wed, 05 Sep 2018 11:05:36 GMT

You can use infile and dsd options. But your name variable sould be in quote marks.

data want;
infile datalines dsd dlm=",";
input Name :$15. age sex $;
datalines;
'kalyan,reddy',27,M
'Goutham,reddy',28,M
;
run;

Re: Importing coma delimeted text

sg_kr — Wed, 05 Sep 2018 11:09:06 GMT

Thanks for your reply.
but the data is to be import from a sheet and now enclosed in " ".

Re: Importing coma delimeted text

RW9 — Wed, 05 Sep 2018 11:18:52 GMT

The import program needs to have a logical method of reading the data. It does this by having a delimiter. In your case the delimiter is used within the data, hence you have the choices:

enlcose the data which has the delimiter within quotes

change the delimier to something which does not appear in the data

import the data as is and post process the data

There is no other logical way of identifying data which may or may not be part of the same variable.

Re: Importing coma delimeted text

Kurt_Bremser — Wed, 05 Sep 2018 12:06:00 GMT

Wrap up the input line from the back end:

data want;
input;
length
  name $50
  age 8
  sex $1
;
nwords = countw(_infile_,',');
sex = scan(_infile_,-1,',');
age = input(scan(_infile_,-2,','),best.);
do i = 1 to nwords - 2;
  name = catx(',',name,scan(_infile_,i,','));
end;
drop i nwords;
cards;
kalyan,reddy,27,M
Goutham,reddy,28,M
;
run;