| Date: | Thu, 12 Feb 2009 13:04:17 -0600 |
|---|
| Reply-To: | "./ ADD NAME=Data _null_;" <iebupdte@GMAIL.COM> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | "./ ADD NAME=Data _null_;" <iebupdte@GMAIL.COM> |
|---|
| Subject: | Re: isempty |
|---|
|
| In-Reply-To: | <9df17375-bdf5-4b14-b034-646474fed945@j1g2000yqi.googlegroups.com> |
|---|
| Content-Type: | text/plain; charset=ISO-8859-1 |
|---|
identifier=coalesce(telephone,zipcode);
or if character vars
identifier=coalesceC(telephone,zipcode);
On 2/12/09, hd <heenagd@gmail.com> wrote:
> I want to do something like this I have a dataset
>
> name telephone zipcode identifier
> henry 234 234
> james 012 567 012
>
>
> if telephone is empty i want to use zipcode as the identifier
> otherwise use telephone
>
> how do i check if a field is empty?
>
> Thank you!
>
|
