search

hih95003 / SAS-Sample

0 stars 0 forks source link

Creating View #2

Open hih95003 opened 5 years ago

hih95003 commented 5 years ago

/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;

hih95003 commented 5 years ago

/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;

hih95003 commented 5 years ago

/Phonetic Matching(Sounds-Like Operator=)/ PROC SQL; SELECT Make, Model, Type FROM SASHELP.CARS Where Model = 'Impala'; QUIT;

hih95003 commented 5 years ago

/Using Wildcard Charactor for Searching/ PROC SQL; SELECT Model FROM SASHELP.CARS Where Upcase(Model) Like '%CI%'; QUIT;

hih95003 commented 5 years ago

/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;

hih95003 commented 5 years ago

/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;