Desktop productivity for business analysts and programmers

Problem while creating CSV File

Not applicable
Posts: 0

Problem while creating CSV File


I am using a piece of code to convert dataset to csv in my EG project


%ds2csv (data=WORK.QUERY_FOR_QUERY9263, runmode=b, csvfile=/apps/sas/ReportsRepository/Reports/BSS/BMA/CSV/Monthly/BM_SREP0038_StkVal_&date1..csv,openmode=REPLACE);

In the same project I am creating a text file through proc report by having outfile in my code and I have specified ls=256.

The CSV file which is created the last column label gets truncated since its going above 256 length when all columns together.

Below is the CSV File
If u see the column header Tot is displayed Instead of Total becoz of that
the first row is displayed on the level of column header.
Any solution to avoid this

"Branch No","Branch Name","Main Stock","Damaged Stock","Quarantine","Return to supplier","Trade Counter Display","Supplier Consignment","Co- managed Inventory","Customer Consignment","Goods In","Off site","Total Of XYZ Stock","Total Of Non XYZ Stock","Tot
"1110","1110 abc","1,635,407.02","0.00","0.00","0.00","0.00","0.00","0.00","0.00","0.00","0.00","1,635,407.02","0.00","1,635,407.02" Message was edited by: Sunil Gandhi
Posts: 9,423

Re: Problem while creating CSV File

Posted in reply to deleted_user
Hi...some of those old macros did respect line size limitations -- which is just one of the reasons why I wouldn't use them anymore. They are left over from Version 6 and Version 8. ODS generally ignores linesize for non-listing destinations (like CSV, HTML, RTF, etc).

ods csv file="/apps/sas/ReportsRepository/Reports/BSS/BMA/CSV/Monthly/BM_SREP0038_StkVal_&date1..csv";
proc print data=work.query_for_query9263;
ods csv close;

And see whether you run into the same limitation...I don't think you will. Otherwise, you might consider contacting Tech Support. There are other ways to create CSV files from SAS datasets, but I think the ODS method will work for you.

Not applicable
Posts: 0

Re: Problem while creating CSV File

Posted in reply to Cynthia_sas
Thanks a lot.
It worked.
Ask a Question
Discussion stats
  • 2 replies
  • 2 in conversation