How to get the repeated values by using sql in sas ?2 4067
1 new york 7,262,700 2 los angeles 3,259,340 3 philadelphia 1,642,900 how to read the above data using input statement consider the above data is in txt format externally u have to use infile and input statement.9 9561
/* This is example of age caluculate wihtout to display perfect days and years in output window */ data age; retain dob "12jun2003"d now "24may2011"d; age1=now-dob; age=(now-dob)/365.25; years=int(age); days1=round((age-years)*365.25); months=month(now)-1; if days1 gt 30 and months in(12,10,8,6,4,2)then do; month1=days1/30.4375; month=int(days1/30.4375); if day(now)=1 then days=1; else days=round((month1-month)*30.4375)+1; drop days1 month1 month; end; else if days1 gt 30 and months in (1,3,5,7,9,11)then do; month1=days1/30.4375; month=int(days1/30.4375); if day(now)=1 then days=1; else days=round((month1-month) *30.4375); drop days1 month1 month; end; drop age age1; proc print data=age; format dob now date.; run;1 3766
hi here is a problem can anybody solve this? i want to report the data through third party file. by using data _null_ or proc report or macro automation process. but i want to insert the 'titles and footnotes' in between the data and also starting of 2nd and ending of 2nd and starting of 3rd and ending of the 3rd page. tell me how and write the code?1530
how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?2138
Does anybody have SAS Training manual or documentation or can you refer me any book to have better understanding on SAS. I am fresher to SAS tool. (Ready to pay)4 3966
What is the differnce between SDTM 3.1.2 to 3.1.1 version4309
i am importing large data from oracle to work library. in log there is a error message worklibrary space is not enough. then how to import the data safely to sas environment.2 5778
what is enterprise guide? What is the use of it? : Sas programming
What is PDV?
How would you include common or reuse to be processed along with your statements?
In sas admin differentiate between roles and capabilities? : sas-grid-administration
how does sas handle missing values in functions? : Sas programming
why is sas data integration studio important? : Sas-di
what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming
Will it bother you if the guy at the next desk times the frequency and duration of your bathroom or coffee breaks on the grounds that ?you are getting paid twice as much as he is??
what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi
Hi, If anyone has base SAS certification dumps, please share.
What is connection profile? : sas-grid-administration
How can you limit the variables written to output dataset in data step?
How to test the debugging in sas?
what is business intelligence? : Sas-bi
What are the features of SAS?