Dear Folks, I am new to SAS and facing difficulty to understand the below point: The below program is not giving correct output because the data after datalines statement is not following the spacing that is required as per variables defination in 'input' statement. Here, I have only 5 record lines and thus it is easy for me to change the spacing in datalines. But, if I have millions of records and data is coming as in current form (where the 'name' variable is having space in between, how would i define my 'input' statement so that output is correct as required. I tried using colon (:) in the input statement, but couldn't get the desired result. Please help!! options pagesize=60 linesize=80 pageno=1 nodate; data sales; input EmployeeID $ 1-9 Name $ 11-29 @30 HireDate date9. Salary HomePhone $; format HireDate date9.; datalines; 429685482 Martin, Virginia 09aug1990 34800 493-0824 244967839 Singleton, MaryAnn 24apr1995 27900 929-2623 996740216 Leighton, Maurice 16dec1993 32600 933-6908 675443925 Freuler, Carl 15feb1998 29900 493-3993 845729308 Cage, Merce 19oct1992 39800 286-0519 ; proc print data=sales; title ’Sales Department Employees’; run;
... View more