Date:         Tue, 3 Feb 2004 09:35:47 -0500
Reply-To:     "Chakravarthy, Venky" <Venky.Chakravarthy@PFIZER.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Chakravarthy, Venky" <Venky.Chakravarthy@PFIZER.COM>
Subject:      Re: The datalines
Comments: To: Rune Runnestoe <rune@FASTLANE.NO>
Content-Type: text/plain; charset="iso-8859-1"

Rune,

Provide a missing value (.) in the first column (yes, even if it is a
character variable) for "Ikke_forskudd" and use the $char40. informat to
read the values separated by a space.

data &bibl..forskuddsform_kode;
        attrib  code_value            length=$1 label="Forskuddsform"
                        explanation             length=$40
label="Forklaring";
        infile cards;
        input   @1 code_value
                @3 explanation $char40. ;
datalines;
.  Ikke forskudd
0  Intet
1  Tabellkort
2  Prosentkort
3  Bare forskuddsskatt
4  Frikort
5  Fritaksmelding
6  Bare selvangivelse
;

Regards,
_________________________________
Venky Chakravarthy
E-mail: swovcc_AT_hotmail_DOT_com

-----Original Message-----
From: Rune Runnestoe [mailto:rune@FASTLANE.NO]
Sent: Tuesday, February 03, 2004 5:28 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: The datalines


Hi,
below is a code I want to improve if possible. First, is there any way
I can mark that a blank value can be a valid code value, like
"Ikke_forskudd" ? Second, how do I make the whole explanation appears
in the dataset column without having connect the words in the string
with underscores, like
"Bare forskuddsskatt" ?

data &bibl..forskuddsform_kode;
        attrib  code_value            length=$1 label="Forskuddsform"
                        explanation             length=$40
label="Forklaring";
        infile cards;
        input   @1 code_value
                @3 explanation;
datalines;
        Ikke_forskudd
0       Intet
1       Tabellkort
2       Prosentkort
3       Bare_forskuddsskatt
4       Frikort
5       Fritaksmelding
6       Bare_selvangivelse
;


Regards
Rune Runnestoe


LEGAL NOTICE
Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this E-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents of this E-mail or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately.