Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?
2250Do you need to combine data sets? How should you combine data sets– MERGE or SET statements in DATA steps,PROC APPEND,PROC SQL?
3 7199Do you need to compute new variables? If so,should you do this before you execute the report-writing procedure?
1921what is difference in window SAS & Unix SAS.....how do define working environment in both???
1 10353Hi, I need to create a SAS Map of USA using SAS Graphs(Proc Gmap).The data i have dosent contain any co-ordinates of USA cities or counties or states, and the zip codes are diffrent in the data i have from the zip code in the Maps.US dataset in the Maps Library for SAS MAPS. the data i have is a sales report. i have to generate the maps according to the states,cities aligned in the sales data, HELP Appriciated
1 5499Can you calculate the mean, median and mode of the following data set using data step logic? Don't use any function or procedure. data a; input age @@; datalines; 22 32 32 32 43 23 24 56 45 54 28 29 27 26 25 28 30 20 18 37 36 47 46 56 19 20 ; run; I have calculated the mean which i have posted in the answer section.
HSBC,
6 18574
Where do you use proc means over proc freq?
If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?
what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming
Differentiate between proc means and proc summary.
what are sas/access and sas/connect? : Sas programming
What are the best sas programming practices for handling very large datasets? : sas-grid-administration
How do you control the number of observations and/or variables read or written?
How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?
What is the difference between %local and %global? : sas-macro
what are the best practices to process the large data sets in sas programming? : Sas-administrator
What is the difference between SAS functions and procedures?
Differentiate input and infile.
what is the purpose of _error_? : Sas programming
If you could design your ideal job, what would it look like?
How do you delete duplicate observations in sas?