About danwarags

danwarags · ‎10-03-2016

I totally agree that the question was similar to the one posted by me before. But the difficult part is the table used before had unique values in the proc freq table statement. This time there are duplicate values for survey_number. This was little tricky for me.

danwarags · ‎10-03-2016

Thanks Patrick. I posted a similar question before. But, for that I did not have any duplicate values for the table statement used in proc freq. This question has duplicate values within each individual. Below is the code I used. data have; input id survey_number gift_name$; datalines; 1 121 doll 1 121 watch 1 121 wallet 1 122 doll 2 123 tv 2 123 mobile 2 122 Coffee cup 4 124 tv 4 123 wallet 4 122 watch 4 122 watch ; proc freq data= have noprint; table survey_number/out=countID; run; proc freq data=countID; table count/out=Want; run;

danwarags · ‎10-03-2016

Hello Everyone, I have a data set showing the number of Individuals who participated in different surveys. I want to know how many individuals participated in one survey, how many participated in 2 surveys, 3 surveys etc. I am also interested in knowing the number of gifts these individuals received. ID survey number Gift_name 1 121 doll 1 121 watch 1 121 wallet 1 122 doll 2 123 tv 2 123 mobile 2 122 Coffee cup 4 124 tv 4 123 wallet 4 122 watch 4 122 watch My output should look like below: Number of surveys Number of individuals Gifts unique_gifts 1 0 0 0 2 2 7 6 3 1 4 3 4 0 0 0 In the above table all the individuals participated in either 2 or 3 surveys. There were 2 individuals who participated in 2 surveys (ID- 1,2) and there was only one individual (ID-4) who participated in 3 surveys. The gifts should be summed up as shown in the output table (For individuals who participated in 2 surveys the gifts are summed up as: (4+3)=7. The unique gifts would be 6 (Because ID-1 got watch two times). Thank you!

danwarags · ‎10-03-2016

Thank you Patrick. This code worked.:-)

danwarags · ‎10-03-2016

Thank you so much Ksharp. This was the exact output I needed. But, the only problem is the output dataset shows higher standard deviation for age, which means that there are outliers that needs to be eliminated. I have never used proc robustreg before. I am a physician by profession, so have less stats background. Could you please guide me eliminating outliers in the below dataset. ID sales age 1 car 12 1 bike 12 1 truck 14 2 car 22 3 bike 34 3 bike 34 3 truck 35 6 bike 74 4 car 40 4 truck 41 5 bike 32 7 car 34 7 bike 35 7 plane 36 7 truck 37 8 bike 72 8 car 73 8 plane 73 8 truck 74 After eliminating outliers my output should look as below: No of vehicles No of IDs Avg Age std Age 1 3 2 1 3 2 4 2 I really appreciate your help. Thank you in advance.

danwarags · ‎10-02-2016

Hello Patrick, Thanks for quick reply. I tried using both strategies and nothing is working. I want the output as shown above. The merge statement is giiving values from the table B which I wont need. The left join statement I used is giving me different output I expected. Please correct my code if its wrong. data a; input ID sales$; datalines; 1 car 1 bike 1 truck 2 car 3 bike 3 bike 3 truck 6 bike 4 car 4 truck 5 bike ; data b; input ID sales$ age; datalines; 1 car 11 1 bike 12 2 car 23 2 bike 23 3 bike 24 6 bike 32 4 car 18 4 truck 19 5 bike 20 ; proc sort data= a; by id sales; run; proc sort data= b; by id sales; run; data want; merge a b; by id sales; run; proc sql; create table want2 as select a.*,b.age from a a left join b b on a.sales= b.sales; quit; Thanks!

danwarags · ‎10-02-2016

