/Creating View/
PROC SQL;
Create view DriveType As
Select Make, Model, Type, Origin, DriveTrain, MSRP
From SASHELP.CARS
Where DriveTrain = 'Rear'
Order by MSRP;
/Show DriveType View/
Select *
From DriveType;
QUIT;
/Case Logic/
PROC SQL;
Select Make, Model,
Case
WHEN DriveTrain = 'All' Then '4WD'
WHEN DriveTrain = 'Front' Then 'Front-Drive'
WHEN DriveTrain = 'Rear' Then 'Rear-Drive'
Else ''
End AS DriveMechanizm
From SASHELP.CARS;
QUIT;
/Phonetic Matching(Sounds-Like Operator=)/
PROC SQL;
SELECT Make, Model, Type
FROM SASHELP.CARS
Where Model = 'Impala';
QUIT;
/Using Wildcard Charactor for Searching/
PROC SQL;
SELECT Model
FROM SASHELP.CARS
Where Upcase(Model) Like '%CI%';
QUIT;
/Removing Row with Duplicate Values/
PROC SQL;
SELECT Distinct Make
FROM SASHELP.CARS
QUIT;
PROC SQL DOUBLE;
SELECT *
FROM SASHELP.CARS
ORDER BY TYPE;
QUIT;
Data class2(drop=age height weight);
set sashelp.class;
c=height+weight;
d=age*weight;
cards;
/Data manipulation in Array/
Data test_array (drop=i);
set sashelp.class;
ARRAY score_var (3) age height weight;
DO i = 1 to 3;
IF score_var(i)=<12 then score_var(i)=.;
END;
ave_score = mean(height, weight);
RUN;
/Creating View/ PROC SQL; Create view DriveType As Select Make, Model, Type, Origin, DriveTrain, MSRP From SASHELP.CARS Where DriveTrain = 'Rear' Order by MSRP; /Show DriveType View/ Select * From DriveType; QUIT;
/Case Logic/ PROC SQL; Select Make, Model, Case WHEN DriveTrain = 'All' Then '4WD' WHEN DriveTrain = 'Front' Then 'Front-Drive' WHEN DriveTrain = 'Rear' Then 'Rear-Drive' Else '' End AS DriveMechanizm From SASHELP.CARS; QUIT;
/Phonetic Matching(Sounds-Like Operator=)/ PROC SQL; SELECT Make, Model, Type FROM SASHELP.CARS Where Model = 'Impala'; QUIT;
/Using Wildcard Charactor for Searching/ PROC SQL; SELECT Model FROM SASHELP.CARS Where Upcase(Model) Like '%CI%'; QUIT;
/Removing Row with Duplicate Values/ PROC SQL; SELECT Distinct Make FROM SASHELP.CARS QUIT;
PROC SQL DOUBLE; SELECT * FROM SASHELP.CARS ORDER BY TYPE; QUIT;
Data class2(drop=age height weight); set sashelp.class; c=height+weight; d=age*weight; cards;
/Data manipulation in Array/ Data test_array (drop=i); set sashelp.class; ARRAY score_var (3) age height weight; DO i = 1 to 3; IF score_var(i)=<12 then score_var(i)=.; END; ave_score = mean(height, weight); RUN;