I,m trying to do em proc export with csv. into sas 5.1 it exported the file with the delimiter ',' but on 7.1 the delimiter it´s ';'. There´s a way to change it?
When i try to use the proc export below, it create the file with the delimiter but the indicator of the end of the line cr lf dont appear. there´s a way to resolve it?
proc export data=PAS_SAI.GPO_LCTO_CTBC_EXNO replace*/
outfile='/dados/digovgefup/producao/gpo/conciliacao_diaria/saida/sas_lctoctblexno.csv'*/
dbms=dlm; */
delimiter=',';*/
run;*/
'
Why not just specify DMBS=CSV? Also, not sure if the */ and * are messing with your code, they don't look correct.
proc export data=PAS_SAI.GPO_LCTO_CTBC_EXNO
outfile='/dados/digovgefup/producao/gpo/conciliacao_diaria/saida/sas_lctoctbexno.csv'
dbms=csv;
run;
@mariorsdias wrote:
I,m trying to do em proc export with csv. into sas 5.1 it exported the file with the delimiter ',' but on 7.1 the delimiter it´s ';'. There´s a way to change it?
When i try to use the proc export below, it create the file with the delimiter but the indicator of the end of the line cr lf dont appear. there´s a way to resolve it?
proc export data=PAS_SAI.GPO_LCTO_CTBC_EXNO replace*/
outfile='/dados/digovgefup/producao/gpo/conciliacao_diaria/saida/sas_lctoctblexno.csv'*/
dbms=dlm; */
delimiter=',';*/
run;*/'
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.