how to select

[lg2]

i have a Healthfacts databse(Hf_f).I need to write a code to select hf_f diagnosis for the key visits.

[Haris · Accepted solution]

proc sql;
    select Diagnosis
    from Hf_f
    where Visit='key';
quit;

Not a well worded question!

[lg2]

proc sql;
select
distinct DIAGNOSIS_ID
into
:dxids SEPARATED BY ","
from
HFD17A.HF_D_DIAGNOSIS
where
PUT(STRIP(DIAGNOSIS_CODE),$MYDX.) NE "OTHER"
;

if i do this my output was 

dxids

1324

4320

23345

6120

Now i wanted the output as

diagnosis description

depression

stress

anxiety

How do i modify the above code to get indescpritve way

[Haris]

Use variable Diagnosis_Description instead of Diagnosis_ID in your SELECT statement.

[lg2]

what can i put inplace of dxids.?

[Haris]

I don't know the details of your data or what you're trying to accomplish; i.e., why you are writing the diagnoses into a macro...