Solved: How to format date values in Proc SQL - SAS
https://communities.sas.com/t5/SAS-Procedures/How-to-format-date-values-in-Proc-SQL/td-p/228015
Oct 01, 2015 · data test; a = 201506; /* YYYYMM as a number */ b = '01JUN2015'd; /* SAS date value with YYYYMM format */ format b yymmn6.; c = "201506"; /* char version of the YYYYMM date */ run; proc print; run; proc sql; select mdy (mod (a, 100), 1, int (a/100)) as date_a format=yymmdd6., b as date_b format=yymmdd6., input (c, yymmn6.) as date_c …
DA: 52 PA: 38 MOZ Rank: 85