Hello Everyone, I have to datasets Dataset A and Dataset B. I want to join age to Table A using variables ID and sales. Table A Table B ID sales ID sales age 1 car 1 car 11 1 bike 1 bike 12 1 truck 2 car 23 2 car 2 bike 23 3 bike 3 bike 24 3 bike 6 bike 32 3 truck 4 car 18 6 bike 4 truck 19 4 car 5 bike 20 4 truck 5 bike The output should look like below: ID sales age 1 car 11 1 bike 12 1 truck . 2 car 23 3 bike 24 3 bike 24 3 truck . 6 bike 32 4 car 18 4 truck 19 5 bike 20 Thank you!

danwarags · ‎10-02-2016

Hello Everyone, Below dataset shows the automobile sales for each individual and the duration of time they spent using those vehicles. I want to create a table which shows number of individuals who bought 1 vehicle, 2 vehicles, 3 vehicles etc.. Also, I need to know average age of these individuals, %males, %females and average duration these individuals spent using those vehicles. Below is the sample dataset. Customer_ID sales age gender sdate edate 1 car 12 M 1/1/2001 1/12/2001 1 bike 12 M 1/2/2001 1/18/2001 1 truck 14 M 1/6/2003 1/8/2003 2 car 22 F 3/4/2001 3/8/2001 3 bike 34 M 2/4/2002 2/12/2002 3 bike 34 M 2/10/2002 2/24/2002 3 truck 35 M 2/14/2003 2/18/2003 6 bike 74 F 3/15/2003 3/18/2003 4 car 40 M 3/15/2003 3/18/2003 4 truck 41 M 3/20/2004 3/26/2004 5 bike 32 F 3/23/2001 3/29/2004 My output should look something like below. First column represent; number of vehicels sold . Second Column represents, how many such individuals bought these vehicles. Example: There was 1 sale for 3 subject IDs (ID-2,6,5), 2 sales for only one ID (ID-4) etc. Now I need find average age of individuals, %males, %females and average duration these individuals used these vehicles. No of vehicles No of Individuals Avg Age (Mean, SD) %males %females Avg duration (Mean, SD) 1 3 2 1 3 2 The average age of first row in the above table should be: (22+74+32)/3. But, there is an outlier 74 in this age. What is the best way to calculate average age if there is an outlier. Moreover, the third row has two individuals who had three sales. So, will the average age be (12+12+14+34+34+35)/6. How should I calculate. Guide me. Thank you in advance!

danwarags · ‎10-02-2016

Thanks Reeza. I really appreciate your help. The code worked. Given the start_date and End_date in the SAS format, how do I calculate the difference between the earliest start_date and late end_date within each ID. For example, I have a scenario as shown below: ID Start_date End_date Ddiff 1 1/1/2001 1/12/2001 17 1 1/2/2001 1/18/2001 1 1/6/2001 1/8/2001 2 3/4/2001 3/8/2001 4 3 2/4/2002 2/12/2002 20 3 2/10/2002 2/24/2002 3 2/14/2002 2/18/2002 4 3/15/2003 3/18/2003 11 4 3/20/2003 3/26/2003 I Should calculate Ddiff as mentioned in the above scenario. The Ddiff should be calculated in such a way that it should show the difference of early start_date and late end_date within each ID as shown above. Thank you!!

danwarags · ‎10-01-2016

Hello everyone, I am trying to calculate the difference between two dates which are in different format as shown below. The start date is in the format yyyymmdd and end date is in the format ddmmmyy:hh:mm:ss Sdate Edate 20010130 01JUN01:09:01:00 20030524 04AUG03:16:10:00 20010421 01JUL01:08:15:00 The output dataset should show the difference between two dates in days and months. The differene should include end date in calculation. The output dataset should show as below. NoDays 123 73 72 Thank you in advance!

danwarags · ‎09-29-2016

