topic Re: Datalines Statement Producing Blanks in New SAS User

Datalines Statement Producing Blanks

davidvalentine — Mon, 13 Jan 2020 16:39:30 GMT

Hello Beautiful People!

I have a simple SAS program that's producing blanks when I run it. The program is below (my intention is for the program to produce what the datalines statement shows):

data work.example_2012;
infile datalines dsd;
	input
	Month monyy6.
	Sales: dollars.;
	format month monyy. Sales dollars4.2;
;
datalines;
12-Jan $1,000.00 
12-Feb $2,000.00 
12-Mar $3,000.00 
12-Apr $4,000.00
12-May $5,000.00 
12-Jun $6,000.00
12-Jul $7,000.00
12-Aug $8,000.00 
12-Sep $9,000.00 
12-Oct $10,000.00
12-Nov $11,000.00 
12-Dec $12,000.00 
;
run;

And the output is like so:

Month Sales
.	.   
.	.  
.	.  
.	.  
.	.  
.	.  
.	.  
.	.  
.	.  
.	.  
.	.  
.	.

Can someone tell me what I'm doing wrong? Any guidance is greatly appreciated!

-Valentine

Re: Datalines Statement Producing Blanks

PeterClemmensen — Mon, 13 Jan 2020 16:45:15 GMT

What date do your want 12-feb to resolve to? 12 feb 2020? 2019?

Re: Datalines Statement Producing Blanks

davidvalentine — Mon, 13 Jan 2020 16:46:30 GMT

Hi draycut,

I'd like the date to come out to the following format: "12-Jan" although I'm not picky about it as much as I need the Sales to be $xxxx.xx

Re: Datalines Statement Producing Blanks

novinosrin — Mon, 13 Jan 2020 17:01:28 GMT

HI @davidvalentine If you are not really picky, plz read as char and not bother with informat and format

data work.example_2012;
infile datalines ;
	input
	month $
	Sales: dollar10.;
	format  Sales dollar10.2;
;
datalines;
12-Jan $1,000.00 
12-Feb $2,000.00 
12-Mar $3,000.00 
12-Apr $4,000.00
12-May $5,000.00 
12-Jun $6,000.00
12-Jul $7,000.00
12-Aug $8,000.00 
12-Sep $9,000.00 
12-Oct $10,000.00
12-Nov $11,000.00 
12-Dec $12,000.00 
;
run;

Re: Datalines Statement Producing Blanks

davidvalentine — Mon, 13 Jan 2020 16:59:53 GMT

Perfect; this gets the job done. Thank you!!!