09-21-2014 10:34 AM
I was importing an csv file all the rows(29k rows) are importing .
I have 2 columns product and sub-product as shown below
|Bank account or service||Conventional adjustable mortgage (ARM)|
but my dataset is creating
|Bank account or ser||Conventional adjustable mortgage (ARM)|
09-22-2014 04:59 AM
I wouldn't recommend the use of proc import if your data is CSV. Write a datastep with an infile statement, you then have full control of what, how long, where from etc. is imported. There are many posts about importing CSV files using differing methods, here is one: https://communities.sas.com/thread/60923
Need further help from the community? Please ask a new question.