topic Getting three outputs from the same dataset in SAS Programming

Getting three outputs from the same dataset

sasthebest — Wed, 19 Jun 2013 21:35:12 GMT

I want three outputs in one dataset and I also want each output to read from “tourrevenue dataset” and not the previous output.

As you may notice there is no data in third output because it is reading from the previous dataset. I want it to have data from tourrevenue where Vendor = 'World'.

data tourrevenue;

input Country $ 1-11 LandCost Vendor $ NumberOfBookings;

cards;

France 575 Express 10

Spain 510 World 12

Brazil 540 World 6

India 489 Express .

Japan 720 Express 10

Greece 698 Express 20

New Zealand 1489 Southsea 6

Venezuela 425 World 8

Italy 468 Express 9

Russia 924 World 6

Switzerland 734 World 20

Australia 1079 Southsea 10

Ireland 558 Express 9

;

Run;

Data Three_outputs;

set tourrevenue;

Disc = 'Data';

Output;

Disc = 'Ori';

IF Vendor = 'Express';

output;

LandCost = 0-LandCost ;

Disc = 'rvs';

IF Vendor = 'World';

output;

Run;

Proc sort data= Three_outputs out=Results;

by Disc;

Run;

Re: Getting three outputs from the same dataset

Reeza — Wed, 19 Jun 2013 22:29:26 GMT

There is only ever one dataset being read.

Do you intend to have

if vendor="Express" then output;

rather than two separate lines?

Currently your IF statement will only select Express and then your next IF will never be true. I'm not sure what you're intending to do with the retain statement as well.

I think you're looking for something like (untested)

Data Three_outputs;

set tourrevenue;

IF Vendor = 'Express' then do;;

LandCost = Original_amt ;

Disc = 'Ori';

output;

end;

else if vendor='World' then do;

LandCost = 0-LandCost ;

Disc = 'rvs';

output;

end;

else do;

disc='Data';

output;

end;

Run;

Proc sort data= a out=Results;

by Disc;

Run;

Re: Getting three outputs from the same dataset

Astounding — Thu, 20 Jun 2013 00:39:30 GMT

You'll need to do a better job explaining your goal here. The sample code you provided has many flaws, including referring to a data set "a" that doesn't exist, and referring to a variable "original_amt" that doesn't exist. There are other problems, such as the effects of the IF statement. You would be better off showing the "after" picture to match the "before" data in your post. There would be many posters willing to help at that point.

Good luck.