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 13062/* 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 5529hi 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?
2121how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?
2759Does 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 5809i 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 7614
WHAT IS SAS WEB SERVICE and what are the steps to create an xml service ?
what is the use of proc sql? : Sas programming
For what purpose would you use the RETAIN statement?
How do you use the do loop if you don’t know how many times you should execute the do loop?
Give an example where SAS fails to convert character value to numeric value automatically?
describe the interaction table in sas di? : Sas-di
what is slowly changing dimension? : Sas-di
What are the applications primarily used by business analyst? : Sas-bi
what is the basic structure sas administrator? : Sas-administrator
what is factor analysis? : Sas-administrator
How do you control the number of observations and/or variables read or written?
Mention sas system options to debug sas macros.
Name validation tools used in SAS
What is the work of tranwrd function?
do you need to know if there are any missing values? : Sas programming