adspace


what is the use of proc sql?

Answer Posted / nishant

PROC SQL is a powerful tool in sas which combines the
functionality of data and proc steps. PROC SQL can sort,
summarize, subset, join (merge), and concatenate datasets,
create new variables, and print the results
or create a new dataset all in one step!

PROC SQL uses less resources when compared to that of data
and proc steps.

To join files in PROC SQL it does not require to sort the
data prior to merging which is must is data merge

Is This Answer Correct ?    22 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hi, If anyone has base SAS certification dumps, please share.

1956


sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately

3678


Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks

2327


Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager

2165


hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?

2136


Are you involved in writing the inferential analysis plan? Tables specifications?

4032


how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5

2190


how to generate the test data in sas without input data? : Sas-administrator

1217