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.?
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.