Answer / Soni Chauhan

"In SAS, you can test for missing values using the MISSING() function. The MISSING() function returns a missing value indicator (.) if its argument is missing, and a non-missing value otherwise."

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  

---

Can we replace a dataset into view?

6 Answers   CliniRx,

---

Can you use a macro within another macro? If so how would SAS know where the current acro ended and the new one began?

2 Answers  

---

Explain by-group processing?

1 Answers  

---

What are the default statistics that proc means produce?

1 Answers  

---

libname deepak 'C:\SAS Files'; proc format; invalue convert 'A+' = 100 'A' = 96 'A-' = 92 'B+' = 88 'B' = 84 'B-' = 80 'C+' = 76 'C' = 72 'F' = 65; data deepak.grades; input ID $3. Grade convert.; *format Grade convert. ; datalines; 001 A- 002 B+ 003 F 004 C+ 005 A ; proc print data = deepak.grades; run; I get the following output Obs ID Grade 1 001 . 2 002 . 3 003 . 4 004 . 5 005 . I don’t understand why Grade shows up as a missing value. Everything seems fine, including ID $3. Now, in case I use ID : $3. Or use column input, I get the desired output. Kindly help Deepak

7 Answers  

---

how do u identify a macro variable

5 Answers  

---

In ARRAY processing, what does the DIM function do?

1 Answers  

---

What are _numeric_ and _character_ and what do they do?

1 Answers   Quintiles,

---

what is hash files in sas and why we are using this one in sas?

1 Answers   L&T, SAS,

---

What are the rows present in protocol Violation table?

2 Answers   Accenture, Quintiles,

---

how to import HTML files into SAS datasets?

3 Answers   HP,

---