Interested to Buy Any Domain ? << Click Here >> for more details...
Tell different ways to create Macrovarible?
- 3 Answers
- 8573 Views
- Accenture, PharmaNet i3, I also Faced
- E-Mail Answers
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 |
how to change the execute of macro
Of all your work, where have you been the most successful?
data data1; input dt account; format dt date9.; cards; 1745 1230 1756 1120 1788 1130 1767 1240 ; data data2; input startdt enddt total; format startdt date9. enddt date9.; cards; 1657 1834 12300 1557 1758 16800 1789 1789 12300 1788 1345 12383 1899 1899 13250 ; proc sql; create table data3 as select * from data1 as x left join data2 as y on x.dt>=y.startdt and x.dt<=y.enddt; quit; Here, we are getting cartision product. But,I want left join report consisting of this program. It should not get duplicate values. you can modify the program also.
how to generate the test data in sas without input data? : Sas-administrator
Hi, I need to create a SAS Map of USA using SAS Graphs(Proc Gmap).The data i have dosent contain any co-ordinates of USA cities or counties or states, and the zip codes are diffrent in the data i have from the zip code in the Maps.US dataset in the Maps Library for SAS MAPS. the data i have is a sales report. i have to generate the maps according to the states,cities aligned in the sales data, HELP Appriciated
How does Mr.Lanka Srinivas teach SAS? Are his accomplishments real? What are the future prospects for SAS?
We want to merge file A and B. File A has variable age, file B provide birthdate. How to merge the data according to age in file B
what is SAS/Access and SAS/Connect?what are the uses?
Explain substr function?
how could you generate test data with no input data? : Sas programming
What are symget and symput? : sas-macro
What is the use of divide function?
Teradata 
