Hi. I have this piece of coding whereby I use Load_Dt which add using Prompt Manager with following info: Prompt type: Date Method for populating prompt: User enters value Number of values : Sing value Date type : Day Options (which I choose) : 1) Requires a non-blank value 2) Use prompt value throughout project %put &Load_Dt;
data _null_;
initialdt = &Load_Dt.;
call symput('initialdt',initialdt);
call symput('initialdt_',initialdt_);
call symput('DDMMYY',put(initialdt,DDMMYYN6.));
call symput('YYYYMM',put(initialdt,YYMMN6.));
call symput('YYYYQQ',put(initialdt,YYQ6.));
run;
%put &initialdt.;
%put &initialdt_.;
%put &DDMMYY.;
%put &YYYYMM.;
%put &YYYYQQ.;
Here is the log I got after running the program. 19 %put &Load_Dt;
31Aug2012
20
21 data _null_;
22 initialdt = &Load_Dt.;
NOTE: Line generated by the macro variable "LOAD_DT".
22 31Aug2012
_______
22
ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, -, /, , =, >, >=, AND, EQ, GE, GT, IN,
LE, LT, MAX, MIN, NE, NG, NL, NOTIN, OR, ^=, |, ||, ~=.
23
34 call symput('initialdt',initialdt);
25 call symput('initialdt_',initialdt_);
26 call symput('DDMMYY',put(initialdt,DDMMYYN6.));
27 call symput('YYYYMM',put(initialdt,YYMMN6.));
28 call symput('YYYYQQ',put(initialdt,YYQ6.));
29 run;
30
31 %put &initialdt.;
put(31Aug2012,DDMMYY10.)
32 %put &initialdt_.;
.
33 %put &DDMMYY.;
.
34 %put &YYYYMM.;
.
35 %put &YYYYQQ.;
.
I don't which code goes wrong, is it date, macro or prompt. I really need big help on this. Usually I pre-code the date in as initialdt = '31AUG2012'd which work perfectly but the user wants to choose their own date. Having the dataset that I need to choose name ended with &YYYYMM is not helping with the prompt. Thank you so much.
... View more