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;
