Wow, thank you! I tried the last datastep you shared (one w/o the length statement) and it worked and probably solved some other issues I wasn't aware of. ... View more

Thank you, this is a great idea. ... View more

Sorry, I just want to make sure I understand correctly.   Does this mean I should use an infile statement under the data step?   So it would be something like....   data test; length var1 $ 30 var2 $ 5 ... ; infile "C:....filename.txt delimiter ='|' firstobs=2 dsd; input var1 $ var2 $ var3 var4....; format var3 dollar20.2 var4 dollar20.2; run; ... View more

Thank you for that. I just sent an email to Tech Support - I didn't know that was an option before. ... View more

The dataset looks something like the table below. There are more observations (~3000). If a value has more than one value within a cell, then it's treated as one value - meaning, a value of "Cardiology, Oncology" would need to be exported into ["Cardiology, Oncology"] on the JSON file.     plan_type provider_type provider_group_affiliation provider_group_website TIN clinic_name clinic_address clinic_city clinic_state clinic_zipcode clinic_phone_number provider_name providerNPI provider_category specialties languages_spoken accepting telehealth_available accessibility auxiliary_aids_and_services cultural_competency_training provider_ethnicity provider_race last_credential_dt Medical Facility Group ABC   123456789 Medical Clinic 123 Fake St Orange CA 92539 8008881000     Other Cardiology                 null Medical Facility Group ABC   123456790 Medical Clinic 124 Fake St Orange CA 92539 8008881000     Other Cardiology                 null Medical Facility Group ABC   123456791 Medical Clinic 125 Fake St Orange CA 92539 8008881000     Other Cardiology                 null Medical Facility Group ABC   123456792 Medical Clinic 126 Fake St Orange CA 92539 8008881000     Other Cardiology                 null Medical Facility Group ABC   123456793 Medical Clinic 127 Fake St Orange CA 92539 8008881000     Other Cardiology                 null Medical Facility Group ABC   123456794 Medical Clinic 128 Fake St Orange CA 92539 8008881000     Other Cardiology                 null Medical Facility Group ABC   123456795 Medical Clinic 129 Fake St Orange CA 92539 8008881000     Other Cardiology                 null Medical Facility Group ABC   123456796 Medical Clinic 130 Fake St Orange CA 92539 8008881000     Other Cardiology                 null Medical Facility Group ABC   123456797 Medical Clinic 131 Fake St Orange CA 92539 8008881000     Other Cardiology                 null Medical Facility Group ABC   123456798 Medical Clinic 132 Fake St Orange CA 92539 8008881000     Other Cardiology                 null Medical Facility Group ABC   123456799 Medical Clinic 133 Fake St Orange CA 92539 8008881000     Other Cardiology                 null Medical Facility Group ABC   123456800 Medical Clinic 134 Fake St Orange CA 92539 8008881000     Other Cardiology                 null Medical Facility Group ABC   123456801 Medical Clinic 135 Fake St Orange CA 92539 8008881000     Other Cardiology                 null Medical Facility Group ABC   123456802 Medical Clinic 136 Fake St Orange CA 92539 8008881000     Other Cardiology                 null Medical Facility Group ABC   123456803 Medical Clinic 137 Fake St Orange CA 92539 8008881000     Other Cardiology                 null Medical Facility Group ABC   123456804 Medical Clinic 138 Fake St Orange CA 92539 8008881000     Other Cardiology                 null Medical Facility Group ABC   123456805 Medical Clinic 139 Fake St Orange CA 92539 8008881000     Other Cardiology                 null Medical Facility Group ABC   123456806 Medical Clinic 140 Fake St Orange CA 92539 8008881000     Other Cardiology                 null Medical Facility Group ABC   123456807 Medical Clinic 141 Fake St Orange CA 92539 8008881000     Other Cardiology                 null Medical Facility Group ABC   123456808 Medical Clinic 142 Fake St Orange CA 92539 8008881000     Other Cardiology                 null Medical Facility Group ABC   123456809 Medical Clinic 143 Fake St Orange CA 92539 8008881000     Other Cardiology                 null Medical Facility Group ABC   123456810 Medical Clinic 144 Fake St Orange CA 92539 8008881000     Other Cardiology                 null Medical Facility Group ABC   123456811 Medical Clinic 145 Fake St Orange CA 92539 8008881000     Other Cardiology                 null Medical Facility Group ABC   123456812 Medical Clinic 146 Fake St Orange CA 92539 8008881000     Other Cardiology                 null Medical Facility Group ABC   123456813 Medical Clinic 147 Fake St Orange CA 92539 8008881000     Other Cardiology                 null Medical Facility Group ABC   123456814 Medical Clinic 148 Fake St Orange CA 92539 8008881000     Other Cardiology                 null Medical Facility Group ABC   123456815 Medical Clinic 149 Fake St Orange CA 92539 8008881000     Other Cardiology                 null Medical Facility Group ABC   123456816 Medical Clinic 150 Fake St Orange CA 92539 8008881000     Other Cardiology                 null ... View more

Basically I need brackets around the values for specialties, languages_spoken, provider_ethnicity, and provider_race in JSON output ... View more

Ah, let me clarify: This is what I have: [ { "plan_type": "Medical", "provider_type": "Facility", "provider_group_affiliation": "Group ABC", "provider_group_website": "", "TIN": 123456789, "clinic_name": "Medical Clinic", "clinic_address": "123 Fake St", "clinic_city": "Orange", "clinic_state": "CA", "clinic_zipcode": 92539, "clinic_phone_number": 8008881000, "provider_name": "", "providerNPI": 1234567890, "provider_category": "Other", "specialties": "Cardiology", "languages_spoken": "", "accepting": "", "telehealth_available": "", "accessibility": "", "auxiliary_aids_and_services": "", "cultural_competency_training": "", "provider_ethnicity": "", "provider_race": "", "last_credential_dt": null }, And this is what I want: [ { "plan_type": "Medical", "provider_type": "Facility", "provider_group_affiliation": "Group ABC", "provider_group_website": "", "TIN": 123456789, "clinic_name": "Medical Clinic", "clinic_address": "123 Fake St", "clinic_city": "Orange", "clinic_state": "CA", "clinic_zipcode": 92539, "clinic_phone_number": 8008881000, "provider_name": "", "providerNPI": 1234567890, "provider_category": "Other", "specialties": ["Cardiology"], "languages_spoken": [""], "accepting": "", "telehealth_available": "", "accessibility": "", "auxiliary_aids_and_services": "", "cultural_competency_training": "", "provider_ethnicity": [""], "provider_race": [""], "last_credential_dt": null }, ... View more