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...

...I have a feeling that something is wrong with my splitting into categories and I wonder if the decimal of allow_amt (for ex. it looks like numeric ****.25) could cause a wrong calculation results (I mean I summary and get more than total:(). How can I avoid this kind error? How can I split it...

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

...startdate Num 8 8 MMDDYY10. This is for DM_PROGRAM_EFF_DT ***************************************************************************************** Variable Type Len Pos Format Informat Label ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ...

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...

...properly: 52 datepart(month(B.date_of_birth))=month(A.MEM_BIRTH_DT) AND 53 datepart(YEAR(B.date_of_birth))=YEAR(A.MEM_BIRTH_DT) ************************************************************ log: PROC SQL; 45 ! 46 CREATE TABLE OUT.FOUND_HEALTH2 AS 47...

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...

...(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 Mean Std Total_score product1(M) Total score...

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...