topic Re: How to convert sas dataset file to TXT file. Thanks. in New SAS User

How to convert sas dataset file to TXT file. Thanks.

beewise — Fri, 18 Nov 2022 04:39:05 GMT

Re: How to convert sas dataset file to TXT file. Thanks.

Tom — Fri, 18 Nov 2022 05:40:40 GMT

How about a CSV file?

data _null_;
  set have;
  file "filename.csv" dsd ;
  put (_all_) (+0);
run;

With a little more work you can add a header row that shows the names of the variables also.

Re: How to convert sas dataset file to TXT file. Thanks.

Patrick — Fri, 18 Nov 2022 22:27:42 GMT

...or Proc Export or macro %ds2csv

Re: How to convert sas dataset file to TXT file. Thanks.

ballardw — Fri, 18 Nov 2022 22:49:40 GMT

With a couple of ways to create CSV mentioned it may be time to ask "what flavor of text file?" Other than CSV (comman separated values) there are other characters used to separate each value. Common choices are tab and pipe (|) characters, less frequently colons or semicolons. Sometimes multiple characters.

Or maybe fixed width where each column (variable) has text start in the some character position.

Or maybe something less common like Named output where you indicate a variable name followed by an = and the value, which would include quotes when there are spaces: somevar="This a named value"

Or perhaps other specific text file formats like JSON, XML or similar.

Or even a report layout?

Re: How to convert sas dataset file to TXT file. Thanks.

SASKiwi — Sun, 20 Nov 2022 23:41:55 GMT

What's the reason for converting to a text file? If we knew what you are planning to use them for we can offer more informed advice.