About lg2

lg2 · ‎06-05-2018

/* Create dim table report for google sheet */ proc sql; create table DXCLASS as select * put(..xyz) from xyz where DIAGNOSIS_ID ; quit; I have created a dimension table and i have got the results in a table .I want to copy the table to an excel.How to copy my results of the table from sas to an excel, Edit: via @Reeza - to modify the subject line to be more descriptive.

lg2 · ‎06-01-2018

I have database with diagnosis description.(example like mood disorders,sleep disorders..)I want to find the diagnosis id with that description.How to create a program for that?

lg2 · ‎05-31-2018

what can i put inplace of dxids.?

lg2 · ‎05-31-2018

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

lg2 · ‎05-31-2018

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

lg2 · ‎05-24-2018

i have a code as below. proc sql; create table sel_me as select * question:why do we use select*

Online Status	Offline
Date Last Visited	‎07-25-2018 04:33 PM

Copying a SAS table to Excel

regarding proc sql

Re: how to select

Re: how to select

how to select

PROC SQL - SELECT * - what is the * for?

Copying a SAS table to Excel

regarding proc sql

Re: how to select

Re: how to select

how to select

PROC SQL - SELECT * - what is the * for?