what are all the ways to define macro variable??
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 |
what is the use of LRECL option.
Describe the types of SAS programming tasks that you performed like Tables? Listings? Graphics? Ad hoc reports? Other?
What is the difference between where and if statement?
i have a dataset with 100000 records. i want 100 records from that dataset and create a dataset.we need to pick the observations random order like 100obs,500obs,1020obs,1890obs,2565obs like that i need 100 obs in random order? how can we create this one?
What other SAS features do you use for error trapping and data validation?
what is the difference between %put and symbolgen?
Mention sas system options to debug sas macros.
name several ways to achieve efficiency in your program? : Sas programming
sas macros
Have you ever linked SAS code? If so, describe the link and any required statements used to either process the code or the step itself.
Explain data step in SAS
Which command is used to save logs in the external file?