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.?
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.