Answer / bitla

using random functions like RANUNI() RANBIN() etc
with DO loops
ex:
data one;
do i=1 to 1000;
x=ranuni(32223);
end;
run;

Answer / k ramesh

data testdata_anlyse;
do i=1 to 100;
x=rannor(i);
output;
end;
run;

Answer / x

data step with(empty data)/withuot set statement.

Answer / ganesh k

using PROC PLAN

Answer / chandra sekar

data test;
delete;
run;

Answer / bala

By using 'cards' and 'Datalines' statements

data data1; input dt account; format dt date9.; cards; 1745 1230 1756 1120 1788 1130 1767 1240 ; data data2; input startdt enddt total; format startdt date9. enddt date9.; cards; 1657 1834 12300 1557 1758 16800 1789 1789 12300 1788 1345 12383 1899 1899 13250 ; proc sql; create table data3 as select * from data1 as x left join data2 as y on x.dt>=y.startdt and x.dt<=y.enddt; quit; Here, we are getting cartision product. But,I want left join report consisting of this program. It should not get duplicate values. you can modify the program also.

0 Answers  

what are the component of range? : Sas-bi

0 Answers  

I need help in merging two different datasets. I am merging by date and I want to propagate observations from one dataset to the corresponding dates. One dataset has a unique date for each day of the month, while the other dataset has same date for different patient visits. For example I want to spread an observation on the 31DEC2008 from one dataset to several observations with the same date on a second dataset for all the patients who visited on that date. I have tried to merge the two and the result is not what I wanted. Instead I get a dataset whereby all the dates have missing values where observations from the first datset should have spread.

1 Answers  

how to delete the duplicate columns permanently in SQL

2 Answers   Satyam,

What are the different versions of sas that you have used until now? : sas-grid-administration

0 Answers  

Can anyone help me about SAS Realtime scenarios in Clinical field

0 Answers  

what is the difference between floor and ceil functions in sas? : Sas-administrator

0 Answers  

what is the primary data source for the wrs? : Sas-bi

0 Answers  

what is washout period?

3 Answers   Cognizant,

what is sas metadata repository? : Sas-bi

0 Answers  

what type of graphs we will create(for 2+years candidates)?

0 Answers   Accenture, Icon,

what is sas business intelligence? : Sas-bi

0 Answers