cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
afrerichs
‎08-04-2023
  • 2 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Exporting a large CSV cuts off variable names

by Calcite | Level 5 in SAS Programming
‎08-04-2023 04:29 PM
‎08-04-2023 04:29 PM
Thank you! I was able to get it to work. Yes, unfortunately this dataset has crazy variable names.  My next question in case you know the answer, I want the output csv to be named "OUTPUT_File.csv", but it is outputting it as "Output_File.csv". Do you know if there is a way around this?  ... View more

Exporting a large CSV cuts off variable names

by Calcite | Level 5 in SAS Programming
‎08-04-2023 04:07 PM
‎08-04-2023 04:07 PM
When I try to export a dataset with 1900 variables as a CSV, the output only contains a certain number of variable names and then the rest are just blanks.    I tried this code instead of proc export:    proc transpose data=final(obs=0) out=names ; run; data _null_; file 'myfile.csv' dsd ; set names end=eof; put _name_ @; if eof then put; run; data _null_; set final ; file 'myfile.csv' dsd mod ; put (_all_) (+0); run;  But it STILL cut off the variable names. How can I fix this?  ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎08-04-2023 08:12 PM
Quick links