About JuanS_OCS

JuanS_OCS · ‎03-25-2016

Hi, I am not sure to fully understand you, but I let me give it a shot. What I think you are looking for is: - to create a new Query Builder of your 2 generated tables, so you can create the union - and add an additional step to load the data into LASR. Are those 2 steps clear or any is not clear to you?

JuanS_OCS · ‎03-22-2016

Hi, asyou have been advised, first you need to have permissions to run x commands (XCMD option), but I don't believe that was your question. To simplify my answer, what you will need is to create an external file with all the ssh commands (which can be created with SAS or be just an static file), then call: putty.exe -ssh [domain name] -l [username] -pw [password] -m [the directory of the .txt file you created which contains the codes you want to be executed]. Besides: You might prefer to use plink.exe (from the PuTTY web page) and not putty.exe Without plink, the only way is to use the -log <logfile> options and then print its content and delete it. The problem with this option is that it will print the username and password in the logs. Probably there is an option to use a secured profile instead

JuanS_OCS · ‎03-21-2016

Hi, if you work for a company, the download of SAS University edition is a good option to learn, or even try part of the SAS software, but please keep in mind that if you use SAS for processing data with commercial purposes, you will need yo buy SAS, at least the most basic package. FYI: http://support.sas.com/software/products/university-edition/ Literally: "SAS University Edition includes the SAS products Base SAS®, SAS/STAT®, SAS/IML®, SAS/ACCESS® Interface to PC Files, and SAS® Studio. Teachers, students, adult learners, and academic researchers can access the SAS University Edition software for noncommercial learning purposes. You can download SAS University Edition for free, directly from SAS. After you download it to your PC, Mac, or Linux workstation, SAS works locally on your machine by using virtualization software and your browser, so no Internet access is required. Or you can get SAS University Edition for free via AWS Marketplace (AWS usage fees may apply). The software runs in the cloud - all you need is a browser and an Internet connection. For more information, visit SAS University Edition at www.sas.com." This means, that SAS University edition won't allow you to connect to any database, only Microsoft Office files and SAS datasets. (SAS/ACCESS® Interface, is the component for the access to data origins). It is also good to keep in mind that, as SAS University edition purpose is learning, it does not have all the procedures you might need. In any case, I would advise you to contact SAS, so you can get a good overview of the SAS Software and SAS can identify which would fit better to your requirements.

JuanS_OCS · ‎03-21-2016

Please attend the questions from @jklaverstijn, that would help us to understand your problem, starting from the first question is to know the errors you are getting,

JuanS_OCS · ‎03-21-2016

Hi, there is no direct option yet, Instagram is currently not supported. But if you have a code (SAS or external party) to load the data from Instagram to any data tarjet (SAS dataset, text file, etc), you will be always be able to run a SAS code to load the data into the LASR server to start your analysis.

JuanS_OCS · ‎03-19-2016

Hi, I am sure others can provide better suggestions. For now: - do you use Enterprise Guide? If you do, you might fins useful this tip from Chris Hemedinger https://communities.sas.com/t5/SAS-Enterprise-Guide/Importing-Extremely-Large-Text-File/td-p/152222 - anyway, you could always load the data of the txt file into a SAS dataset, then you can make the transformation on the dataset, then load the dataset into a different txt file. Probably there is another method much more optimal, with less steps, but, for now can now work with this procedure If you need support with the statements, you can always give a look into the SAS help manual, or ask around over here 🙂

JuanS_OCS · ‎03-19-2016

Hi, This can occurr if your machine has a different time of the time running on you at processes. Please check the logs of at (bar/logs/at i giras) and compare with your current system time. I expect this to be solved if you restart your at service.

JuanS_OCS · ‎03-19-2016

Hi, as recommended, what you will need is support for UNICODE from the SAS configuration. You can do this by adding it, by updating your binaries, and you can also do it manually by changing some files called sasv9.conf or sasv9_usermods.conf. Please read the documentation below: https://support.sas.com/resources/papers/Multilingual_Computing_with_SAS_94.pdf https://support.sas.com/resources/papers/AddingAdditionalSASWorkspaceServerstoSupportMultipleEncodings.pdf

JuanS_OCS · ‎03-19-2016

If you have the license of SAS/ACCESS Interface to PC Files, which I guess you do, you can use libname statements, then access the data with data steps or proc sql statements: http://www2.sas.com/proceedings/sugi27/p025-27.pdf http://support.sas.com/documentation/cdl/en/acpcref/63181/HTML/default/viewer.htm#p0psac3j16cioen1nq2hkwrnk55y.htm

JuanS_OCS · ‎03-17-2016

Good ones Kurt. Another option is to get license for SAS/SHARE, then you can avoid those kind of problems

JuanS_OCS · ‎03-16-2016

Hi, please try again, I removed the extra ")." Characters from the link on my post. Otherwise, there you are: http://support.sas.com/documentation/cdl/en/bimtag/68217/HTML/default/viewer.htm#n0nakjyj6hlqmvn11p9p04l25j9n.htm

JuanS_OCS · ‎03-16-2016

Hi, Shall we understand you have SAS 9.4? Which maintenance? Do you have https/certificates only on the SAS web server or in the SAS Application server too? Anyway, please let me provide you an answer sticking for now just to the basics: https/certificate only on the web seever. 1- when you have the new certificate, please ensure that the key is the same. If you have a certificate chain file this will need to be updated too : http://support.sas.com/documentation/cdl/en/bimtag/68217/HTML/default/viewer.htm#n0nakjyj6hlqmvn11p9p04l25j9n.htm 2- when you have the files, update them on the SAS Web Server as mentioned on the above link. 3- restart only the web browser 4- validate that it works fine and is validated trough a web browser. 5- when is valid, you will need to import the new chain in the private Java keystore , also as on the same link 6- restart your SAS middle tier services. 7- if you can validate you SAS content server from the management console it should be ready for LASR too. Now, not all is finished. If you use or plan to use the SAS Environment Manager, there is. At least one additional step, to add the certificate chain into the SAS environment Manager private java keystore, as mentioned on: http://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.3&docsetId=secref&docsetTarget=n12033intelplatform00install.htm&locale=en Remember, you will most probably need or want to update the certificate on the server level too (if windows) and in the clients' web browsers. Post Edited in 2018-03-17 to include Greg's update for the second link. Thank you @gregraka!

JuanS_OCS · ‎03-16-2016

Hi, One general option would be explained in 2 simple steps: 1- if you can transform your reports coming from SAS Enterprise Miner into a Stored Process, 2- you can call a Stored Process from any location in SAS, including embeding SAS Stored Process in SAS Visual Analytics. For the first: http://www2.sas.com/proceedings/forum2008/145-2008.pdf For the second step: http://bi-notes.com/2015/12/adding-stored-process-sas-visual-analytics/ Good luck! 🙂 Let us know if this works fine for you!

JuanS_OCS · ‎03-15-2016

Hi, may you could check if the internal/external urls in DP-Environment manager and Environment Manager Mid tier are set up properly to HTTPS? I heard from a colleague a similar issue, and it could be related to something related to a missing configuration. Anyway, I would recommend you to contact SAS Technical Support for this type of problem.

JuanS_OCS · ‎03-15-2016

Hi, just a wild guess, but I can see a different "minus sign"on the sysin and the nosplash and icon parameters, which I could see many times on copy and paste from windows. If you run this from the command line, try to type it by hand, replacing the "-" signs by your keyboard's "-" sign.

Online Status	Offline
Date Last Visited	‎04-13-2026 07:47 AM