topic Output data with zero observations in SAS Programming

Output data with zero observations

ivethguzman — Sun, 13 Oct 2019 02:46:32 GMT

data HW1;
infile '/folders/myfolders/MY SAS Files/Data/newstate.sas7bdat' dlm=',';
input state :$35
 region :$10
 visits
 salesman
 sale
 expenses;
label state = 'State Name'
	  region = 'Region Assignment'
	  visits = 'Visits from Regional Manager'
	  salesman = 'Number of Salesmen'
	  sale = 'Gross Sales For Last Quarter'
	  expenses= 'Advertising Expenses For Last Quarter'
;
run;
proc contents data=HW1;
run;
/**/
proc print data=HW1;
run;

Hello, I can't figure out why the observations are not showing. The variables names are correct and so is the file location.

Re: Output data with zero observations

PGStats — Sun, 13 Oct 2019 03:26:14 GMT

newstate.sas7bdat is a dataset, you can't read it as a text file.

Simply define the location as a library:

libname myLib "/folders/myfolders/MY SAS Files/Data";

and access the dataset, for example:

proc means data=myLib.newstate;

by region;

var expenses;

run;

Re: Output data with zero observations

ivethguzman — Sun, 13 Oct 2019 03:36:25 GMT

Thank you for clarifying, now my code works