Hello everyone, Was hoping you can help me out, I am a bit stuck with SAS informats, I've tried a lot of different combinations but not quite getting the right output. I am pretty much trying to get the below data into 4 columns. However, Company has blanks and some special characters, which is throwing all the inputs out. Below is my code and only 17 observations: DATA example;
INFORMAT id 5. Company $Comma5. Employees 4. Profit Dollar15.;
INPUT id Company Employees Profit;
FORMAT id 5. Company $Comma5. Employees 4. Profit Dollar15.;
DATALINES;
1 Kling Inc 240 $6641679.60
2 Thompson-Okuneva 348 $8235180.28
3 Ratke, Littel and Lind 496 $1426858.40
4 Crist, Bashirian and O'Connell 217 $2444880.75
5 Hermann, Simonis and Lockman 233 $6732864.52
6 Greenfelder and Sons 318 $3955691.84
7 Rempel-Herzog 210 $1356491.19
8 Simonis Group 216 $97393.42
9 Davis-Ziemann 45 $2078465.33
10 Konopelski, Wehner and Marquardt 444 $3095364.16
11 Halvorson-O'Hara 379 $9515982.36
12 Schimmel, Nitzsche and Sawayn 311 $8109720.46
13 Hahn Inc 498 $3683395.00
14 Connelly, Bashirian and Blanda 432 $2037320.33
15 Littel, Reynolds and Lueilwitz 12 $1585741.13
16 Wolf, Cruickshank and Kshlerin 42 $9032698.68
17 Kassulke, Runolfsdottir and Padberg 70 $9774043.93;
RUN;
My code gets the below, the spacing is throwing the inputs off. Using the first observation as an example, if I drop Inc, everything will load correctly. Any help greatly appreciated! Thanks in advance Cantonais
... View more
