cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
mona4u
‎10-06-2022
  • 205 Posts
  • 112 Likes Given
  • 2 Solutions
  • 3 Likes Received

merging data sets

by Lapis Lazuli | Level 10 in SAS Programming
‎03-15-2018 11:35 AM
‎03-15-2018 11:35 AM
I'm trying to merge two data sets and I can't get the result that I want    this is my code  proc sort data=vwr2 out=vwr3; by protocol protocol1; run; proc sort data=pqr2 out=pqr3; by protocol; run;   data mmm; merge pqr3 vwr3; by protocol; run;   this is the two datasets and the result Obs Protocol_No visit_status Workflow_Status protocol protocol1     1 A3921104 Locked Complete 1104 1104     2 A3921104 Locked Complete 1104 1104                     Obs Site_Number Category protocol         1 A3921104 1079 Other 1104         2 A3921104 1079 Other 1104         3 A3921104 1079 Other 1104         4 A3921104 1079 Other 1104         5 A3921104 1079 Other 1104         6 A3921104 1134 Other 1104         7 A3921104 1134 Other 1104         8 A3921104 1134 Other 1104                                                         Obs Site_Number Category protocol Protocol_No visit_status Workflow_Status protocol1 1 A3921104 1079 Other 1104 A3921104 Locked Complete 1104 2 A3921104 1079 Other 1104 A3921104 Locked Complete 1104 3 A3921104 1079 Other 1104 A3921104 Locked Complete 1104 4 A3921104 1079 Other 1104 A3921104 Locked Complete 1104 5 A3921104 1079 Other 1104 A3921104 Locked Complete 1104 6 A3921104 1134 Other 1104 A3921104 Locked Complete 1104 7 A3921104 1134 Other 1104 A3921104 Locked Complete 1104 8 A3921104 1134 Other 1104 A3921104 Locked Complete 1104   this the my aimed result  Obs Site_Number Category protocol Protocol_No visit_status Workflow_Status protocol1 1 A3921104 1079 Other 1104 A3921104 Locked Complete 1104 2 A3921104 1079 Other 1104 A3921104 Locked Complete 1104 3 A3921104 1079 Other 1104 . . . . 4 A3921104 1079 Other 1104 . . . . 5 A3921104 1079 Other 1104 . . . . 6 A3921104 1134 Other 1104 . . . . 7 A3921104 1134 Other 1104 . . . . 8 A3921104 1134 Other 1104 . . . .   ... View more

Re: report from different variables in diff data sets

by Lapis Lazuli | Level 10 in ODS and Base Reporting
‎03-15-2018 11:23 AM
‎03-15-2018 11:23 AM
This is really helpful  even though I'm still learning proc sql  ... View more

Re: report from different variables in diff data sets

by Lapis Lazuli | Level 10 in ODS and Base Reporting
‎03-13-2018 04:24 PM
‎03-13-2018 04:24 PM
combining the data sets is hard to me bc there is no matching to combine them  ... View more

report from different variables in diff data sets

by Lapis Lazuli | Level 10 in ODS and Base Reporting
‎03-13-2018 04:07 PM
‎03-13-2018 04:07 PM
I want to produce a report which looks like this table I eliminate part of the table to make the explanations easier  Readable time point= sum of varaiable2(which is in data set 2)- sum of variable1 (which is in data set 1) time point read= sum of variable1 (which is in data set 1) I want to create the report and I want to know if I can create new data set that contains macros of the computation  then create proc report step to output it  Please suggest to me the best way to do it           Readable Time Points: 8     Time Points Read 29                       ... View more

Re: Getting around insufficient space issues

by Lapis Lazuli | Level 10 in SAS Programming
‎03-13-2018 03:53 PM
‎03-13-2018 03:53 PM
I asked the IT dept to add a space to my remote disck ... View more

Re: summarize data

by Lapis Lazuli | Level 10 in SAS Programming
‎03-13-2018 03:38 PM
‎03-13-2018 03:38 PM
I just found a way by using retain statement ... View more

Re: summarize data

by Lapis Lazuli | Level 10 in SAS Programming
‎03-13-2018 03:37 PM
‎03-13-2018 03:37 PM
this code doesn't summarize that data correctly.  appreciate your try ... View more

Re: summarize data

by Lapis Lazuli | Level 10 in SAS Programming
‎03-13-2018 03:37 PM
‎03-13-2018 03:37 PM
this code doesn't summarize that data correctly  ... View more

