Hi all, I two numeric-Continuous variables. I'd like to draw a distribution where one continues variable x-axis and the other one is y-axis. I draw scatter plots with the curve but I don't want dots in the graph. It should be more like Kernel or Normal distribution. However, as I know I can draw Kernel or Normal distribution with only one variable using density. I want a distribution as seen below.   Could you help me to draw it?   Thanks. ... View more

Hi, I have a data set look like below:   district       number      d1                10000      d2                  1000        d3                    500        d4                   1002        d5                  700          d6                 10070       d7                   5             d8                 9800   I want to sum possible districts where the total number is close to 11077. For example, the sum of d1 and d2 is 11000 and it's close to 11077. Same thing for d4, d6, and d7 (their total is 11077). It doesn't need to be only two districts, it can be more than two. The only things I need are all districts should have a flag number and the total should be close to 11070. I have 70 districts in my data set.   district       number     flag d1                10000      1 d2                  1000       1 d3                    500       2 d4                   1002       3 d5                  700         2 d6                 10070      3 d7                   5            3 d8                  9800      2     Thanks for any comment and help!   ... View more

Hi all, I have a data set as in the picture (I'm not copying the data because I want you to see that I have missing values).The data has 108 items' scores (one digit) and then id1 (8 digits) (no space between items and id) and then one space and id2 (3 digits). The spaces you see are missing values not tab or any type of delimiter for items and id1. When I use infile statement all items are in one column. Could you help me to read this data?The txt file in the attachment has the data.   Thank you,   ... View more

Hi All, I have two data sets as below. I'd like to match/find equivalent of a score in data set1 from data set2. I know I need vlookup function but I need to do this for per domain. So, basically I need to use vlookup for matched data sets based on domains.   Data set1                                          Data set2                                                                  data_want paper_s  domain                  paper_s     EQ_paper     domain                           paper_s     EQ_paper          domain 101     Speaking                      101        151              Speaking                                101        151                  Speaking 102     Listening                       102        180              Reading                                 102        181                   Listening 103     Reading                        102        181              Listening                                103        180                   Reading                                                 104        160               Listening                                                 103        180              Reading ....                                               ....   I'll appreciate for any help, any comments! Thanks ... View more

Hi all, Although there are similar questions in the community their answers didn't work for me, maybe I did something wrong. I have a string data includes numbers. I'd like to separate them to 5 digits numbers. For example,   Have                                                                Want  O_ID                                            O_ID1          O_D2       O_ID3 123451122312390                      12345            11223       12390 1234690876                                12346            90876   I'll appreciate for  any comment, any help ... View more