Answer / s.sudarshanreddy

data l;
input d;
file print ods;
put _ods_;
cards;
1
2
3
4
4
5
5
;
run;

Answer / pambrose

Assuming the question is intended to automate the code..lets say for a monthly report.

here is the outlook of the code

data run_report;
day1 = day(today());
if day1 = 1 then call execute('%monthlyreports');
else.........
....
.........
run;

%monthlyreport;
SAS report generation
%mend;

Answer / s.sudarshanreddy

file print _ods_;

Answer / anjani sasprogrammer

data a;
input
emp_name $
emp_age
emp_sal
;
datalines;
a 23 20000
b 24 25000
;
run;
proc print data=a;
run;

what is option year cuttoff in sas

2 Answers   L&T,

---

I need help in merging two different datasets. I am merging by date and I want to propagate observations from one dataset to the corresponding dates. One dataset has a unique date for each day of the month, while the other dataset has same date for different patient visits. For example I want to spread an observation on the 31DEC2008 from one dataset to several observations with the same date on a second dataset for all the patients who visited on that date. I have tried to merge the two and the result is not what I wanted. Instead I get a dataset whereby all the dates have missing values where observations from the first datset should have spread.

1 Answers  

---

explain the function of substr in sas? : Sas-administrator

0 Answers  

---

how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming

0 Answers  

---

Which is the best training Institute for SAS Business Intelligence course?

6 Answers  

---

How do handle working under pressure?

1 Answers   Oracle, Wipro,

---

Differentiate between proc means and proc summary.

0 Answers  

---

How to read the file names of a text files from a shared drive using SAS?

1 Answers   HSBC, WNS,

---

what is hierarchy flattening? : Sas-di

0 Answers  

---

if you have 365 no of data set and each one having different variable from each other. how will you read by creating macros and create a single data set.

2 Answers  

---

DATA ABC; INPUT TDATE DATE9. AVG; CARDS; 18APR2008 150.00 19APR2008 167.00 20APR2008 123.00 21APR2008 145.00 ; RUN HOW CAN I FIND THE DIFFERENCE BETWEEN AVG OF 18APR2008 ANF 21APR2008?? IF ANY ONE GETS IT PLS TRY TO POST IT.

8 Answers   Verinon Technology Solutions,

---

what is _error_?

2 Answers   Axis Bank, Cognizant, JPMorgan Chase,

---