PROC SQL - 1 | PROC SQL in SAS | Introduction to PROC SQL Step-by-Step | Basic Syntax of PROC SQL

[@davidelliott1352]

Thank you

[@learnerea]

You're welcome

[@aya_d_i370]

Sir very nice explained.. thankyou sir..

[@learnerea]

So nice of you

[@aanchalsrivastava8550]

Can you tell one example to convert proc sql to datastep I.e one scenario which you can tell one in proc sql same scenario in datastep

[@learnerea]

okay, here is the simplest one. Consider the Cars dataset (you can find that in the sashelp library) which has 15 columns using this, you want to create another dataset which has only - Type, Model, Origin and MSRP. The data you want keep is only for "Europe" -
SOLUTION WITH PROC SQL:-
proc sql;
create table cars_subset as
select type
,model
,origin
,msrp
from sashelp.cars
where origin = "Europe";
quit;
SOLUTION WITH DATA STEPS:-
data cars_subset(keep=type model origin msrp);
set sashelp.cars;
where origin = "Europe";
run;
hope this helps

[@aanchalsrivastava8550]

Can u do this example in proc sql and same in datastep write a code yo find out the students who never went to Delhi you can consider any city

[@vijayPatibandla]

explain SDTM domains.

[@vidyapedii5854]

Wow super

[@learnerea]

I'm glad you liked it 🙏🏻

[@TheYi1985]

Fantastic !

[@learnerea]

Many thanks!