Re: summarize data

by Lapis Lazuli | Level 10 in SAS Programming
‎03-13-2018 01:59 PM
‎03-13-2018 01:59 PM
I just added the code ... View more

Re: summarize data

by Lapis Lazuli | Level 10 in SAS Programming
‎03-13-2018 01:56 PM
‎03-13-2018 01:56 PM
I need to do it in the data step  ... View more

Re: summarize data

by Lapis Lazuli | Level 10 in SAS Programming
‎03-13-2018 01:53 PM
‎03-13-2018 01:53 PM
that's not right I want the number of distinct patient_name for each distinct timepoint  ... View more

summarize data

by Lapis Lazuli | Level 10 in SAS Programming
‎03-13-2018 01:30 PM
‎03-13-2018 01:30 PM
Hi,  I have problem with summarizing my data. I need to count how many distinct patient_Name for each distinct time point  if date_completed ne .  I tried my code put I really missed up with it.  I need you to suggest an edit to my code.   proc sort data=readert1; by patient_name TimePoint; run; data readert2; set readert1; by patient_name timepoint; keep Patient_Name TimePoint Date_Completed ctime; if date_completed ne . and first.Patient_name then do; ctime=0; end; ctime+1; if date_completed ne . and last.timepoint ; this is the data that I need to summarize     Obs Patient_Name Timepoint Date_Completed1234567891011121314151617181920212223242526272829303132333435363738394041 W1490.1045001 Baseline 15DEC2017 W1490.1056002 Baseline 13NOV2017 W1490.1056002 Baseline 13NOV2017 W1490.1056002 Week 16 15NOV2017 W1490.1056002 Week 16 15NOV2017 W1490.1056002 Week 24 31JAN2018 W1490.1056002 Week 24 31JAN2018 W1490.1056002 Week 8 15NOV2017 W1490.1056002 Week 8 15NOV2017 W1490.1056003 Baseline 13NOV2017 W1490.1056003 Week 8 13NOV2017 W1490.1056005 Baseline 13NOV2017 W1490.1056005 Week 16 13NOV2017 W1490.1056005 Week 24 25DEC2017 W1490.1056005 Week 8 13NOV2017 W1490.1056006 Baseline 12DEC2017 W1490.1056006 Week 16 12DEC2017 W1490.1056006 Week 24 12JAN2018 W1490.1056006 Week 8 12DEC2017 W1490.1068001 Baseline 13NOV2017 W1490.1068001 Baseline 13NOV2017 W1490.1068001 Week 16 13DEC2017 W1490.1068001 Week 16 13DEC2017 W1490.1068001 Week 24 25DEC2017 W1490.1068001 Week 24 25DEC2017 W1490.1068001 Week 32 22FEB2018 W1490.1068001 Week 32 22FEB2018 W1490.1068001 Week 8 13NOV2017 W1490.1068001 Week 8 13NOV2017 W1490.1068002 Baseline . W1490.1068002 Week 8 . W1490.1089001 Baseline 15NOV2017 W1490.1089001 Week 16 15NOV2017 W1490.1089001 Week 24 18DEC2017 W1490.1089001 Week 32 10JAN2018 W1490.1089001 Week 8 15NOV2017 W1490.1089002 Baseline 15DEC2017 W1490.1089003 Baseline 28DEC2017 W1490.1100002 Baseline 31JAN2018 W1490.1134001 Baseline . W1490.1134004 Baseline 30JAN2018 ... View more

Re: Getting around insufficient space issues

by Lapis Lazuli | Level 10 in SAS Programming
‎03-12-2018 02:09 PM
‎03-12-2018 02:09 PM
I'm using sas data sets in the help icon that already exist in sas base  ... View more

Re: Getting around insufficient space issues

by Lapis Lazuli | Level 10 in SAS Programming
‎03-12-2018 01:43 PM
‎03-12-2018 01:43 PM
I use windows environment  ... View more

Getting around insufficient space issues

by Lapis Lazuli | Level 10 in SAS Programming
‎03-12-2018 09:45 AM
‎03-12-2018 09:45 AM
Hi,  I got this problem after trying to run my sas codes and I can't find a solution to solve it. I use Windows environment    insufficient space in file work ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-06-2022 12:13 PM
Likes given to
Likes from
View All
Quick links