topic First SAS program in SAS Procedures

First SAS program

Sasanytics — Sun, 19 Feb 2012 14:49:42 GMT

Hi All,

I'm writing my first SAS program and I need some guidance on something very simple:

I need to read a dataset from an excel file with multiple sheets (but I need to read one sheet). Here's the code I came with that doesn't work sofar. I needed to print the first 20 observations

* Read data from external file into SAS data set;

DATA Orders;

INFILE 'C:\MySAS\Orders.xls';

sheet = "test";

INPUT OrdNum CustName CustAdd CustCd Item Price;

Run;

PROC PRINT DATA = Orders;

sheet = "test";

TITLE 'MyOrders';

Run;

Any help is greatly appreciated.

Thanks,

First SAS program

art297 — Sun, 19 Feb 2012 14:55:32 GMT

You can't use the input method you've shown for importing a spreadsheet. You can either use proc import, assigning the spreadsheet to a libname, or what is called DDE.

You can accomplish the first one simply by clicking on file import, from the menu bar. If you want to see the code that is actually submitted, during the processing one of the questions the system will ask you is whether you want to save the program that was created.

First SAS program

Sasanytics — Sun, 19 Feb 2012 15:16:43 GMT

Thanks for the response. I have tried to import the file, but I keep getting errors that the class is not registered and error in the LIBNAME statement.

Thanks

First SAS program

art297 — Sun, 19 Feb 2012 15:26:03 GMT

The first two methods I suggested require the license of a product called SAS/Access for pcfiles. If you don't have that, then your alternatives are either to used DDE (which I wouldn't recommend for someone who is just learning SAS), an already developed macro that uses DDE in the background (which I also wouldn't recommend for someone who is just learning SAS),

or saving the spreadsheet (from within Excel) to a comma delimited file (csv) and then using code very similar to that which you originally were trying to use.

Again, in the last case, I'd use proc import and have it save the resulting program and then reviewing the resulting program.

First SAS program

Sasanytics — Mon, 20 Feb 2012 03:21:25 GMT

I managed to get it to work using this code:

PROC IMPORT OUT= WORK.Orders DATAFILE="C:\MySAS\Orders.xls" DBMS=xls REPLACE;

SHEET="testing";

GETNAMES=YES;

PROC Contents DATA = Work.Orders;

Proc Print DATA = Work.Orders (obs=10);

Title "MyOrders";

Run;

But I have this question:

I need to create a new variable "NewPrice" to convert the "Price" into a binary variable and assign the value "1" if the "Price" >= 20, otherwise assign "0"

Here's my code that didn't work:

INPUT "NewPrice $";

If 'Price' < 20 then 'NewPrice' = 0;

else 'NewPrice' = 1;

Run;

First SAS program

art297 — Mon, 20 Feb 2012 03:58:42 GMT

You created a SAS file called orders. All you have to do, now, is modify that file:

data orders;

set orders;

if Price < 20 then NewPrice = 0;

else NewPrice = 1;

run;