"1" => Character
1 => Numeric
For the warning you need to convert your first format to a numeric format.
For the error I think you need an informat, not a format.
Modifying your code:
proc format;
value $MunicipalityRegion
"101","147","155","185","165","151","153","157","159","161",
"163","167","169","183","173","175","187","201","240","210",
"250","190","270","260","217","219","223","230","400","411"
= "Region Capital"
"253","259","350","265","269","320","376","316","326","360",
"370","306","329","330","340","336","390"
= "Region Zealand"
"420","430","440","482","410","480","450","461","479","492",
"530","561","563","607","510","621","540","550","573","575",
"630","580"
= "Region Southern Denmark"
"710","766","615","707","727","730","741","740","746","706",
"751","657","661","756","665","760","779","671","791"
= "Region Central Denmark"
"810","813","860","849","825","846","773","840","787","820",
"851"
= "Region Northern Jutland"
" "
= "Region Missing";
invalue $ RegionCathegory
"Region Capital" = 1
"Region Zealand" = 2
"Region Southern Denmark" = 3
"Region Central Denmark" = 4
"Region Northern Jutland" = 5
"Region Missing" = 6;
run;
Then you can use them as follows:
RegionText = put(Municipality , MunicipalityRegion.);
Region = input(RegionText , $RegionCathegory.);
FYI not sure if cathegory should be spelled as category or with the h....
... View more
