Tom, That is part of the reason i questioned why or how that code works for this problem i have been give. If you look at the question, and features of what I have been asked to complete, I am still unsure if i even have the .csv file correctly formatted. Everytime i read over it, i think of something else, it may or could look like. I am attaching my current .csv file to show the data I am suppose to have "80 entries total for". Here is the portion of the discussion I am missing out on. This should be a small simple program right? Myabe what Tom says is ok, but i still dont know how to sepereate that in the code. The more i research this problem the more confused i get. Write a SAS® program to access the Microsoft® Excel® spreadsheet and convert the income range labels into two numerical variables for male and female data that worked full-time and have earnings. You can ignore the Other category in each gender data. As an example, the label $1 to $2,499 or loss would be stored in two variables with content: 1 and 2499. When creating and processing the variables, maintain the gender identification of the data so that the information about male and female earning categories is preserved. Given 20 earning labels per gender category, you should have 80 variables when finished, 40 per gender category. When converting the label $100,000 or more use numbers: 100000 and 149999. Save the converted earning category data in a raw data file. Sometimes the best way for me to solve a problem is with color, and normally this would make things clearer, but for me its not working. Most of it has to do with the following... converting the ranges.. formatting the .csv properly storing the data in a raw file I think i understand the following will informat and modify the ranges, but I still feel depleted like im missing something. And its the first time i have been asked to submit a raw data file, that is just the output i would assume exported from SAS. I just need to tie all this together, I only have to complete one more program after this one, I wish i knew as much as some of you do. data Auglaize; infile '.csv'; data have;
informat range $30.;
input range &;
low=input(scan(range,1,"to"),comma8.);
high=input(scan(range,2,"to"),comma8.);
cards;
$2,500 to $2,499 $1 to $2,; *what about every other range in the table?; *I am suppose to have 80 variables if i am reading that correctly; Proc Print Data=Auglaize; *specify the data set to input from; run; This is as close as i have came to get it working, can anyone help me with the kinks? I am getting a error about there being no columns, and its referencing a table I am not even trying to use. Its referencing a file named completely different than the one I am using. 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 55 56 data Auglaize; 57 infile '/home/ktylu10/Auglaize County Ohio Jason.csv'; NOTE: The infile '/home/ktylu10/Auglaize County Ohio Jason.csv' is: Filename=/home/ktylu10/Auglaize County Ohio Jason.csv, Owner Name=ktylu10,Group Name=oda, Access Permission=-rw-rw-r--, Last Modified=26Feb2017:20:46:45, File Size (bytes)=1695 NOTE: 0 records were read from the infile '/home/ktylu10/Auglaize County Ohio Jason.csv'. NOTE: The data set WORK.AUGLAIZE has 1 observations and 0 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 763.93k OS Memory 27808.00k Timestamp 02/27/2017 01:53:06 AM Step Count 24 Switch Count 44 Page Faults 0 Page Reclaims 344 Page Swaps 0 Voluntary Context Switches 125 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 160 58 data have; 59 60 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
... View more
