topic Re: Is it normal for output looking like this? in SAS Studio

Is it normal for output looking like this?

jc3992 — Tue, 30 Jan 2018 18:11:46 GMT

data cars93ff2;
infile '&dirdata.cars93subfree.txt' firstobs=2;
length Manufacturer $10;
input Manufacturer $ Type $ Price MPG_city MPG_highway Horsepower Origin$;
run;

data cars93ffraw;
length Manufacturer $10;
input Manufacturer $ Type $ MPG_city MPG_highway Horsepower Origin $;
datalines;
Buick Midsize 15.7 22 31 110 USA
Buick Large 23.7 16 25 180 USA
Cadillac Midsize 40.1 16 25 295 USA
Chevrolet Sporty 15.1 19 28 160 USA
Chrylser Large 18.4 20 28 153 USA
Dodge Small 9.2 29 33 92 USA
Dodge Small 11.3 23 29 93 USA
Dodge Van 19 17 21 142 USA
Eagle Small 12.2 29 33 92 USA
Eagle Large 19.3 20 28 214 USA
Ford Small 10.1 23 30 127 USA
Ford Compact 11.3 22 27 96 USA
Ford Midsize 20.2 21 30 140 USA
Geo Sporty 12.5 30 36 90 non-USA
Lexus Midsize 28 18 24 185 non-USA
Mazda Small 8.3 29 37 82 non-USA
Mazda Sporty 32.5 17 25 255 non-USA
Nissan Compact 15.7 24 30 150 non-USA
Oldsmobile Compact 13.5 24 31 155 USA
Pontiac Small 9 31 41 74 USA
;


proc compare base=cars93ff2 compare=cars93ffraw;
run;

Re: Is it normal for output looking like this?

ballardw — Tue, 30 Jan 2018 18:17:53 GMT

Looks pretty typical for Proc Compare. What specific issue do you think you have?

Sort order can have a big impact on proc compare for common observations. You might get a different result by sorting both of the data sets by Manufacturer and Type.

Re: Is it normal for output looking like this?

Shmuel — Tue, 30 Jan 2018 19:28:49 GMT

According to proc compare report one of the datasets has 0 observations while the other has 20.

Check - is 0 obs are correct or do are there any errors in log reading the dataset.

Try also usig proc compare with some options - datsets should be sorted by ID:

proc compare base=cars93ff2 compare=cars93ffraw  ;
    ID  Manufacturer ;
run;

Re: Is it normal for output looking like this?

jc3992 — Tue, 30 Jan 2018 20:30:13 GMT

Hello,

Thank you very much!

Yes I did notice that 0 obs.

I will check out on it again and ask my instructor.

Thanks!