Tell different ways to create Macrovarible?
Answers were Sorted based on User's Feedback
Answer / shah
Four ways to create Macro variables:
1. %Let
2. %Macro(Keyword or Positional Parameters)
3. Proc SQL select into:
4. Call Symput
| Is This Answer Correct ? | 25 Yes | 1 No |
Answer / kamal sharma
1. %LET
2. %GLOBAL
3. %LOCAL
4. Macro parameter
5. %DO loop index variable
6. CALL SYMPUT / CALL SUMPUTX
7. PROC SQL INTO clause
8. ODS OUTPUT statement using the MATCH_ALL option
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / paramatma pulivarthi
there are 5 ways to create macro variable
1.by using %global
2.by using %local
3.by using %let
4.by using call symput
5.by using select and into clause
and
6. by passing the values to macro through the parameters.
| Is This Answer Correct ? | 1 Yes | 0 No |
I have 50 variables in one data set, In reports i want to generate every 10 variables in one page how we will write code in proc report.
what are input dataset and output dataset options?
If reading a variable length file with fixed input, how would you prevent SAS from reading the next record if the last variable didn?t have a value?
explain the use of % includes a statement in sas? : Sas-administrator
What’s the difference between var b1 – b3 and var b1 — b3?
How to merge the data using merge statement and proc format? Is the result is same ?
Name and describe three SAS functions that you have used, if any?
what is the difference between unique key and primary key? : Sas-di
HOW DO WE CREATE A SAS STORED PROCESS IN SAS EG ?
if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming
I have a dataset concat having a variable a b & c. How to rename a b to e & f?
what is the need of INDEX in datasets?