How do you add a number to a macro variable?
Answers were Sorted based on User's Feedback
Answer / hsong001
Use %eval to do simple calculation for macro variables.
e.g.,
data _null_;
%let a = 1;
%let b = %eval(&a+1);
%put a=&a b=&b;
run;
| Is This Answer Correct ? | 9 Yes | 0 No |
What statement do you code to tell SAS that it is to write to an external file? What statement do you code to write the record to the file?
I have a SCD Type 2 Dimention for Location In which A Sales Office in Having two Surrogate Keys just because of the change in it's Sales Group. SKey SalesGroup Sales Office BeginDate EndDate 280 SG1 SO1 01APR2000 01APR2010 281 SG2 SO1 02APR2010 31MAR2999 Now while loading the Fact, the Lookup ir returning SKey 280 for records before and after 01APR2010. I am not able to give WHERE condition in the Lookup Properties (TranDate between BeginDate and EndDate). Please help.
what is prime numbers? how we can get plc write sas code?
How would you identify a macro variable?
in ods is there any lib's
How experienced are you with customized reporting and use of Data _Null_ features?
How would you combine 3 or more tables with different structures?
Tell e how how dealt with..
what is in stream data in SAS?
sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately
How do you download a flat file from Mainframe to your local PC using SAS?
If money were no object, what would you like to do?