Search results for query: *

Hi everybody, I run the following code and it looks like my nonbase_dt field data are presented improperly because my log told that set OUT.BASEEARL has 0 observations while it has a lot 21 data out.baseEarl; 22 set out.baseEarl; 23 by memberid nonbase_dt; 24...

Hi everybody, I need to calculate the Mean Age of a population (descriptive statistics) by gender and product. How can I do it with Proc Mean? Or probably with PROC UNIVARIATE? Thank you in advance, Irin

Klaz, Considering Proc Freq....how can I implement it for DISTINCT members?

Klaz, don't you think that my problem is in the way I assign medcat rather then in chosing PROC SQL instead PROC FREQ? i mean..it does work inproperly because categories (medcat) are inproperly assigned in my data step. Probably because of decimal outliers...

Hi everybody, I am trying to calculate count of members according to the certain categories. In other words I need to know how many distinct patients are under certain categories: Medcat= “$1000” Medcat=”$1000-2000” Medcat=”$2000-5000” I used proc SQL: Proc SQL ; Create Table...

Hi everybody, I have a file of patients who had many lab tests. However I am just interested in tests “A”, “B”, “C”, “D” and “E” I need to know how many patients have each kind of test. How can I do it? Thank you in advance! Irin

Klaz, When I applied it to the following code it generate the log: 153 data equalStartdate NotequalStartdate; 154 set bc65strangers_dates; 155 by member_first_name member_last_name sex date_of_birth; 156 IF MONTH(DATEPART(startdate))=MONTH(dm_program_eff_dt) AND 157...

Klaz, I did proc contents for both values: Proc contents result of data warehouse table (OUT.RGSTR_key_real A) Variable Type Len Pos Format Informat Label --------------------------------------------------------------------------------- MEM_BIRTH_DT Num 8 0...

Assuming that day of Birth might be not accurate in left hand table (as I got less records than expected) I decided to join both tables just by month and by year. I got the below log however. Does it mean I wrongly combine datepart and month/year function? Is there any syntax mistake? It does...

HTH! It looks like it works! At first I was confused that it generate initial digit “–“ for some of them but as long as data type of each table except new stayed as text it doesn’t matter! Thank you so much!

BoxHead, thank you very much for your valuable insight! It never even came to my mind and You are absolutely right -whoever can do the same encoding. Trying not to involve your SSN :)(even although it is not ssn but I still do not want to send them as they are) into this hypothetical trouble, I...

I tried End Function. It does not generate error message. However when I query the output is just one column with a heading Expr1000 under which all rows are empty. I tried to open original table …column values are not changed

lespaul, Thank you for your response. I created a new quiery with the SELECT statement but failed.... I did not create a new field however. So I wonder if (YourIDField) means my new ID field or it supposed to overlap my old one? Thank you in advance! Irina

Golom, Thank you very much for your response. I created a module1 but not having any experience with Modules I wonder how to make my module connected to my table. In other words…I have the table and I have Module1 with a function in need …now how can I make both work together? Sorry for the...

I just need to code IDs. In order they stop be “real” For example: For digit 0-> put 1 For digit 1-> put 2 For digit 2-> put 3 For digit 3-> put 4 For digit 4-> put 5 For digit 5-> put 6 For digit 6-> put 7 For digit 7-> put 8 For digit 8-> put 9 For digit 9-> put 0 sample: For ex...

Hi experts! I have a large file of 10,000 records for patients whose ID is alphanumeric field of 9 digits (look like numbers for ex “123456789”). I am going to take a biostatistics course on-line based on my material(typical dataset) and I do not want to provide somebody with a sensitive...

Hi Experts, I need scores among product and gender groups (N; Mean; std values for Total_score) I have a dataset with total_score, product and gender. In other words I need a table like the following: *************************************** N...

Vragabond, I never happened to do it before but it seems to me that I did uploaded it onto server.....Could it be otherwise? I just know that I went to http://www.geocities.com and signed under my yahoo ID. After I did it, I got Geosites Control panel with the following url...

Kendel, My html file is named index.html ...without any capital letters: index.html Billy, I fixed the name of picture from Drawing1.jpg to drawing1.jpg now. I am still able to view my drawing1.jpg on my PC ...However I am still unable to view the picture on geocities:-( What else could be...

There are 21 responses to questions in my dataset. Depending on which survey/dataset I use in my code ,the output contains 2, 3, or 4 Factors. However the screen plot's "elbove" is not always obvious. That is why I would like to FORCE program to generate 3 factors instead 2 as code did and see...