|
Yes!!! It did happen with the DATA Statement
AABCC 40 40
CAS 1 24
JHHKK 15 29
XYZZZ 33 56
E: There were 7 observations read from the data set WORK.TEMP1.
> -----Original Message-----
> From: Srna, Carol (C.)
> Sent: Monday, October 31, 2005 10:15 AM
> To: 'SAS-L@LISTSERV.UGA.EDU'
> Subject: PROC SQL/DATA STEP
>
>
>
> Output from PROC SQL: (which is what I want).
> 1The SAS System
>
> Obs DSN GBS
>
> 1 AABCC 40
> 2 CAS 24
> 3 JHHKK 29
> 4 XYZZZ 56
> **********************
> SQL Code:
> PROC SQL;
> CREATE TABLE DSNS AS
> SELECT DISTINCT DSN,
> SUM(GBS) AS GBS
> FROM TEMP1
> GROUP BY DSN ;
> QUIT;
>
> PROC PRINT;
> ****************************
>
>
> Output from DATA Step: Where did I go wrong with my Data step. I
> want the Output to look the Output that PROC SQL produced.
> 1The SAS System Thank You.
>
> Obs GBS DSN
>
> 1 40 AABCC
> 2 23 CAS
> 3 1 CAS
> 4 14 JHHKK
> 5 15 JHHKK
> 6 23 XYZZZ
> 7 33 XYZZZ
> DATA TEMP;
> RETAIN GBS;
> INPUT DSN $ 8-12 GBS 17-18;
> CARDS;
> CAS 23
> CAS 1
> AABCC 40
> XYZZZ 23
> XYZZZ 33
> JHHKK 14
> JHHKK 15
> ;
>
> PROC SORT DATA=TEMP OUT=TEMP1;
> BY DSN;
> RUN;
>
> DATA _NULL_;
> SET TEMP1;
> IF FIRST.DSN THEN DO;
> TOTGB+GBS=0;
> END;
> IF LAST.DSN THEN DO;
> PUT @5 DSN
> @50 GBS
> @62 TOTGB;
> END;
> RUN:
>
> PROC PRINT;
|
