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 |
What are the special input delimiters used in SAS?
Can anyone help to find a statement to get all the predefined formats?
3 Answers Verinon Technology Solutions,
Mention some common errors that are usually committed in sas programming.
The below code we are using for creating more than one macro variables in proc sql using into clause. How we can use same code to create macro variables vara, varb, varc instead of var1, var2, var3.? proc sql noprint; select count(distinct(patient)) into :var1 - :var3 from dataset1 group by trtreg1c ; quit;
Mention sas system options to debug sas macros.
Which command is used to save logs in the external file?
Describe a time when you were really stuck on a problem and how you solved it?
how to display duplicated observations in a data using base sas.
13 Answers HCL, TCS,
define table lookup and how may ways it can be done...explian
what is PhaseIII, ODS, TLG, Macro and Proc in SAS
What type of tables you are using in YOUR reporting..???
2 Answers GSK GlaxoSmithKline,
Which is the Best SAS training Institute in Delhi NCR for SAS certification preparation