topic Re: how to select in SAS Programming

how to select

lg2 — Thu, 31 May 2018 18:53:52 GMT

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

Haris — Thu, 31 May 2018 19:32:30 GMT

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

Not a well worded question!

lg2 — Thu, 31 May 2018 20:33:03 GMT

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 — Thu, 31 May 2018 20:38:52 GMT

Use variable Diagnosis_Description instead of Diagnosis_ID in your SELECT statement.

lg2 — Thu, 31 May 2018 20:48:36 GMT

what can i put inplace of dxids.?

Haris — Thu, 31 May 2018 20:58:11 GMT

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...