Why and when do you use proc sql?
No Answer is Posted For this Question
Be the First to Post Answer
How will you generate test data with no input data?
What do you feel about hardcoding?
What are the functions used for character handling?
What makes sas stand out to be the best over other data analytics tools?
Where do the database management systems store data and how do u import them.
What is the difference between order and group variable in proc report?
I am looking to buy a sas advance book. So any one can guide me that which one i should buy.
1.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.
what are the methods that you would employ to fine tune your SQL extract process using SAS/Access or Proc SQL?
here is a string like chq.2312244%4452- from that i want only special characters in a column. dont use compress. bcoz i have 1.2 billion of records.i want another process to find the values instant from the data.
what is the difference between floor and ceil functions in sas? : Sas-administrator
Give some ways by which you can define the variables to produce the summary report (using proc report)?