how to assign a macro value to a variable?
Answers were Sorted based on User's Feedback
Answer / guest
by symget function;
SYNTAX:
variable=SYMGET(macro variable);
| Is This Answer Correct ? | 10 Yes | 4 No |
Answer / ganesh k
if it is a Char then Variable="&MacroVar.";
if it is a Numaric then Variable=%eval(&MacroVar.) or %
sysevalf(&MacroVar.);
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / sr
to assign macro value means it already created then
variable=symget(macro var);
variable will get value of that macro variable
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / radhiv kumar sure
8 TO 9 TYPES WE CAN ASSIGN THE MACRO VALUE TO A VARIABLE.
CALL SYMPUT
%LET
SYMGET
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / manna
data x;
%let a=01jan1960;
b=symget("a");
run;
IT IS Tested
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / cool dude
Creating a Macro.
%Let a='City';
Assigning the macro value of a (which is 'City') to variable.
Data _null_;
b=&a;
put b= ;
run;
| Is This Answer Correct ? | 0 Yes | 6 No |
Answer / srinivas,korasavada
and also we can assign like
%let variable=value;
means the value is save in that variable
| Is This Answer Correct ? | 3 Yes | 10 No |
i want to upload titles and footnotes to excel file?how it is possible?
How to limit decimal places for the variable using proc means?
What is program data vector (pdv) and what are its functions?
List down the reasons for choosing sas over other data analytics tools.
i have a dataset with 100 obs i want to generate title from 20th obs onwards with total observations. that should contain 100 obs.dont use firstobs and dnt split the data. use dataset block or proc report? how can we genarate;
What versions of SAS have you used (on which platforms)?
Mention what is the difference between nodupkey and nodup options?
I have a dataset with variables empid and doj how to calculate retirement age?
Explain what is data step?
in which companies SAS openings are there? List of companies using SAS technology.
1.How to draw pivot tables in Excel by using SAS and in which version we can use VB script for to draw pivot tables in Excel? Answer with example data. 2.What are the advantages of _NULL_ in Data steps? Can we use _NULL_ in Proc steps also? 3. How to call the macro variable into Data Steps? 4. Can we draw pivot tables in Excel using Proc SQL? Please post answers for the above questions with suitable examples, and how to use VB script for Excel using SAS.
What do the sas log messages “numeric values have been converted to character” mean? What are the implications?