how to add distinctly var variable values ex.. Data a; input var; datalines; 0 1 2 3 -1 -2 -3 ; run; adding all +ve value in one varibale n do the same for -ve too
CTS,
5 10429Can we use where and having clauses in a single SAS program.
ex: proc sql;
select a,b,c from test
where state in 'KA'
and having
UHG,
4 10160Hi , which book should i refer to for preaparing SAS statistical Exam. Searched a lot on books but still did n't find relevant books
2 39576) Explain about below automatic variables a) _N_ b) _ERROR_ c) _CHAR_ d) _NUMERIC_ e) _ALL_ f) FIRST.BY VARIABLE g) LAST.BY VARIABLE h) _NAME_ i) _TYPE_ j) _FREQ_ k) _STAT_ l) _BREAK
1 5522Best trainer in hyderabad for sas banking.if any one have details pls provide contact details.
1 2703How does Mr.Lanka Srinivas teach SAS? Are his accomplishments real? What are the future prospects for SAS?
1 3360/*i have the following dataset.*/ data score; input marks ; datalines; 10 20 30 40 50 60 70 80 90 100 ; run; Now i should get the result as sum of 1 to 5 i.e(10+20+30+40+50)=150 and 2 to 6 i.e(20+30+40+50+60)=200 and 3 to 7 i.e(30+40+50+60+70)=250 and so on. how to get it. thanks in advance
2 4244i have multiple .csv files in a unix directory. every file is having variable names as header.even for empty file also. suppose take 3 files a.csv b.csv c.csv a.csv contains data as name;age,salary; raja;34;4000; ravi;33;5000; kumar;25;3000; b.csv contains data as name;age,salary; ajay;40;4500; and c.csv contains name;age,salary; (only headers) Now i want to import and append all these files in to a single dataset. i tried infile statement with *.csv to import all at a time. but i m not getting correct data. please help me . its urgent. thank you in advance
2 4735
Explain what Proc glm does?
I have a dataset concat having a variable a b & c. How to rename a b to e & f?
What is the use of stop statement?
how would you create multiple observations from a single observation? : Sas programming
Difference between sum function and using “+” operator?
Mention the difference between ceil and floor functions in sas?
what are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming
Have you used macros? For what purpose you have used? : sas-macro
Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?
what is the different between functions and procs that calculate the same simple descriptive statistics? : Sas programming
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?
Name and describe few sas character functions that are used for data cleaning in brief.
what do the sas log messages "numeric values have been converted to character" mean? : Sas programming
What versions of SAS have you used (on which platforms)?
describe about metadata object? : Sas-di