Hello,   I'm trying to learn how to use prompts in SAS:   I have prompt set up as 'prompt_1' which can either have value of Year1 or Yearly. I have a couple of proc sql and data set statements that need to run only if the prompt_1 value is Year1. Please find the code, it gives no errors, but I get no output either. Please suggest what am I doing wrong.  data _null_; %put &prompt_1.; prompt_1 = "&prompt_1."; run;   %macro determinecall(prompt_1); %if %upcase(prompt_1) = 'YEAR1' %then %GO; %mend determinecall; %determinecall(prompt_1); %macro GO; proc printto log= "/sasuserhome/test/test.log"; run; proc sql; create table paylist (IdNum char(4), Gender char(1), Jobcode char(3), insert into paylist values('1639','F','TA1') values('1065','M','ME3'); select * from paylist; quit; data alpha; infile datalines; input a b c; datalines; 1 5 10 0 8 7 1 4 6 ; run; proc print data= alpha; run; %mend;     ... View more

Data T; length s $1; merge vendor (in = a) clue (in = b keep = clue mail_name) ; LENGTH PROD_TP $4; by mail_name; if (a); if index(upcase(clue),'{LOLO}') > 0 then do; if lolo = "Q" then cot=tranwrd(upcase(clue),'{LOLO}','T'); else if lolo = "P" then cot=tranwrd(upcase(clue),'{LOLO}','U'); end; else cot = clue; if %str(Language = 'N'); If (Unit = 'CC' and Deliver in('AC' 'BC')) then FINAL = compress(Name1||',!,'||cot); else FINAL = compress(Name||',!,'||cot); if s = 'Y' then delete; run; Hello,   I have 2 datasets that I'm trying to merge and get a certain desired output by running a macro in a remote location. Since that macro is being utilized for other codes, I cannot make any changes to it. I tried copy pasting that macro in a seperate SAS program to understand what it is doing, but I can't see which if conditions are being followed. (already tried adding options mlogic, symbolgen and mprint). The only place where I can make a change is in the code that creates the Vendor dataset. I've added the sample datasets, the macro code and the log. Assuming both the datasets are sorted by the 'by' variable, the merge does not seem to be working correctly. Appreciate the help in helping me understand the problem.   ‘Vendor’ dataset: Name Language Mail_Name Unit User1 N Mail MailUnit User2 N Mail MailUnit User3 N Mail MailUnit   Clue dataset: Name_Vendor Clue Mail_Name Vendor Test Mail Vendor1 Test1 Mail   Macro code:   Data T;      length s $1;      merge            vendor         (in = a)            clue         (in = b keep = clue mail_name)      ;      LENGTH PROD_TP $4;      by mail_name;        if (a);        if index(upcase(clue),'{LOLO}') > 0 then            do;                 if lolo = "Q" then                      cot=tranwrd(upcase(clue),'{LOLO}','T');                 else if lolo = "P" then                      cot=tranwrd(upcase(clue),'{LOLO}','U');            end;      else cot = clue;           if %str(Language = 'N');        If (Unit = 'CC' and Deliver  in('AC' 'BC')) then            FINAL = compress(Name1||',!,'||cot);      else FINAL = compress(Name||',!,'||cot);        if s = 'Y' then            delete; run;   Current O/P:   S Name Language Mail_Name Unit Clue PROD_TP LOLO COT Unit Deliver FINAL Name1   User1 N Mail MailUnit             User1,!, .   User2 N Mail MailUnit             User2,!, .   User3 N Mail MailUnit             User3,!, .   The O/P that I'm trying to get (values in Clue, COT and FINAL):   S Name Language Mail_Name Unit Clue PROD_TP LOLO COT Unit Deliver FINAL Name1   User1 N Mail MailUnit Test     Test     User1,!, Test .   User2 N Mail MailUnit Test     Test     User2,!, Test .   User3 N Mail MailUnit Test     Test     User3,!, Test .   Log: NOTE: Variable s is uninitialized. NOTE: Variable PROD_TP is uninitialized. NOTE: Variable lolo is uninitialized. NOTE: Variable Unit is uninitialized. NOTE: Variable Deliver is uninitialized. NOTE: Variable Name1 is uninitialized. WARNING: Multiple lengths were specified for the BY variable mail_name by input data sets. This might cause unexpected results. ... View more

