Variable lables are missing when the SAS dataset is converted to JSON ...

DivyaA · Posted 05-10-2023 05:05 PM

Hi All,
I'm Trying to export SAS Dataset to JSON Object but the Variable Labels are missing in the output file.
Please throw some light on how to fix this?
Regards,
DivyaA

Quentin · Posted 05-14-2023 01:25 PM

How are you exporting the data, proc JSON?

This answer replaced variable names with labels during the export:

https://communities.sas.com/t5/SAS-Programming/How-do-I-use-a-Variable-Label-in-JSON-key-PROC-JSON-E...

Is that what you want? Or do you want a separate json object listing the variables and labels? If the latter, perhaps run PROC CONTENTS and output that to a SAS dataset, then export that dataset to JSON.

BASUG is hosting free webinars Next up: Don Henderson presenting on using hash functions (not hash tables!) to segment data on June 12. Register now at the Boston Area SAS Users Group event page: https://www.basug.org/events.

Variable lables are missing when the SAS dataset is converted to JSON object. How to include them?

Re: Variable lables are missing when the SAS dataset is converted to JSON object. How to include the

Variable lables are missing when the SAS dataset is converted to JSON object. How to include them?

Re: Variable lables are missing when the SAS dataset is converted to JSON object. How to include the

Ready to join fellow brilliant minds for the SAS Hackathon?

Click image to register for webinar

Classroom Training Available!