About anandsasbi

anandsasbi · ‎12-02-2019

Hi All, I have question related to Explore and Visualization the SAS Viya Text analytics Result . I have save “Transactional data” from Categories (SAS Viya Text Analytics Model) result in Public folder table and using this public table on “Explore and Visualization data” Using “List table“ Object for view Model result data like ‘Score’, ‘Filename’, ‘Content’, ‘FileType’ & Fullpath [catx(‘/’,path,FileName)]. Using “Text Input” control Object for search particular String in Content column .(using Parameter in Text Input and applying that parameter in list table filter on Content column (using “Contains’ function ). Search option working fine and only select content records showing in list table . My requirement :- Now my client want to open or download file by click on "FullPath" column value (value like /ServerfolderPath/filename) . Here file type could be any thing (text,pdf,csv,Word etc) based on search result source file. Suppose I want to search string (“Error ORA-00022”), now based on search string 10 records showing in list table, means we have 10 file which content search string “Error ORA-00022” . list table having column ‘Score’, ‘Content’, ‘FileType’, ‘Filename’ , ‘Fullpath’ (File full path). Now I want to click on 4th row “FullPath” column string and source file should be download or open in next page by using column “FullPath” sting which full path of file. Please look attached screenshot . I want to click 3rd row “fullpath” column string and want to download or open “prob_1.pdf” in next Page. If any alternative way for fulfill my requirement then also let me know (like add any extra filter , Drop down list , Button on result set)

anandsasbi · ‎10-10-2019

can we import export Video & Picture unstructured file in SAS DI Studio . I am working on RFP and client having Video & Image file as source data which need to load on Azure data lake (HDFS file system ) & Azure DWH (SQL Server ) using SAS ETL job . I want to know that can we process Video & Picture unstructured file in SAS DI Studio if use than which transformation and format need to use . can we store Video & Picture unstructured data in SAS work table.

anandsasbi · ‎07-21-2017

I have already used (x 'export NLS_LANG=UTF-8';) in my code before LIB statement . x 'export NLS_LANG=UTF-8'; libname SAS_DEV oracle authdomain='*************'path='***********'schema='SAS_DEV'; data SAS_DEV.FX_MARKET_SIM_CHINESE length CHINESE Nvarchar(40) ; set work.Test2 ; run; but same '?' showing in Oracle table. 😞

anandsasbi · ‎07-19-2017

I have used below line before insert SAS table data in Oracle but it’s not working result is same . proc options group=language control; run; when I am running code under UTF-8 SAS Session than SAS table showing data in Chinese language but when same SAS table I use to open in SAS Normal session than Chinese data not showing in proper order. It’s means SAS internally storing data in “?” or “|_” symbol. Only showing in proper format in UTF-8 SAS Session. My SAS session support UTF-8 . @Ksharp :- could you please explain me how to change environment variable in sasenv_local when I am running my SAS code. So data store in Multi byte under SAS table. If you have any example code than please let me know.

anandsasbi · ‎07-19-2017

Hi All, I have Chinese language data in source file (.xlsx) . I am able to import it in proper Chinese language in SAS table (through UTF8 sas server) . But when I am trying to insert SAS table data into target table ( oracle table ) than all Chinese language data converted into ‘?’ marks . When Target team trying to load some sample Chinese language data directly on oracle table using import option than it’ coming in proper Chinese language format . In same table some column have data in number , date and English language data and those data inserted in proper format . I am using insert statement for load data into Oracle table. libname SAS_DEV oracle authdomain=’XXXXXXXXX’ path=”XXXXXXXXX’ schema='SAS_DEV'; proc sql; Insert into SAS_DEV.FX_MARKET_UPDATE_EXTERNAL ( ENG_DESC,SIM_CHIN_HEADER_DESC ,SIM_CHIN_HEADER_DESC, AMT_NUM, CREATE_DT ) select ENG_DESC,SIM_CHIN_HEADER_DESC ,SIM_CHIN_HEADER_DESC, AMT_NUM, CREATE_DT from WORK.FX_MARKET_SIM_CHINESE; quit; Is anyone help me in this issue? Please see attached file

anandsasbi · ‎06-26-2017

Hi KurtBremser, Thanks for your suggestion, Now I have change my code based on you suggestion ( exclude OBS and use Data step for Pick value from Table fix position ) . Now I am not getting any error. Thanks Again J data AUH (Keep = Currency Currency_Type SpotLevel VS_HKD Daily_Change header Footer ); retain Currency Currency_Type SpotLevel VS_HKD Daily_Change header Footer ; length Currency $4. Currency_Type $8. SpotLevel 8. VS_HKD 8. Daily_Change 8. header $400. Footer $400. ; format SpotLevel 10.4 VS_HKD 10.4 Daily_Change 8.2; set test2 end=done; if _n_ = 9 then do; Currency_Type = b ; SpotLevel= input(Strip(f),8.); end; if _n_ = 10 then do; Currency = SUBSTR(Strip(b),1,3) ; VS_HKD = input(Strip(f),8.) ; end; if _n_ = 11 then Daily_Change = Input(strip(Substr(f, 1 , length(f)-1)),8.); if _n_ = 12 then header = b; if _n_ = 14 then footer = b; if done then output; run;

anandsasbi · ‎06-23-2017

Hi RW9, Thanks for reply, Source team has provide us .xlsx file and this .xlsx file having multiple graph whit header & footer for each graph. I am reading header & footer data which available in fixed cell Position. If I will convert it into CSV file than graph and Cell position will be lost. But In .xlsx file and SAS table (like WORK.Test2) I am not able to see “’” & “’n” . it’s coming only in log Error. Below code i am using under UTF-8 Session. %LET SHEETNAME = "10 sec pitch Staff"; PROC IMPORT OUT= WORK.Test2 (keep=B D F R T V X ) DATAFILE= "/UnixPath/Source/external_Trad_Chinese_value_sample.xlsx" DBMS=XLSx REPLACE; SHEET=&SHEETNAME.; GETNAMES=YES; RUN; proc sql; create table Test2_Obs as select monotonic() as obs,B , D , F, R ,T ,V , X from WORK.Test2; quit; proc sql; select b into: AUD_Header from Test2_Obs where obs=12; select tranwrd(b, "(~)", " ") as b1 length=400 into: AUD_Footr from Test2_Obs where obs=14; quit; proc sql; create table FX_Market_T ( header Char(400), Footer char(400) ); quit; proc sql; /* In Insert Statement Error is coming */ insert into work.FX_Market_T values(“AUD_Header","&AUD_Footr") quit; for below string I am getting ' & 'n error but in string it's not showing . In Particulr Cell having 4 lines 高於上季的上升 1.9% 與上月相同 (-) 澳洲 Please find Screeshot of Souce Cell from .xlsx file

anandsasbi · ‎06-23-2017

Hi All I am creating a variable using proc sql :into statement from Table . Table having String in Chinese language , I am able to create variable but whenever I am try to insert this variable in a other table ( by proc sql & data step ) or want to print on log using %put then below Error is coming ERROR: The value '，高於上季的上升'n is not a valid SAS name. WARNING: Apparent invocation of macro ，高於上季的上升 not resolved. ERROR: The value '，與上季相同'n is not a valid SAS name. WARNING: Apparent invocation of macro ，與上季相同 not resolved. Note :- I am not able to see “ ‘ “ and “ ‘n “ value in table but it showing in log Error. I have upload this data from Source file (.xlsx) using UTF-8 session (on SAS EG & SAS AC) and running my current code under UTF-8 session only. Below is the some part of that string 高於上季的上升 1.9% 與上月相同 (-) 澳洲 I am able to insert data in other table but above Error coming. I want to stop this error message

anandsasbi · ‎06-18-2017

Thanks for your reply, Now it's working after change Excel file xls to xlsx .

anandsasbi · ‎06-17-2017

I have multiple excel file as source. Some source file having data in Semi Chinese & traditional Chinese language. I am using below proc import code for import excel file (.xls) . For English version file it working fine but same code not working for Semi Chinese & traditional Chinese , Output coming in unreadable format. I have also selected server U8 ( In my case it is GridSASApp_U8). %let Sheetname = “Testdata”; Proc Import out = work.Test1 DATAFILE = “/GridPath/Source/External_trad_chinese_sample.xls” DBMS=XLS REPLACE; SHEET=&Sheetname.; Run; I am using SAS EG 6.1 (32-bit) I am able to read this Chinese version file through wizard ( File -> Import data) using server GridSASApp_U8 but I can’t use code which Auto generated by “Import data” because Auto generated code using Dataline in Infile statement under data step . I have to change file location & file name based on condition. Could you please suggest me that what change require in proc Import code in order to import multi language file under GridSASApp_U8 server.

anandsasbi · ‎06-15-2017

I have excel file as source, in this .xls file have many line graph with heading , I am able to read heading which available in cell (using proc import ) but I am not able to read graph . I want to know below that two task possible in SAS or not . Can we read graph from excel file ( see example in attachment ) 2> If we can read image from excel file than is it possible to load this image in SAS dataset. Your earliest response is very much appreciated

anandsasbi · ‎04-27-2016

If you are asking about LASR table then Whenever you restart the Server your data will be lost. If you want Auto load then you need to add your source data ( SAS table,CSV) in Auto load directory . It will update LASR table (Append/Replace) in particular frequency . if you don’t have proper access on Auto load directory then contact to your Admin. You can found more details about Auto load on YouTube. https://www.youtube.com/watch?v=z-RsIyuJRrw Regards, Anand

anandsasbi · ‎04-23-2016

I have gone through the link which you have suggested, It’s regarding External URL Link. I am not able to use this for my requirement . I have created 10 reports and based on requirement each report has multiple sections. I have created one Lookup table with 10 records (different combination of Parameter value). Now I want to use this lookup table in Main report for call those 10 reports. I can’t display lookup table on main report. Once all parameter fill by controls (like drop down) on Main report I want to call particular report ( link) . I am not able to create link between Main Report, Lookup Table & Target Table. I hope you understand my requrement. Regards, Anand

anandsasbi · ‎04-22-2016

Thanks Michelle for your valuable suggestion. If I understand correctly then I need to create a table (lookup table) where I have to enter all possible combination of parameters. When user will select the parameter from all 5 controls I will join (lookup ) these control value (parameter ) to lookup tables and based on selection I have to call individual report which I have created separately. I have small confusion here, through Report interaction we use to call another report ( hyperlink ). Could you please guide me how can I call another report from lookup table, because here we can’t display lookup table on first report (report where all control has been define). I mean could you give me some example or reference where we have used lookup table (which will not used on report canvas) for call another report. Thanks in advance Regards, Anand

anandsasbi · ‎04-22-2016

Thanks for your reply. Please verify the attached file regarding my requrement. Regards, Anand

Online Status	Offline
Date Last Visited	‎01-31-2020 09:46 AM

Download or Open file in SAS Viya “Explore and Visualization data” by ...

Process Video & Picture file in SAS DI (ETL job)

Re: Unable to load Chinese language data (UNICODE) from SAS table to O...

Re: Unable to load Chinese language data (UNICODE) from SAS table to O...

Unable to load Chinese language data (UNICODE) from SAS table to Oracl...

Re: ERROR: The value 'String'n is not a valid SAS name.

Re: ERROR: The value 'String'n is not a valid SAS name.

ERROR: The value 'String'n is not a valid SAS name.

Re: Import multi language Excel file in SAS using proc import

Import multi language Excel file in SAS using proc import

Re: Lack of options in Precision layout.

Download or Open file in SAS Viya “Explore and Visualization data” by ...

Process Video & Picture file in SAS DI (ETL job)

Re: Unable to load Chinese language data (UNICODE) from SAS table to O...

Re: Unable to load Chinese language data (UNICODE) from SAS table to O...

Unable to load Chinese language data (UNICODE) from SAS table to Oracl...

Re: ERROR: The value 'String'n is not a valid SAS name.

Re: ERROR: The value 'String'n is not a valid SAS name.

ERROR: The value 'String'n is not a valid SAS name.

Re: Import multi language Excel file in SAS using proc import

Import multi language Excel file in SAS using proc import

Import image from Excel and load into SAS dataset

Re: Data sources unavailable after service restart

Re: Numbers of Section on SAS VA Report build dynamically

Re: Numbers of Section on SAS VA Report build dynamically

Re: Numbers of Section on SAS VA Report build dynamically