About garag

garag · ‎05-24-2013

Thank Tom, it worked

garag · ‎05-24-2013

Hi, I'm trying to write a txt file with sas. The file will contain a value of a macro variable and that mcro variable could contain double quote. Example %let myvar=ORACLE execute error: ORA-01400: cannot insert NULL into ("blabla"."blabla"."blabla"); %let bodyfile=/mydir/mytxt.txt; data _null_; file "&bodyfile."; put &myvar.; run; It does not work. What is wrong? Any help will be appreciate. Thanks

garag · ‎05-22-2013

Hi, If I try to run the same come in Oracle sql window I get the same error, it 's clear, the pass-through works fine. My question was about the automatic variables SQLXRC and sqlxmsg that, according to SAS documentation, should contains the Oracle error and Oracle error message. Instead, after an Oracle pass-through completed with error, if I execute %put ORACLE EXIT CODE: &SQLXRC; %put ORACLE MESSAGE CODE: %superq(sqlxmsg); I get ORACLE EXIT CODDE: 0 ORACLE MESSAGE CODE: insted in the log some rows above there was written: ERROR: ORACLE execute error: ORA-01400: cannot insert NULL into ("blablabla"). I expected that, after the failed pass-troguh, running the following code: %put ORACLE EXIT CODE: &SQLXRC; %put ORACLE MESSAGE CODE: %superq(sqlxmsg); I get: ORACLE EXIT CODE:ORA-01400 ORACLE MESSAGE CODE: cannot insert NULL into ("blablabla"). or something like this. I repeat, the problem it seems on automatic variables I hope it's clear now. Thanks

garag · ‎05-22-2013

Hi, I was trying to execute a sql Pass-Through versus an Oracle db. In the same sql Pass-Through I execute 3 different execute, 2 create table and a final merge. The last merge generate the following error: ERROR: ORACLE execute error: ORA-01400: cannot insert NULL into ("blablabla"). After the sql Pass-Through, if I try to put the following automatic variables %put ORACLE EXIT CODE: &SQLXRC; %put ORACLE MESSAGE CODE: %superq(sqlxmsg); I get respectively 0 and empty string, and no message has returned to me unlike what mentioned in SAS documentation http://support.sas.com/documentation/cdl/en/sqlproc/62086/HTML/default/viewer.htm#a001360755.htm Could someone help me to understand what is wrong? Many thanks. regards

garag · ‎02-06-2013

The compress seems works better that tranword:-)

garag · ‎02-06-2013

Hi, I was trying to replace each occurrence of blank with a specific character. %let myfilename=aaa bbb; %let tmpattachedfilename=/mydir/%sysfunc(tranwrd(&myfilename., " ", "")).csv; if i run %put &tmpattachedfilename; the result is /mydir/aaa bbb.csv but the blank between aaa and bbb has not been replaced. What is wrong in my code? many thanks. Antonio

garag · ‎10-22-2012

Hi Haikuo, Both works correctly, the first one is a littel bit faster. Many thanks for your reply. Antonio

garag · ‎10-22-2012

Hi all, do there is a single way to copy only dataset structure? I mean, I have a dataset with C columns and R rows, a would have a second dataset with the same C columns but with 0 rows. Many thanks. Regards

garag · ‎10-17-2012

Hi, I'm running SAS on UNIX environment. I was looking to a key definition to submit only the clipboard and not the whole program editor. Looking to the documentation: http://support.sas.com/documentation/cdl/en/hostunx/61879/HTML/default/viewer.htm#fkeys.htm it seems that there is available only the submit command that run the complete code contained in the program editor window. Do there is the same short command/key just for submit clipboard? Many thanks

garag · ‎09-05-2012

I found it. I add for someone will have the same problem in the future. ods listing close; title "this is my title"; title2 "this is my second title"; ods csvall file='/tmp/test.csv'; proc print data=WORK.a noobs; run; ods csvall close; ods listing;

garag · ‎09-05-2012

Hi, do there is a way to add a title to a csv using produced by the ods instruction? ods csv file='/tmp/test.csv'; proc print data=WORK.mydata; run; ods csv close; Many thanks

garag · ‎08-24-2012

Hi, I have the following need. I have a varible XXX and I would save the value of this variable in an external file. If I do something like this: data _null_; file 'outup.txt'; put XXX; run; The file is empty and if I do this data _null_; file 'outup.txt'; put &XXX; run; I get an error. Do there is a way to save the value of a variable in a file? Many thanks

garag · ‎08-21-2012

Hi, I need to read all values of some columns of a dataset, managed them adding some fixed string and finally put them the result string in a variable. Here you are the code: %let bodymsgstring = ''; data outds; set WORK.inputds end=EOF; length tmpbodymsgstring $10000; retain tmpbodymsgstring ''; tmpbodymsgstring = tmpbodymsgstring || col1 || trim(left(col2)) || "\n"; if EOF then do; call symput('bodymsgstring', tmpbodymsgstring); end; run; %put bodymsgstring= &bodymsgstring; The result string at the end of the elaboration is empty. Could someone explain me why? Many thanks

garag · ‎06-11-2012

Hi, I'm new is SAS. My SAS is running SAS on a UNIX machine, I telnet to that sever from my winodws pc. When I start SAS, on my pc appear some different winodws, Program Editor, Toolbox, Log, etc.... I would close automatically Result and Output windows. I've tried to: - close these windows (Result and Output); - run 'wsave a' command; - close SAS; - reopen SAS; but the windows still reappear. Two question. 1) I found a command to close Results window: dm 'odsresults; cancel'; but I didn't find a command to close Output window. To there is a command to close also Output window? 2) If a command to close Output window exist, how I can run automatically commands to close automaticcaly both windows every time I run SAS? Many thanks

garag · ‎06-06-2012

Hi, I'm getting problem reading Euro symbol € from exeternal file. Here you are the code: data mydatset; infile "&localfilename" delimiter=',' dsd missover firstobs=2; informat Date yymmdd10. Name $100. ; format Date date9.; input Date Index_Name $ ; run; If in my external file there is an Europ symbol (€), I can't get it in mydataset but a strange square is showed. Any idea abou thow to fix it? Many thanks

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Re: Reading date from input file

Re: Reading date from input file

Re: Reading date from input file

Reading date from input file

Re: Call execute single quote

Re: Call execute single quote

Call execute single quote

put statement - format used contained in a variable

Re: time HHMMSS format

Re: time HHMMSS format

Re: time HHMMSS format

Re: Writing a txt files with double quote inside

Writing a txt files with double quote inside

Re: Pass-Through automatic variable does not work

Pass-Through automatic variable does not work

Re: Replace blank with a specific character

Replace blank with a specific character

Re: Copy dataset structure

Copy dataset structure

Short Keys Definition in UNIX

Re: ODS CSV add a title

ODS CSV add a title

How to save a value of a variable in an exeternal file

Reading all values of some columns and put them in a macrovariable

How to close Output Window

Reading Euro symbol from external file