Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Home
- /
- Programming
- /
- SAS Procedures
- /
- Combining Continuous Variables per Observation

Options

- RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

Posted 12-20-2016 08:31 AM
(950 views)

I have three continuous variables, tot_doc_fp, tot_nurse_fp, and tot_mid_fp. For my analysis, I want to know if any combination of the values of the three variables is greater than or equal to 2 for any of the observations, and then for what percentage of observations the combined value is greater than or equal to 2. I'm on version 9.4.

7 REPLIES 7

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

data have;

tot_doc_fp=1;

tot_nurse_fp=1;

tot_mid_fp=1;

output;

tot_doc_fp=0;

tot_nurse_fp=0;

tot_mid_fp=0;

output;

run;

data want(keep=fraction);

set have end=the_end;

if sum(tot_doc_fp,tot_nurse_fp,tot_mid_fp) ge 2 then count_true+1;

if the_end then do;

fraction=count_true/_N_; output;

end;

run;

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

Does this take into account that any one of the variables could have a value higher than 2 by itself?

And how do I view the output? Nothing is showing up in my results viewer.

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

the condition is that the sum of the variables is greater or equal 2, so any value can be on the input. In detail if one variable is ge 2 the condition is true, if you want something else, please specify your question.

The output fraction is stored in dataset want.

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

OK, th first part of my code creates a dummy dataset have with two observation. View this dataset.

In the next part i count the frequency and output the percentage. For one observation the condition holds true, for the other it does not. So the fraction is 0.5. I output this to the dataset want.

You need to provide more info or adapt the code for your case yourself.

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

Better post an example to explain your question and don't forget post the output either.

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

**If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. **

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.