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.?
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.