I am trying to create infomap using SAS Information Map Studio , I create a variable that took a period as "201605" and turn it to date like 2016-05-31 , I used this code (put((intnx('month', input(cats(<<DM_DATE.MOIS_ET_ANNEE_YYYYMM>>,'01'),yymmdd10.),0,'ending')),yymmdd10.)) the problem is when I am trying to validate the expression I got this error however when I copy the query used by Infomap on SAS Entreprise Guide it worked PROC SQL Outobs=100;
Create table WORK.A44 as
SELECT DISTINCT
( (put((intnx('month', input(cats(table0.MOIS_ET_ANNEE_YYYYMM,'01'),yymmdd10.),0,'ending')),yymmdd10.)) ) AS DIR_7 LABEL='Datetest'
FROM
abb.DM_DATE table0
GROUP BY
1;
quit;
... View more