| Date: | Wed, 26 Sep 2007 13:20:21 +0000 |
| Reply-To: | toby dunn <tobydunn@HOTMAIL.COM> |
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
| From: | toby dunn <tobydunn@HOTMAIL.COM> |
| Subject: | Re: loosing zero numbers |
|
| In-Reply-To: | <200709261301.l8QAmG87013485@mailgw.cc.uga.edu> |
| Content-Type: | text/plain; charset="Windows-1252" |
Ran ,
Numerics in SAS have the leading zeros stripped. So you have to convert them to character and use the Z Format.
C = Put( A , Z3. -L ) || "_" || Put( B , Z4. -L ) ;
Better yet if you are using SASV9 use one of the Cat functions:
C = CatX( '_' , Put( A , Z3. ) , Put( B , Z4. ) ) ;
Your other questions answer is :
A = Put( , Z4. ) ;
Toby Dunn
Compromise is like telling a lie, it gets easier and easier. Each comprimise you make, that becomes your standard.
Perfection doesnt exist, once you reach it, its not perfect anymore. It means something else.
> Date: Wed, 26 Sep 2007 09:01:47 -0400
> From: raan67@YAHOO.COM
> Subject: loosing zero numbers
> To: SAS-L@LISTSERV.UGA.EDU
>
> Hi,
>
> I have dataset like:
> A B
> 001 0001
> 017 0002
> 188 0003
>
>
> Now I would like to concatenate A and B and I would like to keep zero’s I
> have in the beginning of each number.
> Such as I get 001_0001, 017_0002….
>
> But when I am doing that using this code C=A||’_’||B, I am loosing zeros
> and I am getting
>
> 1_1
> 17_2
> 188_3
>
>
> Second, I am also trying to create a new variable A (4 digits) and I would
> like to show this new variable as 0001,0017,0188. How can add ‘0’ in the
> beginning of each number.
> I tried to use the code: =”0”||A. But its not working.
>
>
> Thanks!
_________________________________________________________________
Invite your mail contacts to join your friends list with Windows Live Spaces. It's easy!
http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt=en-us
|