This is the log. I was wrong, it didint "successfully" convert because of the note in the log but it still shows yrmonth format. The format type for YrMth was originally CHAR 200 and it looks like 202102.
(Also , $mth. is just Jan, Feb, mar, etc.)
83 data tab;
84 set bat;
85
86
87 format tmonth yyyymm6.;
---------
484
88 tmonth =input(put(YrMth,6.),yyyymm6.);
---------
485
NOTE 484-185: Format YYYYMM was not found or could not be loaded.
NOTE 485-185: Informat YYYYMM was not found or could not be loaded.
89
90 year = year(tmonth);
91 Quarter = "Q" || put(QTR(tmonth),$1.);
WARNING: Character format specified for the result of a numeric expression.
92 yr = put (year,z4.);
93 inc_mnth = put(year(tmonth),z4.) || put(month(tmonth),z2.);
94 month2=put(put(month(tmonth),z2.), $mth.);
95
96 run;
NOTE: Variable YrMth is uninitialized.
NOTE: Missing values were generated as a result of performing an operation on missing values.
Each place is given by: (Number of times) at (Line):(Column).
1019039 at 90:8 1019039 at 91:22 1019039 at 93:16 1019039 at 93:49 1019039 at 94:16
NOTE: There were 1019039 observations read from the data set WORK.bat.
NOTE: The data set WORK.bat has 1019039 observations and 12 variables.
NOTE: Compressing data set WORK.tab decreased size by 41.12 percent.
Compressed is 1101 pages; un-compressed would require 1870 pages.
NOTE: DATA statement used (Total process time):
real time 1.29 seconds
cpu time 0.99 seconds
... View more
