Recent content by irinnew

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