06-24-2016 04:59 PM
You should be reading and storing both ICD9 and ICD10 as character fields so you need to change the length of the field possibly but besides that there should be no issue.
06-24-2016 05:08 PM
Without seeing anything else ... no.
Post your code, log and sample data.
Check your input statement - is it missover truncover flowover? Which is appropriate for your situation?
06-25-2016 03:18 AM
This article contains information on the Lost Card note.
06-25-2016 11:57 AM
06-27-2016 09:46 AM
Thanks. I have read this before.
I added truncover option. No more "loss card" but still almost all missing data, execpt the first 2-7 variavles, the first one is also blank
Should I change Irecl?
The log shows The minimum record length was 256.
06-27-2016 09:48 AM
I also added firstobs=2 because I only want to test it, without waiting for it to finish the whole records,
it still reads all records
can anyone tell how to fix it
06-27-2016 09:57 AM
missover truncover obs=2;
I did use this and it only read two records, but most info was missing except the first 2-7 variables
most missing data, what should I do
06-27-2016 11:53 AM
20k is the length of the record. Your last input variable starts well before that so that's why your missing variables.
Fix your input statement.
This all assumes you have a fixed width file.
Use the following to subset your file so you can debug it. Extract 20 lines and make sure your input statement is correct.
06-27-2016 12:06 PM
I have used truncover, it does not change.
I cannot open the link. doe it need to register?
I cannot understand how to fix it. I still do not understand why it is "20,000" and do not understand "Your last input variable starts well before that so that's why your missing variables"
06-27-2016 12:53 PM
SAS is saying a record length is 20,000 characters/columns. You've set it to the 32K characters but that doesn't matter if there's nothing beyond this.
Your last input variable starts at column 13456. I'm assuming you have a specification document, what does that say regarding length and variables?
The code was for Powershell, a script command to extract top N lines.
gc -path file_name.csv - head N > output.txt
Need further help from the community? Please ask a new question.