Ahhh... it works now!!!! Thank You Very Much!!!! ... View more

PROC IMPORT FILE="/home/u58811045/Assignment.csv" OUT=WORK.ASSIGNMENT2 DBMS=CSV replace; RUN; data work.assignment; infile "/home/u58811045/Assignment.csv" delimiter = "," missover dsd firstobs=2; informat id best32. ; informat name $37. ; informat host_id best32. ; informat host_name $9. ; informat neighbourhood_group $14. ; informat neighbourhood $12. ; informat latitude best32. ; informat longitude best32. ; informat room_type $15. ; informat price best32. ; informat minimum_nights best32. ; informat number_of_reviews best32. ; informat last_review mmddyy10. ; informat reviews_per_month best32. ; informat calculated_host_listings_count best32. ; informat availability_365 best32. ; format id best12. ; format name $37. ; format host_id best12. ; format host_name $9. ; format neighbourhood_group $14. ; format neighbourhood $12. ; format latitude best12. ; format longitude best12. ; format room_type $15. ; format price best12. ; format minimum_nights best12. ; format number_of_reviews best12. ; format last_review mmddyy10. ; format reviews_per_month best12. ; format calculated_host_listings_count best12. ; format availability_365 best12. ; input id name $ host_id host_name $ neighbourhood_group $ neighbourhood $ latitude longitude room_type $ price minimum_nights number_of_reviews last_review reviews_per_month calculated_host_listings_count availability_365; run; But when i do this: DATA work.assignment; RUN; It shows the same error again. ... View more

Yeah, i tried both, the step is successful, but then when i try to edit the data, it comes out with this error... I tried with other files such xlsx as well, it also show this error... It this a bug that i should contact SAS for help? ... View more