Hello,   I'm trying to run this piece of code, it does not produce any errors but does not give any output either, so I'm unable to understand what it is meant to do:     %let files=\\shared drive path\temp\abc\*.txt;     %macro disp (var);      %sysrput &var = &&&var.; %mend;   %disp(files);   I had a few questions, and would really appreciate if you could help me understand: 1. %let files command creates the folder abc in that location if it doesn't exist and also creates some txt files? Or is it just acting as a reference to those .txt files when they might get created in the future? 2. what purpose does the macro disp serve here? Is it to make the location of files global? ... View more

I find such process flows in almost every project. What does the folder icon mean here ?    Also, where can I learn how to create these process flows in SAS EG and understand how to use them ... View more

Hello,   I'm trying to understand few concepts about the macro variables through this piece of code:   %macro check;      %global test;      %do;      proc sql noprint;      CONNECT TO SQLSVR (datasrc=teradata user=%sysget(USER) password="&passwrd.");      select * into : test from connection to SQLSVR       (SELECT MAX(height) from profile_table) disconnect from SQLSVR;                 quit;            %end;            %sysrput test= &test; %mend check; %check;    option nosource; %put test= &test.; option source;   Next to each line, I'm adding what I think that statement does, requesting your help to confirm if my understanding is correct:   %macro check;      %global test;//creates a global macro variable      %do;      proc sql noprint;      CONNECT TO SQLSVR (datasrc=teradata user=%sysget(USER) password="&passwrd.");      select * into : test //does a refer to the global macro variable created above? Or is test some other variable that gets created remotely on the server location? what is the purpose of this statement? from connection to SQLSVR       (SELECT MAX(height) from profile_table) disconnect from SQLSVR;                 quit;            %end;            %sysrput test = &test //value of remote test (which is in the select statement) gets transferred into global macro variable test defined at the very top?? %mend check; %check;    option nosource; %put test = &test.;//which test is being displayed here? the global macro variable or the one in the select statement or? option source;   Also, why is it written test. in some places and test in other places(with and without the period)?   Thank you for your help! ... View more

Hello,   I have a code that I'm trying to correct because I wanted to understand and learn the unix component in sas. The aim is to archive files and move them from the "original path" to the "new path". This is the code that I received:   abc="mv -f /original path" || strip (_infile_) || "/new path"; if not fileexist("/new path" || strip (_infile_) then rc=system(abc)); put abc=; abc= 'find /new path -type f \( -iname "*.*" ! -iname "*.gz"  ! -iname "*.Z" ! -iname "*.tgz" ! -iname "*.zip" \) -execdir gzip {} \;'; rc=system(abc); put abc=;; run;   So far this is what I have understood: abc="mv -f /original path" || strip (_infile_) || "/new path";--this command moves the files from the old location to the new location, creating the new location folder structure   if not fileexist("/new path" || strip (_infile_) then rc=system(abc));--if the new location directory/folder structure does not exist, then run the command abc to create the new folder structure and move the files   rc=system(abc);--return the value received after the execution of the above command abc   put abc=;--if successful execution, returned value is 0, else 1   abc= 'find /new path -type f \( -iname "*.*" ! -iname "*.gz"  ! -iname "*.Z" ! -iname "*.tgz" ! -iname "*.zip" \) -execdir gzip {} \;';--command abc will now switch to the new path directory and execute the specified command.   rc=system(abc);--return the value received after the execution of command abc   put abc=;;--if successful execution, returned value is 0, else 1   run;   Please suggest if my interpretation of the above code lines is correct.   Also, in the line abc= 'find /new path -type f \( -iname "*.*" ! -iname "*.gz"  ! -iname "*.Z" ! -iname "*.tgz" ! -iname "*.zip" \) -execdir gzip {} \;'; what does the entire iname command even mean? Is it zipping all the files irrespective of what their names and extensions are? Or are the files already zipped and it is converting that to gzip? I just cannot interpret that.   And I think these are the following syntax errors in this piece of code, please suggest if that's how unix syntax works: 1. Instead of abc="mv -f /original path" || strip (_infile_) || "/new path"; it should be abc=mv -f "/original path" || strip (_infile_) || "/new path";   2. Instead of  if not fileexist("/new path where the files need to go after being archived" || strip (_infile_) then rc=system(abc)); it should be if not fileexist("/new path where the files need to go after being archived" || strip (_infile_)) then rc=system(abc); but isn't filexist supposed to have only one arguement?   3. Just before run, put abc=;;--I'm hoping this is a typo, why would there be 2 ; anyway?   Thank you! ... View more