topic Re: Reading in Data Set without $ in SAS Programming

Reading in Data Set without $

Steelersgirl — Sun, 28 Oct 2018 19:24:58 GMT

I am trying to read the following dataset in to SAS without money signs: http://people.stat.sc.edu/hitchcock/tshirt.txt.

I have been trying the following code and it is not printing values for the shipping costs column and I can't figure out how to get rid of the money signs.

DATA tshirt;
FILENAME webpage URL 'http://people.stat.sc.edu/hitchcock/tshirt.txt';
INFILE webpage;
INPUT size$color$price$shippingcosts;
RUN;

PROC PRINT DATA=tshirt;

Re: Reading in Data Set without $

novinosrin — Sun, 28 Oct 2018 19:33:03 GMT

data have;
input  size $ color $ /price comma10. /shippingcosts comma10.;
cards;
Large Red 
$19.77 
$0.35
Medium Green 
$25.36
$1.21
X-Large Blue 
$29.45
$1.76
Small Yellow 
$15.28
$0.92
;

Re: Reading in Data Set without $

novinosrin — Sun, 28 Oct 2018 19:35:14 GMT

And if you want format the output back to dollar for display, add the format statement with the appropriate format

format price shippingcosts dollar10.2;

Re: Reading in Data Set without $

novinosrin — Sun, 28 Oct 2018 19:41:27 GMT

@Steelersgirl Take this version plz

data have;
FILENAME webpage URL 'http://people.stat.sc.edu/hitchcock/tshirt.txt';
INFILE webpage;
input  size $ color $ /price : comma10. /shippingcosts : comma10.;
format price shippingcosts dollar10.2;
run;