data ds;
input item_name: $ 15. total_count;
datalines;
Water_Bottle 2
Tent 1
Apple 4
;
run;
data split;
set ds;
do split=1 to total_count;
output;
end; drop total_count;
proc print ;
run;
Q)1. How to get split item count using proc sql
... View more
data testy;
input a;
datalines;
1
2
3
4
5
6
7
8
9
;
run;
/*how to swap first obs and last obs each other in SAS*/
required output
9
2
3
4
5
6
7
8
1
Question: How to swap values each other as above required output
... View more
Hi Sharp
Thanks for your solution
But interviewers ask reason why we can not achieved in proc sql can you explain how to explain proper reason
... View more
data s;
input id price;
datalines;
100 25
100 60
100 65
100 80
100 91
101 55
101 25
101 85
101 100
;
run;
/* proc sql method : Second max price for each id */
proc sql;
select *
from s as a
where 2=(select distinct price
from s as b
where a.price <= b.price
) ;
quit;
/* Datastep method :Second max price for each id */
data rank;
set s;
run;
proc sort data=s;
by descending id;
run;
data ranking;
set s;
by descending id ;
if first.id then ranks=1;
else ranks+1;
proc print noobs;
run;
data maxvalue ;
set ranking ;
if _n_=2;
proc print ;
run;
Q1.)Here I didn't get correct output for nth max value as of now i want to find second max price for each id how to fix this problem
... View more
data even_odd;
array v[20] value1-value20;
do values= 1 to 20;
v[values]=values;
end;
drop values;
run;
data even_values;
set even_odd;
array v[20] value1-value20;
do values = 1 to 20;
if mod(values,2)=0 then output;
end;
drop values;
run;
How to get even and odd values using above array
... View more
data count;
name="Tokyo Olympics 2020 ";
x=count(name,'a');
x1=count(name,'a','i');
x2=count(name,'a','T');
xlength=length(x);
x1ength=length(x1);
x2length=length(x2);
run; x2length result length is 12 even if I use letter 'a'
... View more
