About Aditi24

Aditi24 · ‎06-07-2016

All I want is to get the ID & password of the user (which they'll input) and propogate it further to a macro and then to a Java API. Please let me know if there is some other facility to do that. As of now I am trying to do this using %windows. I am a noob in SAS Macro porgramming.

Aditi24 · ‎06-06-2016

Hi All, SO currently I have been working on a SAS script where I have to get UserID and password through the below code:- %let userid=; %let pass = ; %MACRO login; %WINDOW info #1 @2 'QSP LOGIN:' attr=highlight #5 @5 'Please enter userid:' #5 @26 userid 20 attr=underline #7 @5 'Please enter password:' #7 @28 pass 20 attr=underline display=no; %DISPLAY info; %MEND login; %login; and the pass the obtained value of userid and password to another macro which looks like this:- %qspDataTransfer( id=&userid ,password=&pass ,env=test ,study=0431 ,comp=mk0431-sit1 ,prot=abc ,filepath=/demo ,filename=py.sas7bdat ,PRS_program=TEST ,PRS_project=TEST_PROJECT ,email='aditi.singh@merck.com' ); but this is giving error : Apparent symbolic reference not resolved. Please help!

Aditi24 · ‎06-06-2016

Hi, I am making a script in which the program have to store the credentials of the user so that is could be passed to a Java API for further execution. I am using the below script to get the input:- %window info #1 @2 'MODSPACE LOGIN:' attr=highlight #5 @5 'Please enter userid:' #5 @26 user 20 attr=underline #7 @5 'Please enter password:' #7 @28 pass 20 attr=underline display=no; %display info; After that I have to call the tcpunix.scr file to login to the remote server. Now the script prompts its own authentication screen for input and I don't want that. I want the input that I've got using the above code to be passed to the script. Please let me know if there is a way. It will be much helpful.

Aditi24 · ‎05-19-2016

My code is a mix of SCL and Base Programming because of which the macro variable "protpath" was getting resolved in the code. Using the below snippet resolved the problem: %let match_string= %nrstr(procprinttoprint=%"&protpath/outlist/); Thanks so much everyone for your input. This was urgently required.

Aditi24 · ‎05-19-2016

Hi Reeza, I want to match a particular line from the file having content like so proc printto print = "&protpath/outlist/Programname.lst" log = "&protpath/outlog/Programname.log" new; run; So, to match the first line exactly I am using if lowcase(compress(tt)) =: 'procprinttoprint="&protpath' since the rest of the below string is not fixed and I want to use it as it is without any macro resolution. Also, I tried using %nrstr but since its SCL code its not working in my data set. procprinttoprint="&protpath

Aditi24 · ‎05-19-2016

Hi, I have a conditional clause in my code which looks like below:- if lowcase(compress(tt)) =: 'procprinttoprint="&protpath' Now, I want to use this string as it is for comparison without resolving the macro variable "protpath" but its not letting me do so. Please help!

Aditi24 · ‎05-10-2016

Hi, Please suggest the areas in SAS Programming that are needed to be focussed upon to have expertise & grow as a SAS professional. Your input is valuable, please suggest. Thanks

Aditi24 · ‎04-19-2016

Thanks @BrunoMueller

Aditi24 · ‎04-19-2016

Thanks @SASKiwi, you are a saviour.

Aditi24 · ‎04-14-2016

Hi @SASKiwi, The code is giving below error:- 68 ERROR 68-185: The function OPTGETC is unknown, or cannot be accessed. 2883 Msg = sysmsg(); 2884 put msg = remote_session =; 2885 rc= rlink(remote_session); ----- 68 ERROR 68-185: The function RLINK is unknown, or cannot be accessed. 2886 if rc = 0 then put 'No link exists.'; 2887 else put 'A link exists.'; 2888 call symputx('rc', put(rc,2.)); 2889 run;

Aditi24 · ‎04-14-2016

Hi, I am authenticating to the UNIX server using the below statements:- proc printto log='C:\Temp\sastest.log' new; run; %let remote=lwstv21.__8015; signon remote=&remote cscript='C:\Script\tcpunix93.scr'; data _null_; time_slept=sleep(20,1); tday=today(); current=time(); put 'Execution time : ' current=time. tday date9. ; run; signoff; proc printto; run; My userid and password details are already in the tcpunix93.scr file and this script has been automated. But I need to make some changes in the code such that if the signon fails it retries signing on 2 more times . I dont want to read the log file everytime since it will bring much overhead to the code. Please suggest me a way to achieve this requirement.Thanks!

Aditi24 · ‎04-08-2016

I am getting oracle error while trying to establish a connection to my oracle database. I have installed Oracle client 32 & 64 bit version on my system and tried resolution methods available on SAS support but no good.Please find the attached image and help me with the resolution. Thanks.

Aditi24 · ‎03-30-2016

Thanks so much @Kurt_Bremser and @SASKiwi

Aditi24 · ‎03-30-2016

*VERSION - SAS 9.3 *OS - Windows 7 *Problem - I use 3 SAS sessions, but when I open the one marked as SAS2 I receive a warning: WARNING: Unable to copy SASUSER registry to WORK registry. Because of this, WARNING: you will not see registry customizations during this session; Also, I had customized the toolbar by adding one more icon and that icon is not there when I open new sessions. Please help me to get it resolved.

Aditi24 · ‎03-22-2016

Hi @LinusH: First I am establishing a connection to the SAS server on the remote UNIX server then I am creating the batch i.e batch.sas , by including some files like so:- %include "/pgmsetup/startup.sas"; %include "/backup/adhoc/AKReq34.sas"; Then I am submitting the batch by using statements like so:- "nohup sas93 -noterminal /backup/adhoc/batch.sas -altlog /backup/adhoc/batch.log -print /backup/adhoc/batch.lst 2>/dev/null &";

Online Status	Offline
Date Last Visited	‎11-13-2018 08:00 AM

Re: SAS VIYA Installation on LINUX

Re: SAS VIYA Installation on LINUX

SAS VIYA Installation on LINUX

Re: SAS VIYA Installation Error

Re: SAS VIYA Installation Error

SAS VIYA Installation Error

SAS VIYA Install on Oracle Linux

Unable to use wildcards in log file name

Re: Comparison of two SAS libraries.

Getting error while assigning library in a macro

Re: Substitute value of column with other table.

Re: Checking Authentication in SAS

Re: Checking Authentication in SAS

Re: Checking Authentication in SAS

Re: Sending Email with SAS 9.3

SAS VIYA Installation Error

Re: Passing macro variable to another macro

Passing macro variable to another macro

Passing credentials to tcpunix.scr file

Re: Use string without resolving macro

Re: Use string without resolving macro

Use string without resolving macro

What are the focus areas for SAS Professionals for the future

Re: Checking Authentication in SAS

Re: Checking Authentication in SAS

Re: Checking Authentication in SAS

Checking Authentication in SAS

Oracle connection error

Re: Registry error while using SAS 9.3

Registry error while using SAS 9.3

Re: Problem running batch on Unix server