09-01-2015
samchat
Calcite | Level 5
Member since
10-07-2012
- 14 Posts
- 0 Likes Given
- 0 Solutions
- 0 Likes Received
-
Latest posts by samchat
Subject Views Posted 1528 07-10-2014 05:57 AM 1656 07-09-2014 09:59 PM 8287 03-28-2014 05:23 PM 10420 03-27-2014 07:38 PM 29538 03-27-2014 07:28 PM 5129 03-03-2014 07:13 PM 5107 03-03-2014 02:44 PM 5129 03-03-2014 02:43 PM 5129 03-03-2014 02:41 PM 5107 03-03-2014 02:37 PM -
Activity Feed for samchat
- Posted Re: Question on a macro program meaning on SAS Programming. 07-10-2014 05:57 AM
- Posted Question on a macro program meaning on SAS Programming. 07-09-2014 09:59 PM
- Posted Re: Use of LOCF, BOCF and WOCF on SAS Health and Life Sciences. 03-28-2014 05:23 PM
- Posted Use of LOCF, BOCF and WOCF on SAS Health and Life Sciences. 03-27-2014 07:38 PM
- Posted Re: Difference between itt and safety populations on SAS Health and Life Sciences. 03-27-2014 07:28 PM
- Posted Re: Merging two datasets on SAS Procedures. 03-03-2014 07:13 PM
- Posted Re: Merging two datasets on SAS Procedures. 03-03-2014 02:44 PM
- Posted Re: Merging two datasets on SAS Procedures. 03-03-2014 02:43 PM
- Posted Re: Merging two datasets on SAS Procedures. 03-03-2014 02:41 PM
- Posted Re: Merging two datasets on SAS Procedures. 03-03-2014 02:37 PM
- Posted Re: Merging two datasets on SAS Procedures. 03-03-2014 02:36 PM
- Posted Merging two datasets on SAS Procedures. 03-02-2014 05:54 PM
- Posted Difference between itt and safety populations on SAS Health and Life Sciences. 03-02-2014 05:46 PM
- Posted Difference between itt and safety populations on SAS Health and Life Sciences. 03-02-2014 05:41 PM
07-10-2014
05:57 AM
It looks like the program is indicating to go to a specified directory, check the files (possibly log files) and check the files for errors.
... View more
07-09-2014
09:59 PM
Hi All, I came across a macro, and I believe I got the basic understanding of the program, but would like some confirmation. datalogread; length file $256 dye 8 dte1 8 directory $256; format dte datetime; keep file dye dte1 directory; length filrf filerfb $8; directory =‘&directory’; rc1=filename(filrf,directory); opdir=dopen(filrf); memcount=dnum(opdir); if opdir <=0 then put ‘ERROR: Unable to open log folder.’; do i=1 to memcount; file=dread(opdir,i); rc2=filename(filrfb,catx(‘\’,directory,file)); fid=fopen(filrfb); dte=input (finfo(fid,’Create Time’),datetime.); dte1=dte; if dye >=&lastrun then output; rc3=fclose(fid) rc4=filename(filrfb); end; rc5=dclose(opdir); run; Would appreciate another pair of eyes, to help me understand this program. Your help on this is greatly appreciated. Thanks You.
... View more
03-27-2014
07:38 PM
Hi All, Had a question about the use of LOCF, BOCF and WOCF when working on clinical trials data. When and why are they used. More specifically, is there a sample code/data available that I may be able to copy and check the process real time.Thanks for your help in advance. -Sam
... View more
03-27-2014
07:28 PM
Thank you Jag!!
... View more
03-03-2014
07:13 PM
Hi Tom, Thanks for pointing the fact that the IF statement points at an intersection of the two data sets... So I guess in my code, SAS only looked for where the two variables were aligned in both the data sets, and output that number of obs. Hence the 288 obs. -Sam
... View more
03-03-2014
02:44 PM
Hi Statdork, Thanks for the response. I have posted the code in a lower post for review.
... View more
03-03-2014
02:43 PM
Hi Tom. thanks for speedy response.Your explanation was very helpful.
... View more
03-03-2014
02:41 PM
Thanks Reeza for the speedy response. I was expecting a one to one merge. However, after altering the code a bit, I did manage to have a dataset with 768 obs after the merge. However, I still don't understand what happened the first time, where there was 288 obs in after the merge. At the very least I would have expected 2x 768. What would have made SAS drop 480 obs?
... View more
03-03-2014
02:37 PM
Your are absolutely correct Authur, there is no proc merge, that was an error, I was using the merge in a datastep. Thanks for the correction.
... View more
03-03-2014
02:36 PM
Thank you for your help Below is the code: tab1 and tab2 has 768 *creating srno using automatic _N_ variable to perform merge; DATA tab1; SET raw.tab1; srno=_N_; RUN; *sort tab1 dataset by var1 and srno for merge; PROC SORT DATA=tab1 OUT=sr_tab1; BY var1 srno; RUN; *creating varible srno using automatic _N_ to create a common variable; DATA tab2; SET raw.tab2; srno=_N_; RUN; *sort tab2 dataset by var1 and srno for merge; PROC SORT DATA=tab2 OUT=sr_tab2; BY var1 srno; RUN; *merging datasets across var1 and srno variables; DATA tabf; MERGE sr_tab1 (IN=a) sr_tab2 (IN=b) ; BY var1 srno; IF a AND b; RUN;
... View more
03-02-2014
05:54 PM
Working on merging two data sets with two identical variables. Each data set contains 768 observations. After using a proc merge, I got 288 observations. Did I do anything wrong? how many observations should ideally be in the final/merged data set? -Sam
... View more
03-02-2014
05:46 PM
Hello, I am a newbie here and needed your help. Can anyone please let me know the difference between "intent to treat" (itt) and safety populations? I was in the process of flagging some data which I was working on, and got stuck not knowing the difference. Thanks for your help. -Sam
... View more
03-02-2014
05:41 PM
Hello, I am a newbie here and needed your help. Can anyone please let me know the difference between "intent to treat" (itt) and safety populations? I was in the process of flagging some data which I was working on, and got stuck not knowing the difference. Thanks for your help. -Sam
... View more