This macro uses the format in the data dictionary to read in CSV file and apply variable lengths. More...

Detailed Description

This macro uses the format in the data dictionary to read in CSV file and apply variable lengths.

Check if the inputfile is CSV.
- If the inputfile is CSV, apply variable lengths.
Store the relevant inputfile variables that need dynamic length assigned.
Import CSV in order to acertain variable order for input statement.
Assign the format for each inputfile/variable combo.
Create new inputfile.
- If the inputfile already exists as a SAS dataset, it will be overwritten with contents of CSV file.

Program inputs

&LIB..filenames (Dataset containing all CSV inputfile names.)
&INPUTFILE..csv (CSV files of inputfiles.)
tmplib.format_values (Dataset containing format, informat, and lengths of variables.)

Program outputs

Usage

%get_sas_format(PATH=&INFOLDER.,
                LIB=INFOLDER,
                INPUTFILE=qrp_parameters,
                PARAMETER=qrp_parameters);

Parameters

[in]	PATH	Inputfiles path.
[in]	LIB	SAS libname where the csv files are located.
[in]	INPUTFILE	Input file name.
[in]	PARAMETER	Input parameter name.

None.

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

	QRP