topic Re: Regarding SAS in SAS Enterprise Guide

Setting a flag if data value present

saikiran_nemani — Tue, 29 May 2018 11:47:35 GMT

If any Lead number is Present in the Given data it should appear as installed=1

How to Solve this in Proc Sql ?

Ex :

Lead Number Installed

2121221 1

2212154 1

Re: Regarding SAS [how to improve your question]

Community_Guide — Mon, 28 May 2018 13:40:39 GMT

Hello @saikiran_nemani,

Your question requires more details before experts can help. Can you revise your question to include more information?

Review this checklist:

Specify a meaningful subject line for your topic. Avoid generic subjects like "need help," "SAS query," or "urgent."
When appropriate, provide sample data in text or DATA step format. See this article for one method you can use.
If you're encountering an error in SAS, include the SAS log or a screenshot of the error condition. Use the Photos button to include the image in your message.
It also helps to include an example (table or picture) of the result that you're trying to achieve.

To edit your original message, select the "blue gear" icon at the top of the message and select Edit Message. From there you can adjust the title and add more details to the body of the message. Or, simply reply to this message with any additional information you can supply.

SAS experts are eager to help -- help them by providing as much detail as you can.

This prewritten response was triggered for you by fellow SAS Support Communities member @Kurt_Bremser

Re: Regarding SAS

PaigeMiller — Mon, 28 May 2018 13:50:59 GMT

Data step solution

data want;
    set have;
    if not missing(lead_number) then installed=1;
run;

And yes, a more meaningful title and more information is always appreciated and helpful.

Re: Regarding SAS

Astounding — Mon, 28 May 2018 17:01:37 GMT

To do that in SQL, use a CASE clause within the SELECT statement.

Unfortunately, the syntax depends on whether LeadNumber is character or numeric, and you haven't yet told us that information.

Re: Regarding SAS

Tom — Mon, 28 May 2018 17:49:29 GMT

What value should the new INSTALLED variable have when LEADNUMBER is missing?

It is probably easiest in SAS to just let SAS create the new variable as a boolean number where 1 is true and 0 is false.

For example you could use the SAS function MISSING() to test if LEADNUMBER is missing. And use the NOT operator to take the complement of the result.

proc sql;
select
    leadNumber
  , not missing(leadNumber) as Installed
  from have
;
quit;

Re: Regarding SAS

saikiran_nemani — Tue, 29 May 2018 08:10:32 GMT

Suppose these are the Lead numbers and How do we Create a variable called Install with the Value 1 for each lead number

Data Type : NUMERIC

42129203

43899661
43947460
45396478
45439343
45566313
45599714

Re: Regarding SAS

PaigeMiller — Tue, 29 May 2018 11:11:24 GMT

Please read the replies already provided above.