Hi Everyone,
I need help with my code execution which i am doing in SAS Studio. This code summarise the size and space information of a specific directory.
Please advise, what should i do?
-Error Log file is attached.
SAS Code:
/*1. Import Directory Usage*/ x du -k /home/deepankeranand0/DSP project > /home/deepankeranand0/DSP project/dirusage.log; DATA WORK.dirusage; LENGTH size_kb 8 path $ 512 ; LABEL size_kb = "path size in kb" path = "path on disc" ; FORMAT size_kb BEST9. path $CHAR96. ; INFORMAT size_kb BEST9. path $CHAR96. ; INFILE '/sas/data/ad-hoc2/fut_anal/TOOLS/sas_disc_usage/dirusage.log' DLM='09'x MISSOVER DSD ; INPUT size_kb : ?? BEST9. path : $CHAR96. ; RUN; /*2. Import File Usage*/ x du -ak /home/deepankeranand0/DSP project > /home/deepankeranand0/DSP project/fileusage.log; DATA WORK.fileusage; LENGTH size_kb 8 path $ 512 ; LABEL size_kb = "path size in kb" path = "path on disc" ; FORMAT size_kb BEST9. path $CHAR96. ; INFORMAT size_kb BEST9. path $CHAR96. ; INFILE '/home/deepankeranand0/DSP project/fileusage.log' DLM='09'x MISSOVER DSD ; INPUT size_kb : ?? BEST9. path : $CHAR96. ; RUN; /*3. DIRECTORITIES BY PATH*/ PROC SQL; CREATE VIEW WORK.DirSize_ByPath AS SELECT size_kb, (size_kb / 1024) as size_mb, (size_kb / (1024*1024)) as size_gb, path FROM WORK.DIRUSAGE ORDER BY path ASC ; QUIT; TITLE; TITLE1 "Size of Directories on Disc"; FOOTNOTE; FOOTNOTE1 "Generated by the SAS System (&_SASSERVERNAME, &SYSSCPL) on %TRIM(%QSYSFUNC(DATE(), NLDATE20.)) at %TRIM(%SYSFUNC(TIME(), NLTIMAP20.))"; PROC PRINT DATA=WORK.DirSize_ByPath OBS="Row number" LABEL ; VAR path size_gb size_mb; RUN; /* ------------------------------------------------------------------- End of task code. ------------------------------------------------------------------- */ RUN; QUIT; /*4. DIRECTORIES BY SIZE*/ PROC SQL; CREATE VIEW WORK.DirSize_BySize AS SELECT size_kb, (size_kb / 1024) as size_mb, (size_kb / (1024*1024)) as size_gb, path FROM WORK.DIRUSAGE ORDER BY size_kb DESC ; QUIT; TITLE; TITLE1 "Size of Directories on Disc"; FOOTNOTE; FOOTNOTE1 "Generated by the SAS System (&_SASSERVERNAME, &SYSSCPL) on %TRIM(%QSYSFUNC(DATE(), NLDATE20.)) at %TRIM(%SYSFUNC(TIME(), NLTIMAP20.))"; PROC PRINT DATA=WORK.DirSize_BySize OBS="Row number" LABEL ; VAR path size_gb size_mb; RUN; /* ------------------------------------------------------------------- End of task code. ------------------------------------------------------------------- */ RUN; QUIT; /*5. FILES&DIRECTORIESBYPATH*/ PROC SQL; CREATE VIEW WORK.DirSize_BySize AS SELECT size_kb, (size_kb / 1024) as size_mb, (size_kb / (1024*1024)) as size_gb, path FROM WORK.DIRUSAGE ORDER BY size_kb DESC ; QUIT; TITLE; TITLE1 "Size of Directories on Disc"; FOOTNOTE; FOOTNOTE1 "Generated by the SAS System (&_SASSERVERNAME, &SYSSCPL) on %TRIM(%QSYSFUNC(DATE(), NLDATE20.)) at %TRIM(%SYSFUNC(TIME(), NLTIMAP20.))"; PROC PRINT DATA=WORK.DirSize_BySize OBS="Row number" LABEL ; VAR path size_gb size_mb; RUN; /* ------------------------------------------------------------------- End of task code. ------------------------------------------------------------------- */ RUN; QUIT; /*6. FILES&DIRECTORIES BY SIZE*/ PROC SQL; CREATE VIEW WORK.FileSize_BySize AS SELECT size_kb, (size_kb / 1024) as size_mb, (size_kb / (1024*1024)) as size_gb, path FROM WORK.FILEUSAGE ORDER BY size_kb DESC ; QUIT; TITLE; TITLE1 "Size of Directories & Files on Disc"; FOOTNOTE; FOOTNOTE1 "Generated by the SAS System (&_SASSERVERNAME, &SYSSCPL) on %TRIM(%QSYSFUNC(DATE(), NLDATE20.)) at %TRIM(%SYSFUNC(TIME(), NLTIMAP20.))"; PROC PRINT DATA=WORK.FileSize_BySize OBS="Row number" LABEL ; VAR path size_gb size_mb; RUN; proc export data = WORK.FileSize_BySize outfile = '/home/deepankeranand0/DSP project/sas_disc.xls' dbms = xls; run; /* ------------------------------------------------------------------- End of task code. ------------------------------------------------------------------- */ RUN; QUIT;
... View more