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 |
If you were told to create many records from one record, show how you would do this using array and with proc transpose?
why a stop statement is needed for the point= option on a set statement?
how to rearrange the data as our wish by using dataset block?
Explain translate function?
Where do the database management systems store data and how do u import them.
How would you delete duplicate observations?
data abc; input x y ; cards; 1 2 5 6 7 8 7 8 1 7 5 7 ; run; Proc Freq data=abc; tables x*y / chisq nopercent nocol norow PLCORR; RUN; If we run the code, we have Polychoric Correlation = 0.9054 in the last table. I want to extract this particular entry with the value. Means I will create one dataset in which this value will be stored/extracted. I need your help in coding this. Please help me out.
Differences between where and if statement?
How do you delete duplicate observations in sas?
Explain what is data step?
Hi, I have one dataset, could you please ans for this. id amount paid_amount 1 700 400 2 900 250 3 300 300 a 400 250 b 500 320 c 800 650 x 200 190 y 900 250 z 300 180 i want create new dataset having id and paid_amount who are paid high amount comparing amount. ex: 1d paid_amount 3 300 c 650 x 190
What is the difference Using & and && in the macro variables