My excel files are coming from my company data base website. They are downloaded each Monday morning with the new weeks data at 3am. The scheduled exports only option is to export as an excel file and does not have a CSV option.   How would I import all files with one step? ... View more

PROC SORT DATA=WORK.QUERY_FOR_APPEND_TABLE_0001(FIRSTOBS=1 KEEP="At Risk?"n Origin Destination Units "% OT"n "% <1"n "% <2"n "% <4"n "% <6"n "% <12"n "% <24"n "<48"n) OUT=WORK.SORTTempTableSorted ; BY "At Risk?"n; RUN; TITLE; TITLE1 "Report Listing"; FOOTNOTE; FOOTNOTE1 "Generated by the SAS System (&_SASSERVERNAME, &SYSSCPL) on %TRIM(%QSYSFUNC(DATE(), NLDATE20.)) at %TRIM(%SYSFUNC(TIME(), TIMEAMPM12.))"; PROC PRINT DATA=WORK.SORTTempTableSorted NOOBS LABEL ROWS=PAGE ; VAR "At Risk?"n Origin Destination Units "% OT"n "% <1"n "% <2"n "% <4"n "% <6"n "% <12"n "% <24"n "<48"n; BY "At Risk?"n; PAGEBY "At Risk?"n; SUM Units "% OT"n "% <1"n "% <2"n "% <4"n "% <6"n "% <12"n "% <24"n "<48"n; LABEL "At Risk?"n=" "; RUN; /* ------------------------------------------------------------------- End of task code ------------------------------------------------------------------- */ RUN; QUIT; %_eg_conditional_dropds(WORK.SORTTempTableSorted); TITLE; FOOTNOTE; ... View more

TITLE; TITLE1 "Summary Tables"; FOOTNOTE; FOOTNOTE1 "Generated by the SAS System (&_SASSERVERNAME, &SYSSCPL) on %TRIM(%QSYSFUNC(DATE(), NLDATE20.)) at %TRIM(%SYSFUNC(TIME(), TIMEAMPM12.))"; /* ------------------------------------------------------------------- Code generated by SAS Task Generated on: Wednesday, September 27, 2017 at 3:40:58 PM By task: Summary Tables (2) Input Data: SASApp:WORK.QUERY_FOR_APPEND_TABLE_0001 Server: SASApp ------------------------------------------------------------------- */ /* ------------------------------------------------------------------- Run the tabulate procedure ------------------------------------------------------------------- */ PROC TABULATE DATA=WORK.QUERY_FOR_APPEND_TABLE_0001 ; VAR Units "COST"n; CLASS Origin / ORDER=UNFORMATTED MISSING; CLASS Destination / ORDER=UNFORMATTED MISSING MLF; TABLE /* Row Dimension */ 'Origin'n*( Destination ALL={LABEL="Total (ALL)"}), /* Column Dimension */ COST* Sum; ; RUN; /* ------------------------------------------------------------------- End of task code ------------------------------------------------------------------- */ RUN; QUIT; TITLE; FOOTNOTE; ... View more

I have my starting point whch is a data set that I have created and manipulated. Then I have selected Tasks > Describe > Summary Tables.   Data Tab: Analysis Variable = Cost Classification Variables = Origin, Destination   Summary Tables Tab: Placed them where I want them.   Run. ... View more

It is EDMP, the W was an error from my tech support.   I was finally directed to someone who said I do need access to the Oracel Client to set up ODCB. So I have put that request in. Once it is approved I will come back and try the suggetions above once more. ... View more

When I enter the suggested code above it states I do not have any datasets. I contacted my IT and I was told it should be good to go, and the "ODBC data source is just the name of the database you want to use as a source for your data – so you have to identify that yourself first – could be EDWP or SAST or any other." So still unsure of why it is not working....   ... View more

libname CVS oracle user=XXXX password=XXXX PATH='edmp' schema='cvs_own'; DATA NEW; SET CVS.IDWE_D_CALENDAR; RUN; PROC SQL; CREATE TABLE NEW AS SELECT *FROM CVS.D_CALENDAR; QUIT; Above is the code I have so far. Seems to work up until the SET step. I recieve the error "File CVS.IDWE_D_CALENDAR.DATA does not exist."   I just stuck the table name in refrencing the example given above but not sure I referenced it accurately.   ... View more

Yes, it is installed on a server. Using your resource I was stopped at the "administrative tools" step because i dont have those privledges. ... View more