topic Re: Datalines VS Cards. in SAS Programming

Datalines VS Cards.

kuridisanjeev — Tue, 11 Dec 2012 09:14:39 GMT

Hi All..

Is there any any difference between Card and Dataline Statements ????

Please Clarify me...

Thanks & Regards..

Sanjeev.K

Re: Datalines VS Cards.

data_null__ — Tue, 11 Dec 2012 11:37:45 GMT

Only the spelling.

Re: Datalines VS Cards.

kuridisanjeev — Tue, 11 Dec 2012 12:38:23 GMT

Thanks for your detailed explanation..:-)

Re: Datalines VS Cards.

ballardw — Tue, 11 Dec 2012 15:22:01 GMT

I wouldn't put a big bet on it but I believe in ancient days, SAS 5 perhaps, CARDS meant 80 column input to simulate punch cards, hence the name.

Re: Datalines VS Cards.

kuridisanjeev — Tue, 11 Dec 2012 15:29:32 GMT

Hi..

Did't get you completely...

Regards..

Sanjeev.K

Re: Datalines VS Cards.

bnarang — Tue, 11 Dec 2012 17:58:05 GMT

Your sense of humour is great.

Re: Datalines VS Cards.

art297 — Tue, 11 Dec 2012 18:35:55 GMT

: I think it started WAY earlier than that! I seem to recall that being the same syntax that was used in the Statistical Analysis System out of North Carolina State University.

But we've progressed! Now we get to type 9 characters, rather than 5, to specify "cards".

Re: Datalines VS Cards.

TomKari — Tue, 11 Dec 2012 21:22:45 GMT

From my trusty SAS 1979 manual (I believe the last time that all of SAS fit into one book), CARDS and CARDS4 statements only, no DATALINES.

I remember reading once that if I wanted to use an infile statement to provide options (I frequently use dlm='09'x for tab delimited), I had to use datalines NOT cards. But I just ran a test, and cards works on an infile statement also, so I guess this assumption is out of date (like I'm beginning to feel!).

Tom

Re: Datalines VS Cards.

art297 — Tue, 11 Dec 2012 22:14:29 GMT

: Do you want to feel young? My first computer program looked like the one in this picture:

http://www.google.ca/imgres?imgurl=http://lewisshepherd.files.wordpress.com/2010/08/ibm-402-plugboard.jpg&imgrefurl=http://lewisshepherd.wordpress.com/2010/08/05/four-score-and-seven-years-ago/&h=600&w=800&sz=193&tbnid=vElocL63-72QMM:&tbnh=90&tbnw=120&zoom=1&usg=__u2hgl7erV9UoSigTxXHz625ps-Y=&docid=liJl_fl1iRqCsM&hl=en&sa=X&ei=06_HUKv1IcaE2QX52YCYDg&sqi=2&ved=0CFgQ9QEwBQ&dur=380

Re: Datalines VS Cards.

TomKari — Tue, 11 Dec 2012 22:56:23 GMT

I doff my chapeau to you sir! We studied them in school, but I will bow down and admit I've never used one, nor have I ever seen one.

Extremely cool!

Tom

Re: Datalines VS Cards.

art297 — Tue, 11 Dec 2012 22:58:59 GMT

: Apparently, if you are using an older version of SAS, there may be one difference.

The following 2007 SGF paper, by last year's SGF chair (Andy Kuligowski) http://www2.sas.com/proceedings/forum2007/220-2007.pdf, describes a case where one worked while the other didn't:

data _null_;

set sashelp.class;

file cards;

put name;

run;

data _null_;

set sashelp.class;

file datalines;

put name;

run;

However, this is one case where SAS decided not to insure that code working on one version would continue to work on the next version. With 9.3 both of the above will result in an error.

Re: Datalines VS Cards.

art297 — Tue, 11 Dec 2012 23:07:00 GMT

: Somehow I think the IBM 402 accounting boards must be where the term spaghetti code originated.

Re: Datalines VS Cards.

data_null__ — Wed, 12 Dec 2012 12:09:59 GMT

I guess my verion of 9.3 is a little different from your. I get the Kuligowski result. It is interesting to see what SAS says the name of the file is.

29         data _null_;
30            set sashelp.class;
31            file datalines filename=fname;
32            put fname=;
33            put name;
34            stop;
35            datalines;

fname=CARDS
Alfred
NOTE: There were 1 observations read from the data set SASHELP.CLASS.

Re: Datalines VS Cards.

art297 — Wed, 12 Dec 2012 14:37:25 GMT

DN: Andy's example didn't include either a cards or datalines statement at the end. However, with your code, I too get the same results as you. And, indeed, the filename assigned makes me feel young again!

Re: Datalines VS Cards.

Doc_Duke — Thu, 13 Dec 2012 14:38:35 GMT

Sanjeev.K,

Congratulations, you have opened the floodgates of nostalgia.

"Back in the day", SAS only ran on mainframes and the only way to get a SAS program into the computer was to use punch cards (also known as Hollerith cards after the inventor, see Punched card - Wikipedia, the free encyclopedia ). Therefore, CARDS; was the natural term for getting data to the program that was inline with the program.

Doc Muhlbaier

Duke

Re: Datalines VS Cards.

art297 — Thu, 13 Dec 2012 15:16:03 GMT

: How much nostalgia can you take in one day? I remember, in 1975, getting the tool that I thought was the greatest replacement for punch cards ever! Take a look at: http://www.google.ca/imgres?imgurl=http://forum.allaboutcircuits.com/cache.php%3Furl%3Dhttp://scm-l3.technorati.com/11/05/22/34913/acoustic-modem.jpg&imgrefurl=http://forum.allaboutcircuits.com/showthread.php?t%3D62137&h=437&w=565&sz=50&tbnid=5TQrmhs0RGqQ8M:&tbnh=90&tbnw=116&zoom=1&usg=__WzUgjWirf1kEF5go2DwZJ1EhyI8=&docid=jEmo3oabR-Hk7M&hl=en&sa=X&ei=NfDJULvWDpS42gXo2IG4BA&ved=0CFcQ9QEwBw&dur=6438

and that was 110 baud .. without a K after the number. However, it did let one run programs from their desk and without the risk of spilling a box of cards.

Re: Datalines VS Cards.

kuridisanjeev — Thu, 13 Dec 2012 15:30:07 GMT

, Thank you very much...:-)

Regards..

Sanjeev.K

Re: Datalines VS Cards.

TomKari — Thu, 13 Dec 2012 15:33:59 GMT

Oh, cripes! I remember using both the modems AND phones with dials. A couple of years ago I saw one of those phones for sale at an antique store!?!

Somebody just shoot me now!

Anybody else remember buying this issue at the newsstand?

http://en.wikipedia.org/wiki/File:Popular_Electronics_Cover_Jan_1975.jpg

Tom

Re: Datalines VS Cards.

ballardw — Thu, 13 Dec 2012 16:00:56 GMT

I rember reading that issue. I didn't buy a copy because my dad subscribed to the magazine.

First modem I worked with was 300 baud and had to write own communication program between a Techtronics micro and an HP2000.

Re: Datalines VS Cards.

ajuhack — Thu, 13 Dec 2012 16:59:49 GMT

Look for this link you will be get the clarification of datalines VS csrds Vs lines.

in Short

lines , cards are initially used in SAS .because the SAS algoes read length, created in form to reading long data lines in CARDIMAGE System Option and that time they use cards and lines ,

look this for datalines ....

http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000188182.htm

and for cards ..........

http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000289371.htm

and then they enhance cards in datalines........