Interested to Buy Any Domain ? << Click Here >> for more details...
If you need the value of a variable rather than the
variable itself what would you use to load the value to a
macro variable?
- 2 Answers
- 5270 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / chaitanya
If we need a value of a macro variable then we must define
it in such terms so that we can call them everywhere in the
program. Define it as Global. There are different ways of
assigning a global variable. Simplest method is %LET.
Ex: A, is macro variable. Use following statement to assign
the value of a rather than the variable itselfe.g.
%Let A=xyz x="&A";
This will assign "xyz" to x, not the variable xyz to x.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / damwal
Use CALL SYMPUT routine.
Below I show how to assign the value of 3rd observation of
variable name (94) to a macro variable named "macrovar1"
data test;
input name @@;
datalines;
1 21 94 444 5
;
data _null_;
set test (firstobs=3 obs=3);
call symput("macrovar1",name);
run;
%put ¯ovar1; /*display*/
| Is This Answer Correct ? | 1 Yes | 0 No |
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 are different type of sas servers ? On which server does the sas code execute ?
What is PROC in SAS?
How to include or exclude specific variables in a data set?
Name statements that are execution only?
What do you feel about hardcoding?
Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks
What statement do you code to write the record to the file?
What do you feel about hardcoding?
Describe 5 ways to do a “table lookup” in SAS?
How to convert .xls file into CSV format?
The Lion King is hosting an animal conference. All the animals in the world attend except one. Which animal does not attend?
Teradata 
