Hi, I would like to apply two types of floors, respectively for lower and upper segments of a dataset. Assume the dataset has two columns: Col1 which is unique and asc sorted; Col2 is the actual data the floor applies to 1) Floor 1 on the lower band of Col1 : for any values in Col1 less than3, which is set to by the user - replace their values in Col2 with the Col2 value of Col1 =3 2)Floor 2 on the upper band of Col1: for any values in Col1 greater than 4, which is set to by the user - replace their values in Col2 with the Col2 value of previous Col1 to ensure they are not decreasing when Col1 values increase Below is an example of the dataset I have and what I want. Many thanks in advance. data have; input Col1 Col2; datalines; 1 1 2 2 3 3 4 4 5 3 6 6 7 1 8 3 ; data want; Col1 Col2 1 3 2 3 3 3 4 4 5 4 6 6 7 6 8 6 ;
... View more
Could someone please clarify for me the difference between table probability and two-sided PR in a Fischer's exact test? which result should be consider as a p-value indicating the probability that the distribution in the table is random? Zachi
... View more
I'm outputting the frequency counts and %s from a crosstab table to a data set (out=test_freq in example code below).
The conditional percentages by x values are correct in the SAS Results tab, however the %s in the test_freq output dataset are not correct.
Is my syntax incorrect?
data test;
input x $ y $;
cards;
Alice blue
Alice blue
Alice blue
Alice green
Alice green
Alice red
Bob blue
Bob green
Bob green
Bob green
Bob red
Bob red
Bob red
Bob red
;
run;
proc freq data=test;
table x*y / nopercent nocol out=test_freq;
run;
... View more
It takes all kinds of minds on a team – people with diverse backgrounds and skill levels – to do amazing things. If you are looking to join a team, let’s find you a group. Or maybe your team needs more hackers. If so, please follow these steps:
STEP 1. Reply to this post with your search criteria. Include the follow details:
“I’m looking for a team.” or “I’m looking for a team member.”
Track name
Skills
Your LinkedIn and/or GitHub profile (if applicable)
Here’s an example:
Interest: I’m looking for a team
Track: Energy
Skills: SAS Viya
Social: https://www.linkedin.com/in/christine-brown-47425316/
STEP 2. Create your replies following this order to maintain consistency in the thread.
STEP 3. Contact a potential new teammate using the SAS Support Communities' private messaging feature to discuss if a team or member is a good fit.
STEP 4. You need to be a member of a team in order to Register.
STEP 5: If you have any edits to your team after you Register, send an email to sashackathon@sas.com. The Event Team needs to know about any changes to your team and members. Also, don’t forget to update your team profile on the SAS Hacker's Hub.
Happy hacking!
... View more
Team Name *team name here* I'm green. *track here* Looking for a team to join. *one sentence describing use case here* *technology used to solve use case here* From the PNW *region you are from (EMEA, AP, LATAM, etc.) here* *name of team leader here* *all team members' Communities @username here* *all team members' social media links here* Is your team interested in participating in an interview? *Y/N* I am looking forward to this challenge.
... View more