07-23-2013 04:29 PM
07-23-2013 05:12 PM
Yes it is. Because I am on my work computer right now and that is how they set up my desktop for the log in. The other is another log in from when I had another job but my current company will not let me use that. I have tried to log in on my home computer with this log in, but it is blocked. I guess employer related.
07-23-2013 05:15 PM
set pos_tinofc pos_tinop pos_tinip;
1 table has the info for office, 1 table has the info for outpatient, 1 table has info for inpatient. I need to report on all the data but I am trying to figure out how to get it in 1 row for it all. I tried creating a table and appending. Did same thing as above code. Tried joins but it dropped records.
07-23-2013 05:36 PM
The SET statement INTERLEAVES observations, so the resulting data set has N1 (n records in pos_tinofc) + N2 (pos_tinop) + N3 (pos_tinip) records.
Now if the only variable in common in the 3 data sets is STRATA, then the MERGE statement will work (I assume as data set has no more than one record per stratum).
merge pos_tinofc pos_tinop pos_tinip;
If your 3 data sets have other variables in common, then let us know.
07-23-2013 05:42 PM
Wish they would have the option in SAS forum to give correct answer to more than 1 person. I am an idiot. You know I knew this and for some reason I was just having one of those days. Thanks
Need further help from the community? Please ask a new question.