Interested to Buy Any Domain ? << Click Here >> for more details...
what are all the ways to define macro variable??
- 2 Answers
- 7314 Views
- GSK GlaxoSmithKline, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rahul
%Let
Iterative %DO statement
%GLOBAL statement
%INPUT statement
INTO clause of the SELECT statement in SQL
%LOCAL statement
%MACRO statement
SYMPUT routine and SYMPUTN routine in SCL
%WINDOW statement
| Is This Answer Correct ? | 12 Yes | 0 No |
Answer / varun kumar
There are 5 ways to create a macro avriable.
1)using %LET statement.
2)Using %GLOBAL statement.
3)Using "CALL SYMPUT" routine.
4)Using Proc Sql.
5)Through parameters.
| Is This Answer Correct ? | 2 Yes | 0 No |
Do you need to combine data sets? How should you combine data sets– MERGE or SET statements in DATA steps,PROC APPEND,PROC SQL?
If you have a data set that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variable?
When looking for data contained in a character string of 150 bytes, which function is the best to locate that data: scan, index, or indexc?
Code a PROC SORT on a data set containing State, District and County as the primary variables, along with several numeric variables?
If reading an external file to produce an external file, what is the shortcut to write that record without coding every single variable on the record?
How would you delete duplicate observations?
Give e an example of..
what is slowly changing dimension? : Sas-di
What are the data types in sas?
Mention what is the difference between nodupkey and nodup options?
what are the differences between proc report and proc tabulate?
In which format does Date stores in sas..? What is the use of DATE in SAS.?
Teradata 
