About KristiW

KristiW · ‎12-30-2022

@ballardw Thank you so much! This appears to get me the closest to what is in my text book. The values are different but after reviewing the data set I believe they are correct so apparently the data set we have is a bit different from what they used in the text book. I appreciate your share of knowledge, hopefully I can pay that forward once I'm more proficient in SAS myself. Have a wonderful New Years!

KristiW · ‎12-30-2022

@PaigeMiller The word doc contains an image which this forum would not originally let me post, that is why it is in a word doc. I was able to include it in this reply though, please see below. What we write has to match this grid output, I have gotten some of this but the totals are off an any row or column that is all zero's is not being included and I'm not sure how to code to make sure that they appear even though there are only zero's. Here is what I have written so far, I'm sure it is not right but I'm brand new at this so struggling through. Your help is appreciated! data uniform_bins; set work.import; if x >=0 and x<1 then xbin=1; if x >=1 and x<2 then xbin=2; if x >=2 and x<3 then xbin=3; if x >=3 and x<4 then xbin=4; if x >=4 and x<5 then xbin=5; if x >=5 and x<6 then xbin=6; if x >=6 and x<7.5 then xbin=7; if y >=0 and y<1 then ybin=1; if y >=1 and y<2 then ybin=2; if y >=2 and y<3 then ybin=3; if y >=3 and y<4 then ybin=4; if y >=4 and y<5 then ybin=5; if y >=5 and y<6 then ybin=6; if y >=6 and y<7.5 then ybin=7; run; proc tabulate data=uniform_bins; title "Simulation - Uniform Point Grid"; class ybin; class xbin; table ybin, xbin *n= ' '/ printmiss misstext='0'; run;

KristiW · ‎12-28-2022

I'm brand new to SAS and in my Data Mining course I have to provide the below. I am able to do numbers 1 & 2 with no problem but when it comes to number 3 I'm stumped. None of our text or materials gives any clue other than "The point counts for grid cells can be calculated using a conditional statement such as an IF-THEN statement." I'm not looking for the exact answer but I've exhausted just about every other resource so I'm hoping to find help here. The point counts for grid cells has to match the image in the Word doc I included. Any help is appreciated! Complete the following tasks: Upload the dataset file simulation-uniform.csv from the Module 6 to SAS Studio. The first 200 observations in the dataset were generated from a uniform distribution over a circle centered at (2,3) of radius 2, and the next 100 observations were generated from a uniform distribution over a circle centered at (6,3) of radius 1. By writing appropriate SAS code, produce a scatterplot of the data. Your plot should look similar to the one shown in Figure 8.10 (page 646) in Introduction to Data Mining. By writing appropriate SAS code, generate the point counts for grid cells. It should have 49 cells using a 7-by-7 grid. Refer to Table 8.2 (page 646) in Introduction to Data Mining. Thanks, Kristi

Online Status	Offline
Date Last Visited	‎01-11-2023 08:31 PM

Re: Need guidance creating a count point grid for a scatterplot of dat...

Re: Need guidance creating a count point grid for a scatterplot of dat...

Need guidance creating a count point grid for a scatterplot of data

Re: Need guidance creating a count point grid for a scatterplot of dat...

Re: Need guidance creating a count point grid for a scatterplot of dat...

Re: Need guidance creating a count point grid for a scatterplot of dat...

Need guidance creating a count point grid for a scatterplot of data