Hi,   Is it possible to calculate the standard deviation of a mean difference, knowing only the mean and SD for instrument 1 and mean and SD for instrument 2 (paired data)? Eg. Mean1=785 (SD1=337), mean2=897 (SD2=444). The mean difference is -112, but I do not have the SD of the mean difference. This is for meta-analysis purposes, where individual papers have provided incomplete data. Thanks!   GM ... View more

Hi,   I have switched computers. Both have been running SAS 9.4, with windows 10 (64). I now used SAS 9.4 (64). I am not certain whether the previous version was a 32 or 64-bytes version of SAS. My proc import code was working quite well for years and has now stopped working. I have read several postings and switched dbms=excel to dbms=xlsx as suggested. I still get the errors listed below.   proc import datafile="C:\Users\guill\Documents\Research\PRICE-1\Analysis\Electronic CRF - FINAL edit = AK pressors (1).xlsx" dbms=xlsx out=work.phlebo replace; sheet='eCRF'; scantext=yes; usedate=yes; scantime=yes; run; Log: 121 proc import datafile="C:\Users\guill\Documents\Research\PRICE-1\Analysis\Electronic CRF - FINAL 121! edit = AK pressors (1).xlsx" 122 dbms=xlsx 123 out=work.phlebo replace; NOTE: The previous statement has been deleted. NOTE: The previous statement has been deleted. NOTE: The previous statement has been deleted. 124 sheet='eCRF'; 125 scantext=yes; -------- 180 126 usedate=yes; ------- 180 127 scantime=yes; -------- 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 128 run; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.01 seconds cpu time 0.01 seconds I have also tried using a libname statement with pcfiles as per this blog: https://libguides.library.kent.edu/SAS/ImportData   This is the code and errors I got: libname myexcel pcfiles path="C:\Users\guill\Documents\Research\PRICE-1\Analysis\Electronic CRF - FINAL edit = AK pressors (1).xlsx" scantime=yes stringdates=no dbmax_text=2000; 129 libname myexcel pcfiles path="C:\Users\guill\Documents\Research\PRICE-1\Analysis\Electronic CRF - 129! FINAL edit = AK pressors (1).xlsx" 130 scantime=yes stringdates=no dbmax_text=2000; ERROR: Unable to locate pcfserver.exe. Please install PC Files Server. ERROR: Error in the LIBNAME statement. Any help would be most useful! Many thanks,   Guillaume ... View more

Hi,   I am trying to create a line graph for pressure measurements made a various time points. Each time point variable contains pressure measurements for each subject (eg. t1, t2, t3, t4, etc.). These time point variables should each form my x-axis. The pressure measurements within each variable should me my y axis. I then have an intervention coded 1/0, for which I would like to dichotomize the data, creating two line graphs.   I am hoping to plot means with error bars (SD or SE).   I have tried to look through posts and synthax guides but I am not finding a way to plot the x-axis as being each of my t1, t2, t3, t4 etc variables.   I am using 9.4.   Please help!   Guillaume Martel ... View more