topic Re: Array Task? in SAS Procedures

Array Task?

robertrao — Thu, 18 Apr 2013 16:43:48 GMT

Hi,

I have the following datasets;

Could some one tell me the right approach?

I have two tables

Table1

(no repeats by mrn)

e and i are dates.The order of these variables may vary...

like after i2 i might have e3 e4 e5 and then may come i3

and all of these may not necessarily have a date

mrn e1 i1 e2 i2

999 jun12012 june222012 aug012012 aug102012

Regards

Re: Array Task?

Reeza — Thu, 18 Apr 2013 17:49:29 GMT

Post some sample output please, including what happens if the e1 is between adm and discharge and i1 is not.

Also, what is stopping you from merging them? And what makes you think you need arrays if you're only looking at e1 and i1?

Re: Array Task?

allurai0412 — Thu, 18 Apr 2013 18:14:10 GMT

hi ,

we can use PROC FORMAT..!!

Regards

ALLU

proc format;
value trace_id
       '29MAY2012'D - < '12JUL2012'D = '101'
    '05AUG2012'D - '22AUG2012'D = '102'
    '01SEP2012'D - '05SEP2012'D = '102'
    ;
    RUN;

DATA TABLE1;
infile datalines truncover;
INPUT MRN E1 date9. i1 date9.;
format E1 trace_id.;
FORMAT i1 trace_id.;
datalines;
999 12jun201222JUN2012
;
run;

Re: Array Task?

Reeza — Thu, 18 Apr 2013 19:43:27 GMT

Example output?

Re: Array Task?

Reeza — Thu, 18 Apr 2013 21:24:51 GMT

1. Run a proc sql to merge all the data together.

2. Using a datastep create an array that is coded such as array dates(25) e1-e10 i1-15;

3. Use a do loop to go through each entry and if dates(i) between admit_date and discharge_date then new_id=visit_id.

Re: Array Task?

Tom — Fri, 19 Apr 2013 14:07:40 GMT

BETWEEN is an SQL language construct. You could use it in a WHERE statement , but not in an IF statement.

The equivalent SAS syntax would by

admit_date <= dates{i} <= dis_date

Re: Array Task?

Reeza — Fri, 19 Apr 2013 14:47:51 GMT

Create two arrays.

But it looks like they're different sizes, so what comparison do you want when you hit i12?