Interested to Buy Any Domain ? << Click Here >> for more details...
what are all the ways to define macro variable??
- 2 Answers
- 7213 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 |
What is difference between Global n Local Macro Variables..?
I need to find the numeric field which contains blank in between..Ex:123 456...there is blank in between the 123 456..I need to know if there is any SAS function to find a field.. Please suggest...
1.How to draw pivot tables in Excel by using SAS and in which version we can use VB script for to draw pivot tables in Excel? Answer with example data. 2.What are the advantages of _NULL_ in Data steps? Can we use _NULL_ in Proc steps also? 3. How to call the macro variable into Data Steps? 4. Can we draw pivot tables in Excel using Proc SQL? Please post answers for the above questions with suitable examples, and how to use VB script for Excel using SAS.
I need level 2 to 5 sas using companies in india
Difference Between Scan and Substr
How to convert a given date value into SAS date
9 Answers CitiGroup, Quintiles,
Describe how you would pass data to macro.
what is sas database server? : Sas-di
What data sets do you need to produce the report?
What statement do you code to write the record to the file?
hi i am nipun can anybody tell me that if a clinical sas programmer write the code and after successfull execution where do they store it. how they submit tables to TL how work is assigned to programmers either both code, log, output to be submitted. can any one tell me the process
I have a SCD Type 2 Dimention for Location In which A Sales Office in Having two Surrogate Keys just because of the change in it's Sales Group. SKey SalesGroup Sales Office BeginDate EndDate 280 SG1 SO1 01APR2000 01APR2010 281 SG2 SO1 02APR2010 31MAR2999 Now while loading the Fact, the Lookup ir returning SKey 280 for records before and after 01APR2010. I am not able to give WHERE condition in the Lookup Properties (TranDate between BeginDate and EndDate). Please help.
Teradata 
