i have a Healthfacts databse(Hf_f).I need to write a code to select hf_f diagnosis for the key visits.
proc sql;
select Diagnosis
from Hf_f
where Visit='key';
quit;
Not a well worded question!
proc sql;
select Diagnosis
from Hf_f
where Visit='key';
quit;
Not a well worded question!
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
what can i put inplace of dxids.?
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.