Import pre-stored format table

[malls]

My format table is .csv

Here is the code iused to import this table : 

proc import datafile='E:\PUF AY 2017\PUF AY 2017\CSV\PUF_FORMATS.csv'
out=kmus.FORMATS dbms=csv replace;
run;

Further, i submitted these codes : 

data formats;
set kmus.formats;
run;

DATA fmtDataset;
SET formats;
RENAME Value = Start;
run;

PROC FORMAT CNTLIN=fmtDataset type="C";
RUN;
data test; set dixsept;
format statedesignation statedesignation.;
run;

proc freq data=test;
table statedesignation;
run;

Sadly, i still get missing values.

[Tom]

Don't use PROC IMPORT to read CSV files.  It has to GUESS how to define the variables. Just write your own data step to read the CSV file and then you can control how the variables are defined.