Date: Fri, 13 Mar 1998 21:21:06 GMT
Reply-To: Colin Renfrew <candkane@NEWSGUY.COM>
Sender: "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From: Colin Renfrew <candkane@NEWSGUY.COM>
Subject: Re: Splitting a variable into two variables based on a character
somewhere in the field
Content-Type: text/plain; charset=us-ascii
On Thu, 12 Mar 1998 23:01:20 -0700, Jim Linck <jim.linck@ASU.EDU>
>Seems like the pointer, input and substring commands may be able to be used
>together to handle this task; however, I'm not sure how to do it.
>I have a Name which I read in originally as part of an overall .csv file.
>The name is in the format last, first. What I want to do is create two
>variables from the Name variable, last and first where last contains all
>info before the command and first contains all info after the comma.
>Anybody know how to do that?
Use the SCAN() function, e.g.,