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?
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 |
Diff between proc sql merge and join?
How do you convert basic cube to transaction cube and transaction cube to basic cube?
what are the three main credit bureau names
1 Answers Synchrony Financial,
How to convert HTML file into SAS dataset?
What are the default statistics that proc means produce?
How to read the file names of a text files from a shared drive using SAS?
Difference between nodup and nodupkey options?
How would you invoke a macro? : sas-macro
what is the function of catx syntax? : Sas-administrator
what are the sites did u refer for enquiries and doubts for SAS
Hi Friends, My name is Priya,am new to this Forum. am looking for SAS Platform Administration Interview Questions.I searched every where but I couldn't find any where.please can anyone help me with the FAQ's. It would be a great favor to me if you can email the Interview Questions to priyafeb84@gmail.com
Please write codes to merge two datasets and keep every record in the first dataset.