Hi,   Just to make sure, are you saying using you have a solution now (using proc print)?     Thanks & kind regards, Amir. ... View more

Hi,   Please share the result that you have and also show us the result that you want (using a data step with datalines) so that we can see what the difference is between the result that you have and the result that you want.   Please also tell us some rows that you think are incorrect and why.     Thanks & kind regards, Amir. ... View more

Hi,   Congratulations on working code - I assume the truncation issue was resolved too. It's good to see your code posted in a code box.   I would further suggest you mark @PaigeMiller's post as the solution, as that identified the (one of the) problem(s) - and all from the benefit of sharing the log.     Thanks & kind regards, Amir. ... View more

Hi,   What is the length of the variable pstn on the data set?   Thanks & kind regards, Amir. ... View more

In case you missed my earlier post:     ... View more

Hi,   What is the length of the variable pstn on the data set, you might just need a length statement to capture longer length values.   Also you have no dot in the value in your latest post, so that is not the issue.   Lastly, see @PaigeMiller's advice as well as mine regarding logs, etc.     Thanks & kind regards, Amir. ... View more

Hi,   Thanks for posting the log. When posting, there are icons above the text box, you can select the icon as below when posting the log:       You don't need the parenthesis around the value when calling the macro. Change the line of code from:   pstn = &pstn_value;   so that it has double quotes around the argument as it contains an alphanumeric value:   pstn = "&pstn_value";     Thanks & kind regards, Amir. ... View more

Hi,   Please post the full log using the Insert Code icon "</>".   Also your invocation looks like it has an extra "(":   %create_ipay_pct9(ipay_pct9&year.&month, ipay_pct9_2&year.&month, (PCT.2);     Thanks & kind regards, Amir. ... View more

Hi,   Please share the code you have tried using the "Insert SAS Code" icon, and also share the log using the "Insert Code" icon ("</>").   I tried the following which appeared to work:   71 %macro test(arg); 72 %put The argument was &arg; 73 %mend test; 74 75 %test(PST.2); The argument was PST.2     Thanks & kind regards, Amir. ... View more

Hi,   You can try using the ALTLOG System Option; from the documentation:    Specifies a location to write a copy of the SAS log. Valid in: Configuration file, SAS command, SASV9_OPTIONS environment variable Category: Environment Control: Files PROC OPTIONS GROUP= ENVFILES, LOGCONTROL Default: None Note: This option cannot be restricted by a site administrator. For more information, see Restricted Options.       Thanks & kind regards, Amir. ... View more

Hi,   Also, try using a different output file name and see if it appears in the same file location. If it doesn't then there might be a mix up with the location you're looking at.     Thanks & kind regards, Amir.   Edit: Typo. ... View more

Hi,   Thanks for sharing the code and listing what you have tried.   I know you said no error messages appear in the log, but please also post the log as there might be other clues in it.   Does the modified date of the output file match the time you ran the proc export?     Thanks & kind regards, Amir.   Edit: Grammar. ... View more

Hi,   Please provide more context as to what is happening, by "failing to open" do you mean some csv file records are not appearing in an output data set?   As well as what has already been said, what code have you used and what does your log show? Please use the "Insert SAS Code" and "Insert Code" icons, respectively.   Also how many records were you expecting and how many did you get?   If appropriate, are you able to provide a small example with data?   Notepad++ can be used to show non-printable characters in files, including end-of-line (EOL) characters, via pulldown menu View > Show Symbol > Show End of Line.     Thanks & kind regards, Amir. ... View more

Hi,   Part of the subject says "I am unable to execute merge...", but the log shows the merge has been executed. Another part of the subject says "SAS is not able to detect data set A and B...", but the log shows data set A and B were detected when they were used in the merge.   Are you happy with the results of the final data set? If yes, then what is your question? If no, then what result did you expect to get instead - please supply a data step with datalines showing the output you expect.     Thanks & kind regards, Amir. ... View more

Hi,   I'm not sure if your subject line has been truncated; was there more to it?   Please provide a data step with datalines to show what output data set you are expecting, along with a brief explanation of the logic rules that generate your output.     Thanks & kind regards, Amir. ... View more