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 8955Can 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 8726Hi , 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 30876) 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 4541Best trainer in hyderabad for sas banking.if any one have details pls provide contact details.
1 2130How does Mr.Lanka Srinivas teach SAS? Are his accomplishments real? What are the future prospects for SAS?
1 2668/*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 3450i 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 3512
Describe what are the different levels of administrative users in sas? : sas-grid-administration
Explain the main difference between the sas procedures and functions? : Sas-administrator
What are all the problems you faced while validating tables and reports?
Explain what is the use of proc gplot?
hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana
if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming
what is hash files in sas and why we are using this one in sas?
what is the one statement to set the criteria of data that can be coded in any step? : Sas programming
How many ways to overcome a missing values???
Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?
Which date function advances a date, time or datetime value by a given interval?
What is data _null_?
Tell e how how dealt with..
what is snowflake schema? : Sas-di
how many display types available in sas bi dashboard? : Sas-bi