I work with SAS Enterprise Guide. I import data from external databases
and then work with the tools of Enterprise Guide (Query Builder, Summary Statistic, etc.) Occasionally I add to the Process Flow Programs in which I write the code myself.
I can add the Preview of the Query Builder in which I import the data, like the code attached here.
Is that helpful?
%_eg_conditional_dropds(WORK.QUERY_FOR_QHA4MWKGUYYQJA54R);
PROC SQL;
CREATE TABLE WORK.QUERY_FOR_QHA4MWKGUYYQJA54R AS
SELECT DISTINCT t1.TICKER,
t1.ACT_STD,
t1.ACTION,
t1.ACTTIMS,
t1.ANNDATS,
t1.ANNTIMS,
t1.CURR,
t1.DIFF_CODE,
t1.EEFYMO,
t1.GUIDANCE_CODE,
t1.MEAN_AT_DATE,
t1.MEASURE,
t1.MOD_DATE,
t1.MOD_TIME,
t1.ACTDATS,
t1.PDICITY,
t1.PRD_MON,
t1.PRD_YR,
t1.RANGE_DESC,
t1.UNITS,
t1.USFIRM,
t1.VAL_1,
t1.VAL_2,
/* value_forcast */
(t1.VAL_1) AS value_forcast
FROM TMP00001.qha4mwkguyyqja54r t1
WHERE t1.MEASURE IN ('EPS') AND t1.PDICITY IN ('ANN' )
ORDER BY t1.TICKER,
t1.PRD_YR,
t1.PRD_MON,
t1.ACTDATS;
QUIT;
... View more