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 10441Can 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 10167Hi , 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 39606) 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 5526Best trainer in hyderabad for sas banking.if any one have details pls provide contact details.
1 2704How 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 4245i 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 4742
if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation
What is the difference between class statement and by statement in proc means?
I need level 2 to 5 sas using companies in india
What is the use of the %include statement?
What are the table names in oracle database...?
How to read an input file in sas?
Name and describe few sas character functions that are used for data cleaning in brief.
name the scheduler for scheduling job and explain the scheduler? : Sas-di
which date function advances a date, time or datetime value by a given interval? : Sas programming
What are the parameters of scan function?
what is the difference between unique key and primary key? : Sas-di
What is the maximum length of the macro variable?
what is sas database server? : Sas-di
explain the proc in sas? : Sas-administrator
What is the maximum length of the macro variable? : sas-macro