topic Re: problem facing to deal with delimiter files. in SAS Studio

problem facing to deal with delimiter files.

u39734216 — Tue, 13 Aug 2019 12:27:13 GMT

Hi all,

I have data set which has delimiter values like this 1Sep11 389.00 1Oct11 491.00 1Nov11 370.00 1Dec11 335.00

and I want to get these values in two columns like Date and sales amount. I was this code. pls, can anyone tell me what I'm doing wrong?

data Daily_sales;
infile 'D:\SASUniversityEdition\Daily_sales.txt';
input Date Sales_Amount @@;
format date Sales_Amount ;
run;

Re: problem facing to deal with delimiter files.

novinosrin — Tue, 13 Aug 2019 12:31:10 GMT

data Daily_sales;
infile 'D:\SASUniversityEdition\Daily_sales.txt';
input Date :DATE7. Sales_Amount  @@;
format date DATE9. Sales_Amount ;
run;

Re: problem facing to deal with delimiter files.

PeterClemmensen — Tue, 13 Aug 2019 12:31:12 GMT

Please describe what the problem is? How does your result differ from the result you want to see?

Re: problem facing to deal with delimiter files.

u39734216 — Tue, 13 Aug 2019 12:46:13 GMT

It is not giving me the sales amount in a proper way. Like 389.00

It's showing me 389 only.

Re: problem facing to deal with delimiter files.

novinosrin — Tue, 13 Aug 2019 12:47:42 GMT

hello @u39734216 If format is your concern, try this format

format date DATE9. Sales_Amount 8.2 ;

Re: problem facing to deal with delimiter files.

ballardw — Tue, 13 Aug 2019 14:23:15 GMT

@u39734216 wrote:
It is not giving me the sales amount in a proper way. Like 389.00

It's showing me 389 only.

If you do not assign a specific display format then SAS will use one of the BEST formats, often BEST12. One behavior of the BEST formats is that if there is no non-zero decimal portion they are not displayed.

Understanding what Formats and Informats do is a key part of the flexibility of SAS.

Consider the following program code. If you submit it and examine the log you will see several different, by no means all, formats applied to the same value.

data junk;
   x=389.00;
   put "Fixed 8.2 " x= f8.2 "dollar 8.2 " x= dollar8.2
       "Leading zero " x= z8.2  "word  " x= wordf30.;

run;

Re: problem facing to deal with delimiter files.

Reeza — Tue, 13 Aug 2019 15:19:03 GMT

I'm 80% certain you're going to have errors throughout your log, since you're path includes SAS University Edition.

For starters the file path is likely incorrect if you're actually using SAS University edition so that will give you a file not found error.

Fix the file path first and then you can figure out if the rest of your code works or doesn't.

The filepath should likely be:

infile '/folders/myfolders/Daily_sales.txt';

SAS University Edition runs on a Unix system so you need Unix file paths, not Windows and unless you've set up your own shared folders you need to place your files in the myfolders folder you set up during installation.