topic Re: Defining a autonumber ID column when creating a dataset? in SAS Procedures

Defining a autonumber ID column when creating a dataset?

jerry898969 — Fri, 20 Feb 2009 16:33:26 GMT

Let me start off by saying that I'm very new to SAS so excuse me for any minor mistakes.

I'm trying to create a dataset that will have an ID column with autogenerated numbers as the ID's.
With this dataset how can I had an Id field as the first column?

data Person;
input fname $ lname $ city $;
datalines;
BOB JONES BOSTON
FRED SMITH MIAMI
;
run;

Thank You
Jerry

Re: Defining a autonumber ID column when creating a dataset?

Peter_C — Fri, 20 Feb 2009 16:41:59 GMT

add a line just before the input statement[pre] ID+1 ;[/pre]
good Luck

PeterC

Re: Defining a autonumber ID column when creating a dataset?

jerry898969 — Fri, 20 Feb 2009 16:48:46 GMT

Pete,
Thank you so much that was simple enough.

In my data lines what do I have to do to get New York as the city, it only shows New?

Thanks again
Jerry

Re: Defining a autonumber ID column when creating a dataset?

jerry898969 — Fri, 20 Feb 2009 17:53:41 GMT

Nevermind I figured it out $20. fixed it in the input statement.

Thanks again for the help
Jerry