comparison of variable across data sets

Reply
Occasional Learner
Posts: 1

comparison of variable across data sets

Hi SAS community,

 

I have an issue regarding coding, I hope you can help me with.

I have two data sets, a and b, containing three variables, hospitals, patient_id and date. For each patient_id there are multiple dates, and due to some definitions regarding what classifies as a new entry, I need to weed out excessive observations, which translated, code-wise corresponds to something like:

data=a;

if patient_id in a = patient_id in b and dates in b-30 days<date in a <dates in b+30 days then same=1;

Else same=0;

 

Basically, what I am have trouble with referencing across data sets, since a and b should be kept separated.

 

Due to the information being sensitive, I cannot provide any concrete examples of data.

 

Hope you guys can help me out.

 

best,

Chen 

 

Super User
Posts: 17,784

Re: comparison of variable across data sets


chen70 wrote:

Hi SAS community,

 

Due to the information being sensitive, I cannot provide any concrete examples of data.

 


The data needs to be reflective of your situation, not actual data. You can make fake data, include at least one example of the different situations you'll encounter, ie no matches in either data set, duplicates, multiple duplicates.

 

Otherwise search on here for the 30 day readmission problem. 

 

 

 

 

Valued Guide
Posts: 2,174

Re: comparison of variable across data sets

Chen
Have a look at examples of PROC SQL queries in the online doc
That makes the a. and b. prefix notation available
Ask a Question
Discussion stats
  • 2 replies
  • 122 views
  • 0 likes
  • 3 in conversation