excel - How to export SAS dataset to XLSX, by category, using macro variable? -

-

I have a large data set, which has around 100 managers, now I have to export data with the manager name so that I There is a dataset for each manager. I am able to use a macro to create a different dataset for each manager (essentially, one category) using code: 

 % macro brake (bawl); Data and bawl; Last set (where = (Project_Manager_Name = "& byval")); Run; % improvement; Data_null_; Last set; By Project_Manager_Name; If the first.progress_or_name then execute the call (% nrstr ('% break (' || trim (Project_Manager_Name) || '))); Run;   
 This is where I get stuck. I just need the .xlsx files of each and like, the names of the manager at the end of each file name include:  
  proc export data = final dbms = outfile xlsx = "& amp; ; Output. \ Final_Report_ManagerName.xlsx "Replace; Run;   
 I think I get anywhere in the name outfile  & amp; Byval  has entered the macro variable, but I still get errors that this reference is not. Any insights?   
 
 
 To use PROC export you must write a macro and call the PROC export 100 times . This is not a great way to use LIBNAME to do the same thing, but instead of 100 export calls, you have 100 dataset names in your data phase and to identify what to do with each manager's data Having 100 selections / When / Output are conditional blocks.  
 Better ways:  
     
  •  If you have 9.4 M1, then you can use ODS Excel to do this. Look at the ODS Excel, and after that you can create a new Sheet for each group using the Sheet_Label option, which can define a sheet name with the variable. This option (as ODS is most of Excel) is similar to ODS TAGSETS.EXCELXP.  
  •  If you are not, you could use a hash object output method, though still, efficiently to do this a bit more ideally - at least it's a ton of macro programming   
       
     At the end of the day, making an export macro and calling it this way how do you get a% brake macro Call (or, more likely, set the export code inside the brake macro ) Is probably the easiest thing to do, even though it's not exactly ideal (very long periods of time for which you are).  
      proc export data = & amp; Byval Dbms = xlsx Outfile = "& amp; Output. \ Final_report_ & amp; Byval..xlsx"; Run;   
     To do this, you need to go inside the% brake macro. You can also skip the data phase in byval and just add one to export,  data = Final (where = (Project_Manager_Name = "& byval")).

Comments

Post a Comment

Popular posts from this blog

java - ImportError: No module named py4j.java_gateway -

-
I'm trying to call the Python using the Java program py4j . I've been installing the plug-in Eclipse and test name Piidvi project. I'm trying to execute the following part of the code found on py4j webpage: Import from py4j.java_gateway to JavaGateway, java_import gateway = JavaGateway () jvm = gateway.jvm java_import (jvm, '' Org.eclipse Kkorkrisorsej. * ") Vrkspes_rut = Jvankresourkesplginkgetvrkspas (). GetRoot (Gateway .help (workspace_root, '* Projects *') project_names = [project.getName () (for projects workpace_root.getProjects))] print (Projekt_nam) But I There is an error in import. I have checked that the P4JJ is present in the Jar Eclipse plugin directory. Can anyone help please? I had to install the py4j application
Read more

python - Receiving "KeyError" after decoding json result from url -

-
I am new to Python I am trying to parse JSON result from a URL. Basically, I was using the following: response = urllib.request.urlopen (url) json_obj = json.load (response) It should be a stroke "str 'not' bytes' in the lines of a given" JSON object, so after searching on the StackoverView Flo, I decode the response in this way: F = urllib.request.urlopen (Url) charset = f.info (). Get_param ('charset', 'utf8') data = f.read () decoded = json.loads (data.decode (charset)) If I print "decode" I is as follows: { 'link': { 'summary data': 'https: // localhost / piwebapi / streams / p0_7qHaW4UHU-RlCaz8tpasAAQAAAAU0hJTExNQU42NDIwXFNJTlVTT0lE / summary' 'value': 'https: // localhost / Piwebapi / streams / P0_7qHaW4UHU-RlCaz8tpasAAQAAAAU0hJTExNQU42NDIwXFNJTlVTT0lE / price ',' InterpolatedData ':' https: // localhost / Piwebapi / streams / P0_7qHaW4UHU-RlCaz8tpasAAQAAAAU0hJTE...
Read more

.net - Creating a new Queue Manager and Queue in Websphere MQ (using C#) -

-
"itemprop =" text "> I am writing applications that use WebSphere MQ to send messages. My unittests (for flow), I want to verify that I have put the correct message on the response queue. I am trying to figure out how to do this. My main obstacle is that I think it might be scary to clear the queue before running in my queue because the same queue can be used by other applications, I thought a decent solution would be a new line The manager will remove the queue for my solidarity and after using it. So my question is: Is it possible to use C # by using queue manager and queue? After the For future reference and future people, who want to make queues. I thought how to make and remove IBM MQ QE (not quenhers) with PCM messaging. It is not very simple, but it can be done. We have implemented it in a library and it is being used to create and delete commands before and after integration tests. The most important part of the code in this library is shown in the...
Read more