Date: Wed, 17 Aug 2011 11:09:26 -0500
Reply-To: "Data _null_;" <iebupdte@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Data _null_;" <iebupdte@GMAIL.COM>
Subject: Re: how Pad SSNO with 0
Content-Type: text/plain; charset=ISO-8859-1
read it with COMMA informat and display it with SSN format.
ssn2 = ssn;
format ssn ssn.;
On Wed, Aug 17, 2011 at 10:28 AM, Jamil M Ibrahim <email@example.com> wrote:
> Why it does not read the ssn? I try to pad the leading spaces in SSno with zeros
> DATA cars5;
> 667 ***get rid of commas using dlm=',' and double quotes using dsd in infile statement;
> SYMBOLGEN: Macro variable PATH resolves to C:\Admissions\admit03-04\ay03-04.csv
> SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing.
> 668 INFILE "&PATH" lrecl=400 missover pad dsd dlm=',';
> 670 length FName MName LName EthnDesc $25. ssn $9. ;
> 672 INPUT (Studno1 FName MName LName studno2 SSN Gender studno3 EthnicCd EthnDesc) ($) mcat
> 673 M1Avg M2Avg M3Avg CumAvg ;
> 675 ssn=input(ssn,z9.); Name = trim(left(lName)) || "? " || trim(left(fName)) ;
> ERROR 48-59: The informat Z was not found or could not be loaded.
> Thank you.
> Dr. Jamil Ibrahim, Ph.D.
> Scientist IV, Research Supervisor, Professor, SHRP
> 2500 N State St. Jackson, MS 39216-4505
> Tel: (601) 984-1197 Fax: (601) 984-1205
> Email: firstname.lastname@example.org
> Individuals who have received this information in error or are not authorized to receive it must promptly return or dispose of the information and notify the sender. Those individuals are hereby notified that they are strictly prohibited from reviewing, forwarding, printing, copying, distributing or using this information in any way.