topic Re: Proc Export w/ repeating Variables in SAS Procedures

Proc Export w/ repeating Variables

tqphan — Wed, 19 Oct 2016 18:25:10 GMT

I'm running a report and exporting the data to a CSV file but wondered if there was a way to remove the repeating values in the first column.

The way the data file is set up is that the IDs are duplicated based on whether are multiple values in any of the columns so each observation is unique and I dont want to remove them. I guess this would be for mainly an asthetic value.

Output Example:

ID Col1 Col2 Col3 …

Loan A X A B …

~~Loan A~~ X C D …

~~Loan A~~ X E F …

Loan B A Y C …

~~Loan B~~ B Y D …

Loan C … … … …

Loan D … … … …

Re: Proc Export w/ repeating Variables

Shmuel — Wed, 19 Oct 2016 19:13:32 GMT

It can be done using PROC REPORT :

proc report data=have;

columns ID COL1 COL2 COL3 ...;

define ID / order ;

define COL1;

define COL2;

define COL3;

...

run;

Re: Proc Export w/ repeating Variables

tqphan — Wed, 19 Oct 2016 19:18:06 GMT

Shmuel,

Can I output to a CSV using PROC REPORT then same way as PROC EXPORT?

Re: Proc Export w/ repeating Variables

ballardw — Wed, 19 Oct 2016 19:33:23 GMT

Exporting data will do that.

CSV is intended for data interchange in which case you would not really want the values to dispear from some records.

If you use a report procedure such as Proc Report or Tabulate that will allow things to group then you could write the results fo the procedure. Since it sounds like you may actually want a report and not a data interchange then use ODS RTF or PDF with an appropriate report procedure.

Re: Proc Export w/ repeating Variables

RW9 — Thu, 20 Oct 2016 08:38:47 GMT

CSV = Comma Separated Variable text file. Is designed for data transfer. It is not an Excel file!

Now decide what you want that output for, if it is to send data somewhere, then go ahead and export to CSV, and all the data will appear, ID on each line per the definition of a CSV. If however you just want some review output in Excel, then use proc report and create a report in an Excel file - ods tagsets.excelxp or excel will do the trick and you have all the functionality therein.

Again, CSV is not the same as Excel.