Hi I have a list of chart numbers for a chart review.  I used the retain seed methodology to produce a randomized list which nicely split the data out equally among discharge months and patient services to replicate the approximate percentages of the entire database. However, what if I want to manipulate the volumes per patient service i.e. so that I get less newborn/obstetric cases and a higher volume of medicine charts?  Thanks very much. ... View more

Hello I have a data set of patient data with an original and unique ID number per visit.  Occasionally the data is corrected so correction files are produced.   THese corrections could include visits not previously submitted and the corrections may only be for one data element.  What I would like to have happen is that any new abstracts will be added to the original data set from corrections and any data elements from corrections be updated in submissions. The original file is "sub" and the corrected file is "corr".  Sub has 1506 records and corr has 13 but when I used update the subsequent dataset was 1065 so it didn't work as planned.  The code I used was: data import_results; update work.sub work.corr; by Unique_Key; run; What function should I be using to get this to work as I'd like?  Thanks very much. ... View more

Hello I'm not even sure this is the right community so I apologize if I'm incorrect. I have a dataset that I import into SAS.  The data is quite large with one line of data being a single patient visit.  What I would like to do is export the data to Excel but where one patient visit is on one Excel worksheet in the format I require.  For example, in cell A2 I would like the word "chart number" and then the actual chart number to be in cell B2.  Diagnoses that are currently in wide format to be exported in long format with Diagnosis 1 thru 20 showing in column A with the diagnosis prefix in column C, diagnosis in column D etc. Is it possible to map in this fashion with only having Base SAS?  Thanks very much.  ... View more

Hello I am using SAS 9.1.  I have a hospital data set where one abstract is one row of data.  I was able to figure out how to extract the multi-occurring fields like diagnosis or procedure using the following: DATA have; set mylib.data_2011; keep chartno acctno sepdate diagcde1-diagcde25; RUN; proc sort data=have out=have_sort; by acctno chartno; run; proc transpose data=have_sort out=need(rename=col1=dxcode);    by acctno chartno sepdate;    var diagcde1-diagcde25;    run; data Dx_List;       set need;       format sepdate ddmmyy10.;        where dxcode ne ""; run; With hospital there are 25 possible diagnoses that could be coded but not every patient will have 25 diagnoses but in the transpose step it assigns diagcde1-diagcde25 for all cases.  My last step for Dx_List is to remove the blanks and everything is working well. But how do I introduce other variables?  For instance, I want to also include diagtyp, diagpre, and diagclust which all also have 25 possible entries.  Also, for the code above, it creates a column called "Name of Former Variable" which lists diagcde1-diagcde25 - how do I change that field?  For instance, I would like it to show as occurrence number instead of this text field.  In other words take out the diagcde portion of the field to leave the #. Any and all assistance greatly appreciated - thanks. ... View more

Hello I'm using SAS 9.1. I imported data from the hospital software system where one line of data is one patient visit. What I want to do is, using the health card number, show # of readmits per patient within my organization (which is comprised of many hospitals). I am assuming I'll need to sort the data in discharge date order so that I can calculate current admit date with previous discharge date to see if there was a readmit. I'll want to know # of readmits in 7 days, 14 days, 21 days, 30 days and greater than 30 days PER that one patient. How would I also be able to add other information per the readmit i.e. main diagnosis etc.? Is this possible and if so, how? Thanks. ... View more

Hi I am using SAS 9.1 and importing a .txt file using infile and input statements. I am then exporting the file to an MS-Access database. I've got everything figured out except the time fields. Each time field in the file is in a time increment of a 24 hour clock but without the colon i.e. 2130, 1055, 1544. How do I import so that SAS recognizes it as a time? What format do I then use upon export? Thanks for any and all assistance. ... View more

Hi I am using SAS 9.1 with Service Pak 4 and whenever I try to export a data set to MS-Access or Excel I get the error message: Error: Connect: (and then tiny square box) Error: Error in Libname Statement Note that I just recently renewed my SAS license and I didn't have this problem prior to that (meaning it shouldn't be the code I'm using). Thanks for any and all assistance. ... View more