convert_inputfiles.sas File Reference

This program determines if CSV input files exists, reads in JSON data dictionary, and creates SAS syntax for data step. More...

Detailed Description

This program determines if CSV input files exists, reads in JSON data dictionary, and creates SAS syntax for data step.

• Read in all CSV files and get the names.
• Grab the json file information for sas_formats contents (format, informat, length, and input).

Program inputs

• data_dictionary.json (QRP data dictionary.)
• &LIB. (CSV files.)

Program outputs

• tmplib.filenames (Dataset containing the names of CSV files.)
• tmplib.format_values (Dataset containing format, informat, and lengths of variables.)
• work.input_files (Dataset from data_dictionary containing information about sas formats.)

Usage

%convert_inputfiles(LIB=&INFOLDER., 
                    JSON_LIB=&INFOLDER.macros/integration);

Parameters

[in]	LIB	Inputfiles directory where the csv files are located.
[in]	JSON_LIB	Integration directory where the json files are located.

SAS Macros Dependencies

None.

Author

Sentinel Coordinating Center (info@.nosp@m.sent.nosp@m.inels.nosp@m.yste.nosp@m.m.org)