LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (June 2008, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Wed, 11 Jun 2008 09:45:37 -0500
Reply-To:     "data _null_," <datanull@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "data _null_," <datanull@GMAIL.COM>
Subject:      Re: reading variables enclosed in quotes
Comments: To: rmat <regivm@gmail.com>
In-Reply-To:  <5136f27b-0407-4096-b0a9-b7f41a66850c@d45g2000hsc.googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1

as long as you have at least 2 spaces between each quoted field the & format modifier is the solution you need.

data x; infile datalines firstobs=2; input (name temp state) (&$quote.); age = input(temp,best.); drop temp; datalines; "Name" "Age" "State" "Smith AA" "22" "NJ" "Tom BB" "44" "CT" "Shake CC" "34" "CA" ; run; proc print; run;

On 6/11/08, rmat <regivm@gmail.com> wrote: > Hi Mike, > > Thanks very much for your solution. However, I am facing another issue > as there are space within enclosed quotes (like below). It will be > great if you or anybody else can help me regarding this. > > Thanks again, Regi > > > data x; > infile datalines firstobs=2; > input (name temp state) (: $quote.); > age = input(temp,best.); > drop temp; > datalines; > "Name" "Age" "State" > "Smith AA" "22" "NJ" > "Tom BB" "44" "CT" > "Shake CC" "34" "CA" > ; > run; >


Back to: Top of message | Previous page | Main SAS-L page