I am trying to generate a list of Nursing Homes, including the number of licensed beds in each facility. In many cases there are different types of beds within a facility (e.g. Long term care, residential, ventilator). How would I suppress printing of the label (bed type description), if that type of bed does not exist for a given facility.
NUMBER_LTC - Number of Long-term care beds
NUMBER_RE - Number of Residential Beds
NUMBER_ASST - Number of Assisted Living Beds
Please excuse the fact that the headings and the data items are not lined up. I did the best that I could in cutting and pasting this data from an EXCEL spreadsheet.
The following is a sample of the output for selected facilities:
NAME CITY NUMBER_LTC NUMBER_RE NUMBER_ASS
ALLENDALE ALLENDALE 120
BERGEN CTY ROCKLEIGH 110
BERGEN REG PARAMUS 562
BRISTOL MANOR ROCHELLE PARK 240 135
BROOK WOOD SADDLE BROOK 52
CHRISTIAN HTH WYCKOFF 252 92
CLIFF HOUSE ENGLEWOOD CLIFFS 36
COUNTY MANOR TENAFLY 69
DELLRIDGE PARAMUS 96
DUNROVEN CRESSKILL 100
EMERSON EMERSON 155
HIGHLAND ALLENDALE 18
HOME ARMENIAN EMERSON 78
INGLEMOOR CENTER ENGLEWOOD 62
INGLESIDE CENTER OLD TAPPAN 44
JEWISH HOME - BERG RIVERVALE 50
JEWISH HOME ROCK ROCKLEIGH 180
MAPLE GLEN CENTER FAIR LAWN 161
N.J. VETS MEM PARAM PARAMUS 336
OAKLAND CC OAKLAND 215
PARAMUS HCC PARAMUS
PINE REST HCC PARAMUS 122
PROSPECT HEIGHTS CC HACKENSACK 180 30
REGENT CARE CENTER HACKENSACK 180
RIDGEWOOD CENTER RIDGEWOOD 90
SADDLE BROOK CONV SADDLE BROOK 52
SUNBRIDGE ORADELL ORADELL 154
SUNBRIDGE WOODCRES NEW MILFORD 236
TEANECK NURS HOME TEANECK 107
THE ACTORS' FUND ENGLEWOOD 67
THE HERITAGE-NORWOOD NORWOOD 180 85
THE PLZ REG-PK RIDGE PARK RIDGE 204
TRANS CC-PASCACK WESTWOOD 16
VALLEY HCC WESTWOOD 120
VAN DYK'S NURSING RIDGEWOOD 96
WELNGTON HALL HACKENSACK 123
WOODCLIFF LK CC WOODCLIFF LAKE 114
NUMBER_LTC - Number of Long-term care beds
NUMBER_RE - Number of Residential Beds
NUMBER_ASST - Number of Assisted Living Beds
Please excuse the fact that the headings and the data items are not lined up. I did the best that I could in cutting and pasting this data from an EXCEL spreadsheet.
The following is a sample of the output for selected facilities:
NAME CITY NUMBER_LTC NUMBER_RE NUMBER_ASS
ALLENDALE ALLENDALE 120
BERGEN CTY ROCKLEIGH 110
BERGEN REG PARAMUS 562
BRISTOL MANOR ROCHELLE PARK 240 135
BROOK WOOD SADDLE BROOK 52
CHRISTIAN HTH WYCKOFF 252 92
CLIFF HOUSE ENGLEWOOD CLIFFS 36
COUNTY MANOR TENAFLY 69
DELLRIDGE PARAMUS 96
DUNROVEN CRESSKILL 100
EMERSON EMERSON 155
HIGHLAND ALLENDALE 18
HOME ARMENIAN EMERSON 78
INGLEMOOR CENTER ENGLEWOOD 62
INGLESIDE CENTER OLD TAPPAN 44
JEWISH HOME - BERG RIVERVALE 50
JEWISH HOME ROCK ROCKLEIGH 180
MAPLE GLEN CENTER FAIR LAWN 161
N.J. VETS MEM PARAM PARAMUS 336
OAKLAND CC OAKLAND 215
PARAMUS HCC PARAMUS
PINE REST HCC PARAMUS 122
PROSPECT HEIGHTS CC HACKENSACK 180 30
REGENT CARE CENTER HACKENSACK 180
RIDGEWOOD CENTER RIDGEWOOD 90
SADDLE BROOK CONV SADDLE BROOK 52
SUNBRIDGE ORADELL ORADELL 154
SUNBRIDGE WOODCRES NEW MILFORD 236
TEANECK NURS HOME TEANECK 107
THE ACTORS' FUND ENGLEWOOD 67
THE HERITAGE-NORWOOD NORWOOD 180 85
THE PLZ REG-PK RIDGE PARK RIDGE 204
TRANS CC-PASCACK WESTWOOD 16
VALLEY HCC WESTWOOD 120
VAN DYK'S NURSING RIDGEWOOD 96
WELNGTON HALL HACKENSACK 123
WOODCLIFF LK CC WOODCLIFF LAKE 114