Hello all, I have a dataset with hundreds of observations. I wanted to know how many individual IDs had more than1 or 2 or 3.... sales. Here is my sample dataset. ID sales 1 car 1 truck 1 bike 1 plane 2 bike 2 car 2 motor 4 plane 4 bike 4 car 4 motor In the above dataset each Individual ID had either 4 sales (For 1st ID), 3 sales (For 2nd ID) or 4 sales (For 4th ID). I wanted to know how many individuals had 4 sale count and three sale count. My output should look something like this. Nsales Nindividuals 1 0 2 0 3 1 4 2 There were no Subject IDs with 1 or 2 sales count. So the first two rows are zero. There was 1 subject ID (ID-2) with 3 sales and 2 subject IDs (ID-1 and 4) with 4 sales. Thank you

danwarags · ‎09-07-2016

Hello Everyone, I have a dataset with datevalues as shown below. I am trying to filter the dates which fall in certain range. How should I code this. For example, for the below dataset I need the date values in between 2001-01-01 and 2004-12-31. Date ID 2000-12-28 1 2001-05-26 3 2002-06-12 4 1999-05-25 6 2001-01-05 7 2002-01-20 8 1998-05-17 5 2007-06-20 9 2008-04-26 10

danwarags · ‎09-02-2016

Woww. It worked when I set options MERGENOBY= NOWARN. Thank you Rick. Appreciate your help.

danwarags · ‎09-02-2016

Thanks for quick reply Rick. Please find my attached log: 284 dm 'clear log'; dm 'clear output'; 285 286 data have; 287 input ID; 288 datalines; NOTE: The data set WORK.HAVE has 5 observations and 1 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.01 seconds 294 ; 295 296 data ID; 297 if _N_=0 then set have nobs=N; 298 do i = 1 to N; 299 sortOrder = rand("Uniform"); 300 RANDOM_ID = 900000 + i; /* sequence of numbers */ 301 output; 302 end; 303 keep RANDOM_ID sortOrder ; 304 run; NOTE: DATA STEP stopped due to looping. NOTE: The data set WORK.ID has 5 observations and 2 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.01 seconds 305 306 proc sort data=ID; 307 by sortOrder; 308 run; NOTE: There were 5 observations read from the data set WORK.ID. NOTE: SAS sort was used. NOTE: The data set WORK.ID has 5 observations and 2 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 309 310 data Want; 311 merge Have ID(drop=sortOrder); 312 run; ERROR: No BY statement was specified for a MERGE statement. NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.WANT may be incomplete. When this step was stopped there were 0 observations and 2 variables. WARNING: Data set WORK.WANT was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.03 seconds Thanks!

danwarags · ‎09-02-2016

Hello Rick, Thank you so much for the code. This really helped me. The only thing I am finding hard is to run the last step (/*merge with original data*/). The error says that I need to specify BY statement. I need the ID variable and the random assigned variable in the same dataset. This is what I used to run the code. The last step gives me error saying I need to specify BY statement. How do I modify the last step. data have; input ID; datalines; 101 103 107 506 845 ; data ID; if _N_=0 then set have nobs=N; do i = 1 to N; sortOrder = rand("Uniform"); RANDOM_ID = 900000 + i; /* sequence of numbers */ output; end; keep RANDOM_ID sortOrder ; run; proc sort data=ID; by sortOrder; run; data Want; merge Have ID(drop=sortOrder); run; Thanks!

Online Status	Offline
Date Last Visited	‎01-25-2017 04:55 PM

Re: Counting the numbers from a table

Re: Counting the numbers from a table

Counting the numbers from a table

Re: Join two tables

Re: Calculating average age

Re: Join two tables

Join two tables

Calculating average age

Re: Difference between Two dates

Difference between Two dates

Re: Counting the numbers from a table

Re: Counting the numbers from a table

Re: Calculating average age

Re: Calculating average age

Re: Join two tables

Re: Counting the numbers from a table

Re: Counting the numbers from a table

Counting the numbers from a table

Re: Join two tables

Re: Calculating average age

Re: Join two tables

Join two tables

Calculating average age

Re: Difference between Two dates

Difference between Two dates

Counting the number of IDs

Date range by Year

Re: Assigning random numbers in a particular range

Re: Assigning random numbers in a particular range

Re: Assigning random numbers in a particular range