I understand what you are explaining to me, in that order of ideas, could you tell me which is the SAS product that can allow me to do what I need please? ... View more

For an example of this serious topic, suppose we have a text that says that: "Coffee is a very important export product for the country of Colombia......" So the idea would be to relate, for example, the word coffee with Colombia, with export, and other words that must be defined. ... View more

I am presenting the following problem, it is bringing me only a part of the columns   This is how the columns of my table are, I need to eliminate what is highlighted in yellow, that is, P_ld and _with the number   I am using this code suggested by @Reeza but it is giving me this result. proc sql noprint; select catx (' = ', name, substr(scan(name, 2, "_"),3)) into :rename_list separated by " " from sashelp.vcolumn where libname='WORK' and memname='RESULTADOS_VAR_CLEAN' and upcase(name) like 'P_%'; quit; but what I really need is for the entire word to remain example: ACCESO_ADMIN_JUSTICIA AYUDA_HUMANITARIA DEBIDO_PROCESO DERECHO_DE_PETICION . . . .   ... View more

Thank you very much this really worked for me ... View more

this is my input table The idea is to rename the columns so that the columns remain without the word P_ld and without _ with the number   Here I provide the code of how I am doing it as indicated @Reeza    proc sql noprint; select catx (' = ', name, scan(name, 2, "_")) into :rename_list separated by " " from sashelp.vcolumn where libname='WORK' and memname='RESULTADOS_VAR_CLEAN' and upcase(name) like 'P_%'; quit; *rename variables; proc datasets lib=work nodetails nolist; modify resultados_var_clean; rename &rename_list; quit; and it works, this is the result, but if you look at the name of the variables I need to also remove what is highlighted in yellow, that is, the word Id     ... View more

This approach has been useful for me, however, I still can't remove a certain part of the column name, if you look at the image, the column names have a prefix called P_ld and then the name follows, so with that approach that you shared with me, I can remove the P_ and _ with numbers, but the idea is that it should look like this, for example: P_ldACCESOALAADMINDEJUSTIC_842 = ACCESOALAADMINDEJUSTIC ... View more

Thank you, this approach really helped me a lot. ... View more

This is an example of how a JSON file of a single product should look like, in this case the first product 8085     ... View more

Yes, exactly what I need is a JSON file for each product, There should be 8 JSON files left because there are 8 products (records) in the table. the result should be for example: product_8085.json product_8076.json product_8087.json product_8025.json product_8060.json product_8745.json product_9528.json product_6058.json attached image of my data   ... View more