topic Re: Doubt in List Input in SAS Programming

Doubt in List Input

er_awasthi — Mon, 14 Sep 2009 16:21:26 GMT

Hi,
In chapter 18 of SAS certi book(List Input ) says that ampersand (&) is used to read character values that contains embedded blanks.

For Below program , In value of city(2nd row) there is space between New and Delhi and I'm reading this value without giving '&' and it is being read correctly.
How is this possible ?

DATA INPUT;
INFILE DATALINES MISSOVER DLM=',*' DSD;
LENGTH CITY $9.
JOB $10.;
INPUT FNAME $
LNAME $
AGE
CITY
JOB $;
PUT _ALL_;
DATALINES;
MANISH,AWASTHI*24*PUNE,SFTWR
VIVEK,CHOPRA,*NEW DELHI,CONSULTANT
:

PROC PRINT DATA=INPUT NOOBS;

Output
CITY JOB FNAME LNAME AGE

PUNE SFTWR MANISH AWASTHI 24
NEW DELHI CONSULTANT VIVEK CHOPRA .

.
Thanx

Manish

Re: Doubt in List Input

DanielSantos — Mon, 14 Sep 2009 16:41:23 GMT

Hello.

That's because you are using the DLM=',*' option.

Everything gets separated by the delimiters (, or *) rather than by blanks.

See more on this here:
http://support.sas.com/documentation/cdl/en/basess/58133/HTML/default/a001066690.htm

Cheers from Portugal.

Daniel Santos @ www.cgd.pt

Re: Doubt in List Input

sbb — Mon, 14 Sep 2009 16:48:05 GMT

You have altered the SAS-default DLM= which would be a blank character.

Scott Barry
SBBWorks, Inc.

Re: Doubt in List Input

sbb — Mon, 14 Sep 2009 16:48:44 GMT

Sorry - missed Daniel's fine reply.

Scott