topic Re: comparison of variable across data sets in SAS Programming

comparison of variable across data sets

chen70 — Fri, 20 Jan 2017 01:55:15 GMT

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

Re: comparison of variable across data sets

Reeza — Fri, 20 Jan 2017 02:14:35 GMT

@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.

Re: comparison of variable across data sets

Peter_C — Fri, 20 Jan 2017 22:35:46 GMT

Chen
Have a look at examples of PROC SQL queries in the online doc
That makes the a. and b. prefix notation available