1.What is the difference between _NULL_ , _ALL_, and _N_? 2.What are the uses of _NULL_ using in Data Steps? Can we _NULL_ in Proc Steps also? 3.How do call the macro variable in Data Steps? 4.How to construct Pivot tables in Excel Using SAS?
3 104151.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.
1 85471.we can execute a macro with in a macro,by using call symput and symget can any one give me one example? 2.We can create the macro variables by using %let,%do,macro parameters,INTO clause in proc sql and call symput, can any one give me example to create macro variable with INTO clause and call symput? 3.
1 5198
what are _numeric_ and _character_ and what do they do? : Sas programming
Have you used macros? For what purpose you have used? : sas-macro
explain the main difference between the nodup and nodupkey options? : Sas-administrator
What is the general format of function in sas? : sas-grid-administration
To what type of programms have you used scratch macros?
What is data _null_?
Are you involved in writing the inferential analysis plan? Tables specfications?
how to read the variables in sas? : Sas-administrator
What is the length assigned to the target variable by the scan function?
what is the difference between unique key and primary key? : Sas-di
What is a macro routine?
How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro
Mention the difference between ceil and floor functions in sas?
Explain by-group processing?
What is the basic structure of the SAS base program?