Date:         Sat, 29 Mar 2008 10:16:14 -0500
Reply-To:     "data _null_," <datanull@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "data _null_," <datanull@GMAIL.COM>
Subject:      Re: Create a dataset
Comments: To: ash007 <RamsamyAshley@gmail.com>
In-Reply-To:  <796c452f-4f84-4a61-a4eb-65e9c857f865@x41g2000hsb.googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1

Why do you need this data set?  What is the purpose?  I ask because I
suspect there is "a better way".

Below is one possibility using a view.

data big;
   input x @@;
   cards;
14 25 36 43 59
;;;;
   run;
data bigV / view=bigV;
   set big;
   do y = 'NSA','NSF','.';
      output;
      end;
   retain z 0;
   run;

On Sat, Mar 29, 2008 at 10:06 AM, ash007 <RamsamyAshley@gmail.com> wrote:
> Hello,
>
> I have a (very big) dataset with a column like this :
>
> 14
> 25
> 36
> 43
> 59
> .
> .
> .
>
> With this column I need to create a dataset like this :
>
> 14 NSA 0
> 14 NSF 0
> 14 .      0
> 25 NSA 0
> 25 NSF 0
> 25 .      0
> 36 NSA 0
> 36 NSF 0
> 36 .      0
> 43 NSA 0
> 43 NSF 0
> 43 .      0
> 59 NSA 0
> 59 NSF 0
> 59 .      0
>
> .
> .
> .
>
> Thank for your help.
> ash_rmy
>