About shivamarrora0

shivamarrora0 · ‎08-04-2017

Thank you Kurt.. i was just confuse .. t

shivamarrora0 · ‎08-04-2017

I think the below code will work proc sort data=test; by descending marks; run; data rank; set test; by descending marks; if first.marks then count+1; run;

shivamarrora0 · ‎08-03-2017

The out put i want to sort the marks in order then rank them ; if the marks are same then the rank should tie and if the null value then it skip that rank for example marks rank 30 1 22 2 22 2 20 3 Like this

shivamarrora0 · ‎08-03-2017

Hi All, I want to rank the below id according to marks using only data step first dot last dot , Kindly help data ma; input id$ marks; cards; a 20 b 33 c 13 d 44 e 13 f 33 ;

shivamarrora0 · ‎08-01-2017

i am really sorry the desired output i need , 1 c 2 b 3 d sorry for the trouble

shivamarrora0 · ‎08-01-2017

I am really sorry Folks, the desired output is 1 c 2 b 3 d

shivamarrora0 · ‎08-01-2017

data a; input id name$; cards; 1 a 2 b ; data b; input id name$; cards; 1 c 3 d ;

shivamarrora0 · ‎08-01-2017

Hi All, Can you please help me getting the below output using sql join

shivamarrora0 · ‎07-31-2017

i wrote the below query and its working fine but i have compared and the group by them..But in your query how it is getting grouped ... proc sql; select distinct test.marks,test.id ,sum(a.marks) as total from test,test as a where a.marks le test.marks group by test.id; quit;

shivamarrora0 · ‎07-31-2017

If you dont mind can you please explain this query, how (select sum(MARKS) from TEST where ID <= A.ID) as TOTAL from TEST A; is working. Please its a request ... because i am unable to figure out how the id is comparing to a.id ..because we are not using the self join here

shivamarrora0 · ‎07-31-2017

data test; input id marks; cards; 1 10 2 20 3 30 4 40 ;

shivamarrora0 · ‎07-31-2017

Hi All, I need the below output using proc sql... Please help

shivamarrora0 · ‎07-31-2017

Hi, I wanted to know the reason why b.sal le a.sal comparing 1 observation of B table to every observation of A table .. ?

shivamarrora0 · ‎07-30-2017

Hi All, can you please explain crisply how the below query is working, i wanted to know how where confition checking the each observtion of table b with every observation of table a. /* Quesry is used to find the ranks*/ data a; input id sal; cards; 1 100 2 200 3 300 9 78 10 890 11 890 ; proc sql; select a.*,(select count(distinct sal) from a where b.sal le a.sal) as r from a b; quit;

shivamarrora0 · ‎07-20-2017

I agree with you, but this is my institute question , that is why i posted .

Online Status	Offline
Date Last Visited	‎04-09-2018 05:05 AM

Re: Way to export graph into Excel

Way to export graph into Excel

Re: Run the whole code on the base of condition

Run the whole code on the base of condition

Re: Using IF condition while using PUT function

Using IF condition while using PUT function

Re: reading raw data

reading raw data

sas report format

sas boxplot

Re: Arrays

Re: base sas

Re: base sas

Re: base sas

Re: base sas

base sas

Re: sql join

Re: sql join

Re: sql join

sql join

Re: proc sql

Re: proc sql

Re: proc sql

proc sql

Re: Proc sql

Proc sql

Re: base sas