About gyambqt

gyambqt · ‎06-25-2015

HI patrick, the typo has been fixed in my original post. the value following cards statement is ab

gyambqt · ‎06-25-2015

the typo has been fixed in my original post.

gyambqt · ‎06-24-2015

Hi Experts, I have two programs, A and B, I want to know why the "if" condition is satisfied in program B but not satisfied in program A Program A: data a; input; if _infile_=:"abc" then b=1; output; cards; ab ; run; Program B: I create a txt file called “file” then I save the value "ab" to the file data a; infile "c:/file.txt"; input; if _infile_=:"abc" then b=1; run;

gyambqt · ‎05-31-2015

Hello Experts, How do I plot time variable (like 00:05:05) again a numeric variable in VA? I tried time series but it only works for date variable rather than time variable... If you use line chart then you lose the x axis label...(or scale). I know there are many other charts can solve the problem but I really want to do the plot using chart similar to line chart Thanks

gyambqt · ‎05-31-2015

Hello Experts, I want to know when I load SAS data into VA, the time variable will be adjusted back one hour even when day light saving time is not in effect. I am living in the south hemisphere and the day light saving time begin on the Oct whereas it is only Jules now. According to my research, the time variable only adjust back when it is fall into daylight saving time. Thanks

gyambqt · ‎05-18-2015

Thanks so much Cynthia!

gyambqt · ‎05-16-2015

HI Cynthia, i have replaced the content type with txt/xml rather than application/vnd.ms-excel for stpsrv_header in the excel and it produced an error when I open the stp in the excel With Amo loaded. I thought amo should open a new excel session to interpret the txt/xml output just like if you specify content type =application/vnd.ms-excel.

gyambqt · ‎05-15-2015

hi Cynthia, thanks for for your clarification. i am interested to know the logic behind for your last two screenshots that to open a Stp with Amo in the excel. so basically do you mean when you open a stp with Amo loaded in the excel, it is excel itself that receive the result or the xml file from tagset.excelxp rather than Amo when you make the content type = excel in the Stp header statement,that's why you can refresh the content with the Amo.

gyambqt · ‎05-15-2015

Hi Cynthia, Thanks for your response. Do you mean when I open a STP report using the AMO plug-in in the Excel, it will execute the STP via URL that will launch a new excel session if I defined the content type=excel, like ('Content-type', 'application/vnd.ms-excel'); in STPSRV_HEADER? In your above statement, you mentioned AMO (AMO plug in in excel) does not accept streaming results but in your other post, you have mentioned AMO can accept xml, csv and SASreport xml (I believe SASreport xml is different to xml), but what if the xml,csv and SASreport.xml has been set as a stream result in STP? Im bit confused here. Thanks

gyambqt · ‎05-14-2015

Hi Ballardw, I have modified my original post, the ; has been added.

gyambqt · ‎05-14-2015

Hello Experts, I know when you open a STP file with AMO, the AMO can only accept three type of results , html, csv and SASreport xml. I want to know why when you add the following program at the top of your ods tagset.excel statement, it can trick excel or AMO to open a new excel session? data _null_; rc = stpsrv_header('Content-type', 'application/vnd.ms-excel'); run;

gyambqt · ‎05-07-2015

I have modified the program to make it more simple.

gyambqt · ‎05-07-2015

HI ksharp, can an you use \n to read new line in regular expression?

gyambqt · ‎05-07-2015

HI RW9, I have no control to the macro check in the originally sas program. but i need to pull out information about tables has been included in the log file after the original sas program run. what I need to achieve is to modify the regular expression I have used in data step 2 which has been highlighted with dark color above to capture information from dataset a.

gyambqt · ‎05-07-2015

hi kurt, the table names is unknown And there could be more than 1000 log files out there each contain same or different table. I have to use regular expression because other information need to be extracted from the log files. The data step b is only part of the program for demonstration. actually I want to know how to use regulat expression to select information in multiple lines. i have tried \n to read new line. But it doesn't work.

Online Status	Offline
Date Last Visited	‎02-26-2024 02:16 AM

How to write a SAS program to find relationship between nodes

How to conduct impact analysis of a metadata table using SAS code

Re: Missing date column load data from Oracle to SAS

Missing date column load data from Oracle to SAS

Transfer text files from remote SFTP sever to local linux server

How to write a SAS code to extract SAS DI metadata objects?

How to identify log files differences between two log files?

Re: SAS bulkload issue

Re: SAS bulkload issue

Re: SAS bulkload issue

Re: why you can't use a macro funcation like %scan inside of a data st...

Re: How do I get the first part of the string using %scan

Re: How do I write a SAS program to re-construct the table?

Re: SAS bulkload issue

stored process questions (Stream vs Package outputs result)

Re: SAS code problem (simple one)

Re: SAS code problem (simple one)

SAS code problem (simple one)

How to plot time variable in VA

VA day light saving issue

Re: stored process AMO issue

Re: stored process AMO issue

Re: stored process AMO issue

Re: stored process AMO issue

Re: stored process http header issue

stored process AMO issue

Re: how to use Regular expression read strings on multiple lines

Re: how to use Regular expression read strings on multiple lines

Re: SAS txt file extraction problem

Re: SAS txt file extraction problem