topic Re: Displaying count in a proc export statement in SAS Programming

Displaying count in a proc export statement

Q1983 — Fri, 10 Apr 2015 03:38:57 GMT

Proc sql;

Create table test as

Select ln, region

Case when ln ne ‘’ then count(ln) else 0 end as cnt

Quit;

Sample output

Ln region cnt

11 west 4

12 east 4

13 north 4

15 south 4

data _null_;

File "/server/file_&cnt..txt" (file__4..txt would be the exported output)

lrecl=30000 dsd dlm='|' termstr=crlf ;

run;

However I do not want to display the header cnt. I want output like this

11|west|

12|east|

The reason I chose to address the cnt in the proc statement is because I am not sure if there is a way to do a macro to count the

Number of recrods and then use it in the proc export statement

Reeza — Fri, 10 Apr 2015 03:49:19 GMT

If you have the CNT as a variable in your dataset you can use the FILEVAR option to name the file instead.

pradeepalankar — Fri, 10 Apr 2015 04:06:51 GMT

if you just want to put count of rows in the file name not split it on some variable then you may use this:

data source_table;

input Ln region :$5.;

cards;

11 west

12 east

13 north

15 south

;

proc sql;select count(ln) into :cnt from source_table;quit;

data _null_;

File "Serverpath\file__%TRIM(&cnt.).txt" lrecl=30000 dsd dlm='|' termstr=crlf ;

set source_table;

put LN region;

run;