worldwidemopa.blogg.se

Perhaps they just think they need it because they misunderstood the reason that quotes are needed when a particular value includes the delimiter character.ĭo you need quotes around ALL values? Or only around the character variable values? Around all values is easier. The first response would be back to the requester as to why they would want such a format. I'm sure there are lots of other ways as well but most will involve some combination of string creation and manipulation then writing to the file. If EFIEOD then call symputx('_EFIREC_',EFIOUT) If _ERROR_ then call symputx('_EFIERR_',1) /* set ERROR detection macro variable */ Put nametext Sextext Agetext Heighttext Weight Heighttext= quote(strip(put(height,best6.))) If _n_ = 1 then /* write column names or labels */ %let _EFIREC_ = 0 /* clear export record count macro variable */įile 'x:\data\filename.txt' delimiter='|' %let _EFIERR_ = 0 /* set the ERROR detection macro variable */

You can copy that code into the editor as a code node and modify it to write the values as desired.Īn incomplete example could be data _null_ The log will have code that looks like 5543 data _null_ ĥ544 %let _EFIERR_ = 0 /* set the ERROR detection macro variable */ĥ545 %let _EFIREC_ = 0 /* clear export record count macro variable */ĥ546 file 'x:\data\filename.txt' delimiter='|' DSD DROPOVER lrecl=32767 ĥ547 if _n_ = 1 then /* write column names or labels */ĥ569 put Name $ put Sex $ put Age put Height put Weight ĥ576 if _ERROR_ then call symputx('_EFIERR_',1) /* set ERROR detection macro variable */ĥ577 if EFIEOD then call symputx('_EFIREC_',EFIOUT) Will create a delimited file but the contents will look like: Name|Sex|Age|Height|Weight The proc will write a data _null_ step to the log that you can modify.Ī starting example: Proc export data=sashelp.class Or possibly use Proc Export to create a delimited text file. One is to write a data _null_ step from scratch creating quoted values and then using PUT statements with the values to create the output. Since your described output is slightly nonstandard you have a couple of choices. Typically for most purposes the quotes are needed only for values that might contain the delimiter. You may need to clarify that each an every value, including numeric especially, needs to be quoted.