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 7277Can 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 7276Hi , 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 21186) 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 3186Best trainer in hyderabad for sas banking.if any one have details pls provide contact details.
1 1354How does Mr.Lanka Srinivas teach SAS? Are his accomplishments real? What are the future prospects for SAS?
1 1824/*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 2419i 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 2326
describe about metadata object? : Sas-di
what is sas application server, database server, sas olap server and sas metadata server? : Sas-di
Mention what are the data types does SAS contain?
What are the difference between sas functions and procedures?
For what purposes have you used sas macros? : sas-macro
How to limit decimal places for variable using proc means?
which date functions advances a date time or date/time value by a given interval? : Sas programming
which features do you use to check the data validations and errors? : Sas-administrator
what is snowflake schema? : Sas-di
Enlist the syntax rules followed in sas statements.
Name and describe few sas character functions that are used for data cleaning in brief.
explain what is factor analysis? : Sas-administrator
WHAT IS SAS WEB SERVICE and what are the steps to create an xml service ?
in the flow of data step processing, what is the first action in a typical data step? : Sas programming
How you can read the variables that you need?
