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;
Remove the << and >>. Valid SAS names consist of letters, digits and underlines, and can't start with a digit.
thanks @Kurt_Bremser for your answer but The << and >> cames automatically when I select the variable from the data source ! even when removed it nothing change
What kind of server are you using in Enterprise Guide? The same pooled workspace server, with user asma@saspw, or with a valid operating system account and a standard (non-pooled) workspace server?
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.