Thamaraikannan Tracker

Re: Subsetting Dataset using Proc sql

Thamaraikannan — Tue, 15 Aug 2017 10:44:40 GMT

It is not possible to produce multiple tables or views in a single sql query.

Best way could be :

proc sql;
create table lt_15k as select * from sas1.cars where price le 15 ;
create table lt_20k as select * from sas1.cars where price between 15 and 20 ;
create table lt_30k as select * from sas1.cars where price between 20 and 30 ;
create table lt_40k as select * from sas1.cars where price between 30 and 40 ;
quit;

Re: How to use sas code to make a table like this... (urgent！）

Thamaraikannan — Wed, 10 Dec 2014 09:47:17 GMT

data src_rec;

input name $ sex $ school $ dt date9. score;

datalines;

AAA F Law 9-sep-14 10

BBB F IT 10-Aug-14 20

CCC M Law 19-Sep-14 30

DDD F Art 10-Dec-14 25

EEE F Law 9-sep-14 40

FFF M Biz 10-Aug-14 45

GGG F Law 9-Dec-14 55

HHH M IT 6-Dec-14 50

III M Law 19-Nov-14 45

JJJ M Art 10-Aug-14 20

kkk F Law 9-Dec-14 25

lll F Biz 8-Dec-14 20

;

run;

data date_flg ;

set src_rec;

if intck('day',(INTNX('week',dt,0,'B' )),today())>= 7 then do;

flag = 'This week' ;

else do;

flag = 'last week' ;

run;

proc tabulate data = date_flg;

class school sex flag;

var score;

table (school*sex ),flag='No of student Registered'*n=''(flag='Sum of score'*score=''*sum='')(flag='Avg of score'*score=''*mean='') ;

run;

Re: How to use sas code to make a table like this... (urgent！）

Thamaraikannan — Tue, 09 Dec 2014 13:05:34 GMT

Try this

data src_rec;

input name $ sex $ school $ dt date9.;

datalines;

AAA F Law 9-sep-14

BBB F IT 10-Aug-14

CCC M Law 19-Sep-14

DDD F Art 10-Dec-14

EEE F Law 9-sep-14

FFF M Biz 10-Aug-14

GGG F Law 9-Dec-14

HHH M IT 6-Dec-14

III M Law 19-Nov-14

JJJ M Art 10-Aug-14

kkk F Law 9-Dec-14

lll F Biz 8-Dec-14

;

run;

data date_flg ;

set src_rec;

if intck('day',(INTNX('week',dt,0,'B' )),today())>= 7 then flag = 'This week' ;

else flag = 'last week' ;

run;

proc tabulate data = date_flg;

class school sex flag;

table school*sex,flag='No of student Registered'*n='';

run;