Hi everyone,    Pretty new to SAS, so I apologize in advance. I'm trying to import the attached dataset, but I'm having an issue getting it to read the DOB column.    I am using the following code:   DATA employees;  INFILE "C:\Users\dlobsien\Desktop\employees.txt" dsd;  INPUT SSN $11. Name $17. DOB DATE.9 PayGrade $57-60 Salary COMMA10. Position :$27.;  TITLE employee data;   It just shows all the observations under this column as missing data. Everything else reads as I want it to.    I have also tried putting @xx before it as well entering the following with no success:   INFORMAT DOB ANYDTDTE.; INPUT ... DOB Pay...;  FORMAT DOB DATE9.   If anyone could provide any help it would be greatly appreciated.  ... View more

Hi,    I'm having trouble getting the last few numeric variables of the attached data set to read.    i've had the best success with the following code:   DATA crayons; INFILE 'C:\Users\dlobsien\Desktop\crayons.txt' dsd truncover; INPUT number 1-3 color $ 4-31 @32 code $ RGB $ 40-55 pack 56-60 issued 61-65 retired 65-69;   With this, many of the "pack" and "issued" variables' data appear as missing, but all of the "retired" data seems to appear.    In the dataset, there is a value for each observation of the "pack" and "issued" variables, but only some for the "retired" variable. Each of the last three observations vary about their line position, and the "pack" var varies in length. the last two vars are years.   I've also tried putting "@57 pack", "pack :57-60 issued :61-64..." and other variations of this ad nauseam with varying degrees of success.   Any help would be greatly appreciated. ... View more

Hi Everyone,    Been learning for about a week. So, i have a data set that follows the following pattern: rank (numeric), company ($), country ($), sales (num), profits (num), assets (num), market value (num)   the data under the last 4 numeric variables are presented in billions of dollars, as "$1.5B" or "$200.1B", and vary in length    Im using the following code: DATA bigcos; INFILE 'C:\Users\dlobsien\Documents\bigcompanies.txt'; INPUT ranking company_name $26. +1 country $18. sales_in_billions :dollar10. profits_in_billions :dollar10. assets_in_billions :dollar10. +1 profits_in_billions :dollar10.; title companies data; RUN; ——————————- PROC PRINT data=bigcos (obs=15); Run;   the first three variables go in fine, but it wont read anything after that with the Bs in the way (i assume that's the issue). whenever i add a line that says "compress(var, 'B')", after the input lines it gives me 0 observations—maybe I'm entering the syntax wrong or putting it in the wrong spot.    I've also included the data set in case that is useful.   Any help would be greatly appreciated. ... View more

Hi Everyone,    Been learning for about a week. So, i have a data set that follows the following pattern: rank (numeric), company ($), country ($), sales (num), profits (num), assets (num), market value (num)   the data under the last 4 numeric variables are presented in billions of dollars, as "$1.5B" or "$200.1B", and vary in length    Im using the following code: DATA bigcos; INFILE 'C:\Users\dlobsien\Documents\bigcompanies.txt'; INPUT ranking company_name $26. +1 country $18. sales_in_billions :dollar10. profits_in_billions :dollar10. assets_in_billions :dollar10. +1 profits_in_billions :dollar10.; title companies data; RUN; ——————————- PROC PRINT data=bigcos (obs=15); Run;   the first three variables go in fine, but it wont read anything after that with the Bs in the way (i assume that's the issue). whenever i add a line that says "compress(var, 'B')", after the input lines it gives me 0 observations—maybe I'm entering the syntax wrong or putting it in the wrong spot.    I've also included the data set in case that is useful.   Any help would be greatly appreciated. ... View more

Hi Everyone,    I'm new to sas, and I am trying to enter a data set, where some of the character data contain spaces, apostrophes, and a dash. I'm not sure how to do this, and i keep getting a weird output. I have tried to use both the CHAR and VARYING informats, but i could be doing it wrong. I have provided both the code that i've tried and the output im getting below. I am required to do this using datalines.    DATA cancer;  INPUT type $char. new_cases yearly_deaths survival percent3.;  DATALINES;    breast 271270 42260 90%    lung 228150 142670 23%    prostate 164690 29430 98%    colorectal 145600 51020 64%    melanoma 96480 7230 92%    bladder 80470 17670 77%    non-hodgkin's lymphoma 74200 19970 71%    kidney 73820 14770 75%    endometrial 61880 12160 84%    leukemia 61780 22840 61%    pancreatic 56770 45750 9%    thyroid 52070 2170 99%    liver 42030 31780 18%  ; RUN;   PROC PRINT data=cancer; RUN;   gives me    The SAS System   Obs type new_cases yearly_deaths survival 1 breast 271270 42260 0.90 2 lung 22 8150 142670 0.23 3 prostat . 164690 294.00 4 colorec . 145600 510.00 5 melanom . 96480 723.00 6 bladder 80470 17670 0.77 7 non-hod . . 742.00 8 kidney 73820 14770 0.75 9 endomet . 61880 121.00 10 leukemi . 61780 228.00 11 pancrea . 56770 457.00 12 thyroid 52070 2170 0.99 13 liver 4 2030 31780 0.18   I've also tried putting "$VARYING." as well as entering DLM=',' and separating the data by commas, which made it worse.    If anyone knows what i should enter or has any advice on how to handle this is would be greatly appreciate.    Thanks ... View more