About strqimr

strqimr · ‎12-26-2018

It worked perfectly. Thanks a ton.

strqimr · ‎12-26-2018

Yes mate, missing values are causing problem. If we have more than one available values (say we have tum1 and tum2), and both are negative, then homogeneity should be 1. If one is positive and other one is negative, then homogeneity should be 2. If all the values are missing or if only one value is available, then I would code them as 3. Can you help me with that? Cheers STR

strqimr · ‎12-26-2018

Hi Daniel, Unfortunately, this code doesn't give me something I wanted. Running the code gives "homogeneity"=2 for all the observation, may be because of the missing values in Tum4. I want to create homogeneity based on the available info. I know I have some observation with only one value (ID-9), I want them to be coded as 3. I wanted something like the following: Thanks in advanced. I appreciate your help. Happy New Year. STR

strqimr · ‎12-25-2018

Hello Guys, I have the following four variables. Based on their available values I want to create another variable. The conditions are like: if all the available values of tum1, tum2, tum3 and tum4 are equal/same the new variable "homogeneity"=1; if at least one of the values differ then "homogeneity"=2. I appreciate your help. Cheers

strqimr · ‎11-21-2018

Hi Guys, Good afternoon from Australia. I was trying to run a trajectory modelling using the following syntax: PROC TRAJ DATA=QTCSTraj OUTPLOT=OP OUTSTAT=OS OUT=OF OUTEST=OE ITDETAIL ALTSTART; ID StudyCODE; VAR BODYSHAPE5 BODYSHAPE10 BODYSHAPETEEN BODYSHAPE20 BODYSHAPE30 BODYSHAPE40 BODYSHAPE50 BODYSHAPE60 BODYSHAPE70; INDEP M1-M9; MODEL CNORM; NGROUPS 2; MIN 1; MAX 9; ORDER 1 1 ; RUN; But it comes with : ERROR: Floating Point Overflow. ERROR: Termination due to Floating Point Exception Google says this error is subjected to exceptionally large or small numbers, which I don't have in my data. Can you help me why this is not running? Cheers Sabbir

strqimr · ‎11-20-2018

Hi Guys, Good afternoon from Australia. I was trying to run a trajectory modelling using the following syntax: PROC TRAJ DATA=QTCSTraj OUTPLOT=OP OUTSTAT=OS OUT=OF OUTEST=OE ITDETAIL ALTSTART; ID StudyCODE; VAR BODYSHAPE5 BODYSHAPE10 BODYSHAPETEEN BODYSHAPE20 BODYSHAPE30 BODYSHAPE40 BODYSHAPE50 BODYSHAPE60 BODYSHAPE70; INDEP M1-M9; MODEL CNORM; NGROUPS 2; MIN 1; MAX 9; ORDER 1 1 ; RUN; But it comes with : ERROR: Floating Point Overflow. ERROR: Termination due to Floating Point Exception Google says this error is subjected to exceptionally large or small numbers, which I don't have in my data. Can you help me why this is not running? Cheers Sabbir

strqimr · ‎05-13-2018

Thanks

strqimr · ‎05-13-2018

Thanks

strqimr · ‎05-11-2018

Hi guys, I am working on a dataset with participants having multiple rows. I want to know if any participant have used a specific medicare item number more than once in a same day. For example participant T10002 have used "36" twice in the same date (3rd and 4th rows). Thanks mates

strqimr · ‎03-07-2018

Many Thanks

strqimr · ‎03-06-2018

Hi folks, I am working on a dataset (have) with each id has multiple rows. I wanna delete the ids for which at least one value of variable diffdate is less than 60. I am struggling with the proper condition. The following are the sample "have" and "want" datasets. Thanks in advanced.

strqimr · ‎02-27-2018

Many Thanks

strqimr · ‎01-30-2018

Hi guys, I am working on a data-set containing multiple row for each studycode. there are other variables namely atc_code and date_of_supply. I want to indicate those studycodes whose consecutive date_of _supply for a specific atc group (several atc_code constitutes a group. e.g: C100BS, C11BD4, C10AA01, C112KN CONSTITUTES ONE ATC GROUP ) is less than say 60 days. I WANT IT ALL IN A SINGLE FILE. CAN ANYONE HELP ME OUT? SAMPLE XLS IS ATTACHED

strqimr · ‎01-24-2018

Thanks.

strqimr · ‎01-24-2018

Hi, I AM WORKING ON A SAS DATA SET CONTAINING 1999 IDs. MOST OF THEM CONTAINS MULTIPLE ROWS (APPROXIMATELY 100000 ROWS IN TOTAL ). THERE IS ANOTHER VARIABLE IN THE DATA SET NAMED "HISTORY" HAVING VALUES "Y" AND "N". I WANT TO DELETE THE IDs WHO HAVE ONLY ONE ROW AND HISTORY VALUE "Y". I AM NEW SAS USER AND COULDN'T FIGURE OUT HOW TO DO THIS. PLEASE HELP ME. ATTACHED IS A SAMPLE FILE.

Online Status	Offline
Date Last Visited	‎12-27-2018 12:08 AM

Re: Creating a new variable based on the values of other variables

Re: Creating a new variable based on the values of other variables

Re: Creating a new variable based on the values of other variables

Creating a new variable based on the values of other variables

'ERROR: Floating Point Overflow.' in PROC TRAJ procedures

'Floating Point Overflow.' in PROC TRAJ

Re: Counting the number of items within same date

Re: Counting the number of items within same date

Counting the number of items within same date

Re: Deleting rows with condition

Re: Creating a new variable based on the values of other variables

Re: Counting the number of items within same date

Re: Compare Two Datasets and Remove Duplicates

Re: Merging data sets one having multiple data lines

Re: Creating a new variable based on the values of other variables

Re: Creating a new variable based on the values of other variables

Re: Creating a new variable based on the values of other variables

Creating a new variable based on the values of other variables

'ERROR: Floating Point Overflow.' in PROC TRAJ procedures

'Floating Point Overflow.' in PROC TRAJ

Re: Counting the number of items within same date

Re: Counting the number of items within same date

Counting the number of items within same date

Re: Deleting rows with condition

Deleting rows with condition

Re: How to calculate lag date according to different category of a var...

How to calculate lag date according to different category of a variabl...

Re: Deleting an ID with single row from a dataset containing multiple ...

Deleting an ID with single row from a dataset containing multiple rows...