And you can avoid any macro coding altogether: where closingcycle = " " !! substr("&_CYCLE.",1,6); Which makes it clearer that you do want two leading blanks. ... View more

When you get such intermittent issues, you might have a damaged storage volume.   For more detailed help, post your question in a new thread, and include log(s) of failures. ... View more

Informative and interesting! 👍   - Dr. Abhijeet Safai ... View more

@Sastech  If your problem/question is about different data then you should start your own thread. Where it is related to another thread you can post a link to it by copying the the URL from your browser and posting into your message.   Since your data is quite different to start with you have to show an example of what you expect for output. I have no idea what you expect as you provided no details just that your data is different and multiple ids. Nothing about how the ID would affect the output. Nothing about what the values should be. ... View more

The second INPUT is to read the next line and write it onto the end of the current line being written.  You should probably test whether or not it works when there are multiple extra end-of-lines embedded in the same record.   The last PUT is the end the line that is being written since the previous PUT statements had trailing @ which does not write the end-of-line characters.   Probably the simplest way to convert the |'s back into ' is to do it in the variables you end up with in your SAS dataset after you have successfully read in the fixed file.    Here is a data step that will replace all | with ' in all character variables in a SAS dataset. data apostrophe; set bar ; array _char_ _character_; do over _char_; _char_ = translate(_char_,"'",'|'); end; run; ... View more

This is working!  options nofmterr;  is working absolutely fine @Kurt_Bremser !     Thanks once again! 😊   Thanking you, Yours sincerely,   - Dr. Abhijeet Safai ... View more

Is your SAS server OS Windows or Unix/Linux?  Right now you're using a Windows DIR command with a Unix path.... Your log shows that macro variable &fn1 doesn't exist and because you're using it as part of a path the path won't be valid even after you fix the rest of the path. Not sure why you're creating all these macro variables &fn<n> given that you later on only try to use &fn1 ...which obviously doesn't get created. If you really need all these macro variables then replace this incomplete list of IF statements with code like below. ....but first you need to get your logic right.   ... View more

Hey..   It pretty much simple.   data check_var; dsname=open("sashelp.class"); varname_=varnum(dsname,'AGE'); if varname_ >0 then flag="Y"; else flag="N"; /* if flag="Y";*/ run;   ** If you want to create a macro then use the below code . data _NULL_; call symputx("Checkv", varnum(open("sashelp.class"),'AGE')); run; %put &Checkv.; ... View more

What do you mean by "create a macro program" ? Is Cal itself a macro  program, starting with %macro <name>(...); and ending with %mend ? Or does it generate a macro program? In first case you can just %include <path>/Cal.sas at the top of any program you want to use Cal macro program. The mcaro will be compiled at submission and used when called. In second case you need to keep the generated macro progam as a <filename>.sas in a folder then use it as described above. ... View more

Do it like this it will work data test_fmt; length label $15; fmtname='range'; input start $ end $ label :$; datalines; LOW 20 "good" 21 high "excellent" other . "missing" ; run; ... View more

Thank you, sir for responding. In my scenario, one of the dataset is recurrence kind of log line/repeating section. So, the visit is repeating for few datapoint. So, I add the repeating section datapoint to the catx statement and was able to get generate the report. For other datasets, reach out to get a more stable data. thank you so much sir for helping me. ... View more

Yes.  Thanks.  Fixed it now. ... View more

Be prepared for much heartbreak if you expect to combine any of these data sets after importing into SAS. If these XLS are supposed to have the same content you may be surprised to find that IMPORT creates variables with different type and lengths, and possibly names, as decisions as to the properties of each set are made without regards to content of other files.   You may want to investigate creating CSV files from XLS and then using a data step to read each so that the sets all have the same properties. ... View more

It depends on what you mean when you say you have two or more variables.  So give an example.  Certainly the BY statement supports multiple variables, but the outcome might not be what you have in mind. ... View more

You asked "how much effort should I put in learning SAS commands? Is it better to use PROC SQL and what I already know or using SAS language is better?"   SAS SQL is a little different then other systems' SQL. You can use SAS functions and some SAS file options within SAS SQL.  SAS Base, in some cases, is shorter in code and more efficient. Sas Base contains statements (commands), functions and many procedures.  Some of these code may differ depending on the SAS platform you use. You should look for a learning program in order to progress efficiently to get a good experience.  ... View more