SAS Question- How to Place the Column Postion in Proc Print

er.manishawasthii · New User Joined: 24 Oct 2008 Posts: 6 Location: Pune

In this code i want to Place the column Postion in Proc Print .....

Means i need to fix the postion of column headings and its records to certain varibles ..... EMP no should start from 6 column , name should start from 15 and dept name should start from 32 postion how Could i do that...........

er.manishawasthii · New User Joined: 24 Oct 2008 Posts: 6 Location: Pune

here is the code
PROC SQL;
CREATE TABLE REPT AS
SELECT E.ENO,E.ENAME,D.DEPT_NAME
FROM EMPLOYEE E, DEPT D
WHERE E.EDEPT_CD = D.DEPT_CD
AND ESTATUS = 'A' ‘
AND ESAL BETWEEN 10000 AND 20000
ORDER BY DEPT_NAME ,ENO
%PUT &SYSDBRC;
RUN;

DATA _NULL_;
IF "&SYSDBRC" NOT IN ('0','100') THEN DO;
PUT 'READING SASCNT DB2 RETURN CODE : ' "&SYSDBRC";
ABORT ABEND;
END;
RUN;

PROC PRINT DATA = REPT LABEL NOOBS;

TITLE1 ' XYZ ORGANIZATION';
TITLE2 ' ACTIVE EMPLOYEES REPORT DT:' &SYSDATE;

LABEL EMPNO = 'EMPLOYEE_NO';
LABEL NAME = 'NAME ';
LABEL DEPT = 'DEPT_NAME';

RUN;

Robert Sample · Posted: Tue Dec 09, 2008 7:19 pm

PROC PRINT does not allow you to set columns for its output. You can use PUT statements in a DATA step to control exact columns, but if you use PROC PRINT you have relatively little control over the format of the output report.

expat · Posted: Tue Dec 09, 2008 9:07 pm

Why the "must do" for column positions ?
As Robert has correctly stated, this is not an option in PROC PRINT.

You could do it using filler fields, but that is oh sooooooooooooooo messy a way to do it.

er.manishawasthii · New User Joined: 24 Oct 2008 Posts: 6 Location: Pune

@ expat could u please explain it how could i do this using the filler filelds.......

Actually i don't want to use PUT statments and Data steps . I would like to learn about PROC PRINT . I have already made the previous code using the Put statments in Dta step . This time i thought of doing it in a diffrent way........using Proc Print

expat · Posted: Wed Dec 10, 2008 2:29 pm

Filler fields are blanks set to specific lengths to allow you to format the output from proc print, should you so wish to do.

Why the must for certain columns ?