I AM USING DEVELOPER STUDIO AND I AM TRYING TO COMBING 4 FIELDS INTO ONE. YEARS IN PRACTICE 'YEARS' IS THE FIELD I WANT TO CREATE FROM NYEARS (NURSES) DYEARS (DOCTORS) AND PHYEARS (PHARMACISTS). THEY ARE SEPARATED IN THE DATA FILE BUT CONTAIN THE SAME TYPE OF INFORMATION CODED THE EXACT SAME WAY AND I NEED TO COMBINE THEM IS THIS POSSIBLE. i CAN WORK WITH GUI, BUT PREFER CODING!

THANKS,
KEMA

This message has been edited. Last edited by: Kerry,

Hi,

By combining do you mean adding up all the years to arrive at the total number of years:

a simple define or compute should do the trick:

 
DEFINE FILE FILENAME
TOTAL1/I4 = FLD1+FLD2+FLD3+FLD4;
END
TABLE FILE FILENAME
PRINT
TOTAL1 AS 'This is the Total Years'
END

thanks
Sashanka

Combine could be the way Severus does it but you might want to see the result in an other way.
concatenate would be on

first convert the 4 year fields to alpha value and then make one long string of it.

NO THE ANSWERS ARE CODED SO THAT 2= '2 TO 10 YEARS' AND 3= '11-35 YEARS'. THE ANSWERS FROM DOCTORS, NURSES AND PHARMACISTS ARE IN DIFFERENT FIELDS. I WANT TO COMBINE THEM SO THAT WHEN I RUN THE REPORT IT WILL SHOW THE COUNT ACCROSS THE SPECIALTIES BY THE ABOVE LIMITS.

Are records for Doctors, Nurses and Pharmacists al on the same row?

Can you provide some example output? Just type out how you want the report to look like.

Something like?

NAME YEARS OF SERVICE
2-10 11-35
---------------------------------------------
Jane D. 3
John D. 12
Jim D. 2
----------------------------------------------
Total 5 12

DOC PHARM NURSE

2-10 25 10 5

11-35 60 26 9

36+ 21 15 0

tHIS IS A HORRIBLE REPRESENTATION...BUT I NEED THE REPORT TO LOOK SOMETHING LIKE THIS.

that is not very difficult

have you ever used the MORE functionality?

DEFINE FILE XXXX
YEARCODE=the field for nurses
GROUPCODE/A1='N';
END
TABLE FILE XXXX
COUNT somefield 
BY YEARCODE
BY GROUPCODE
ON TABLE HOLD AS NURSES
END

DEFINE FILE XXXX
YEARCODE=the field for doctors
GROUPCODE/A1='D';
END
TABLE FILE XXXX
COUNT somefield 
BY YEARCODE
BY GROUPCODE
ON TABLE HOLD AS DOCTORS
END
...and so on
then.
TABLE FILE NURSES
PRINT *
ON TABLE HOLD AS COMBITABLE
MORE
FILE DOCTORS
....
END
TABLE FILE COMBITABLE
SUM field
BY YEARCODE
ACROSS GROUPCODE
END

Seems like you may be looking for counts instead of sums? Maybe something like this:

DEFINE FILE x
 YEARS_IN_PRACTICE/A11 = IF (NYEARS EQ 2) OR (DYEARS EQ 2) OR (PHYEARS EQ 2) THEN '2-10 Years' ELSE
                         IF (NYEARS EQ 3) OR (DYEARS EQ 3) OR (PHYEARS EQ 3) THEN '11-35 Years' ELSE '+36 Years';
 COUNT_NURSES/I5C      = IF (NYEARS  NE 0) THEN 1 ELSE 0 ;
 COUNT_DOCTORS/I5C     = IF (DYEARS  NE 0) THEN 1 ELSE 0 ;
 COUNT_PHARMACISTS/I5C = IF (PHYEARS NE 0) THEN 1 ELSE 0 ;
END
-*
TABLE FILE x
 SUM
  COUNT_NURSES         AS '# of,Nurses'
  COUNT_DOCTORS        AS '# of,Doctors'
  COUNT_PHARMACISTS    AS '# of,Pharmacists'
 BY YEARS_IN_PRACTICE  AS 'Years in,Practice'
END

Thank you very much, it looks like one of these will work.

Kema