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 10800Can 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 10487Hi , 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 41846) 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 5724Best trainer in hyderabad for sas banking.if any one have details pls provide contact details.
1 2837How does Mr.Lanka Srinivas teach SAS? Are his accomplishments real? What are the future prospects for SAS?
1 3523/*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 4448i 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 4998
what is sas metadata repository? : Sas-bi
how would you create multiple observations from a single observation? : Sas programming
how to remove duplicates using proc sql?
What are the limitations for memory allocation for SAS variables
how does sas handle missing values in formats? : Sas programming
Why double trailing @@ is used in input statement?
If you were told to create many records from one record, show how you would do this using array and with proc transpose?
What are the features of base sas system?
Which function is used to count the number of intervals between two sas dates?
What are the parameters of scan function?
How substr function works in sas?
Do you need to compute new variables? If so,should you do this before you execute the report-writing procedure?
for report generation which one you used proc report or data_null_?
How would you identify a macro variable?
If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?