cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
alepage
Wednesday
  • 796 Posts
  • 177 Likes Given
  • 17 Solutions
  • 22 Likes Received

Re: NOTE 49-169: The meaning of an identifier after a quoted string mi...

by Barite | Level 11 in SAS Enterprise Guide
‎04-05-2023 06:01 PM
‎04-05-2023 06:01 PM
Same issue: data class; set sashelp.class; run; filename dest1 "/finsys/bicoe/BICOE/CR_SR_Prj/LEGO_2358_Qualtrics/test/json_class.txt"; %macro test; DATA _NULL_; file print PS=32767; set class end=lastrec; if _N_ eq 1 then do; put '{'; end; put '{ "Name" :"' Name +(-1)'",'; put ' "Sex" :"'Sex +(-1)'",'; put ' "Age" :"'Age +(-1)',' ; put ' "Height" :"'Height +(-1)'",' ; put ' "embeddedData" : {' ; put '}'; put '"Weight":"'Weight +(-1)'",' ; if lastrec eq 1 then do; put '}'; end; else do; put ','; end; RUN; %mend test; %test; ... View more

NOTE 49-169: The meaning of an identifier after a quoted string might ...

by Barite | Level 11 in SAS Enterprise Guide
‎04-05-2023 05:42 PM
‎04-05-2023 05:42 PM
Hello,    I received this notes and I don't know how to solve it.  I don't like the red line into the log.   data class; set sashelp.class; run; filename dest1 "/finsys/bicoe/BICOE/CR_SR_Prj/LEGO_2358_Qualtrics/test/json_class.txt"; %macro test; DATA _NULL_; file print PS=32767; set class end=lastrec; if _N_ eq 1 then do; put '{'; end; put '{ "Name" :"' Name +(-1)'",'@; put ' "Sex" :"'Sex +(-1)'",'@; put ' "Age" :"'Age +(-1)','@; put ' "Height" :"'Height +(-1)'",'@; put ' "embeddedData" : {'@; put '}'@; put '"Weight":"'Weight +(-1)'",'@; if lastrec eq 1 then do; put '}'; end; else do; put ','; end; RUN; %mend test; %test; NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended.     How to solve that issue ? ... View more

Re: json file, how to eliminate the square brackets

by Barite | Level 11 in SAS Enterprise Guide
‎04-05-2023 11:17 AM
‎04-05-2023 11:17 AM
Is there an option can we use with the proc json to get rid of square bracket instead of working on the obtained file ... View more

json file, how to eliminate the square brackets

by Barite | Level 11 in SAS Enterprise Guide
‎04-05-2023 10:01 AM
‎04-05-2023 10:01 AM
Hello, I would like to know how to eliminate the square brackets ex: []   %let path=/.../test; proc json out="&path./json_class.txt" nosastags trimblanks; export class ; run; [{"Name":"Alfred","Sex":"M","Age":14,"Height":69,"Weight":112.5},{"Name":"Alice","Sex":"F","Age":13,"Height":56.5,"Weight":84},{"Name":"Barbara","Sex":"F","Age":13,"Height":65.3,"Weight":98},{"Name":"Carol","Sex":"F","Age":14,"Height":62.8,"Weight":102.5},{"Name":"Henry","Sex":"M","Age":14,"Height":63.5,"Weight":102.5},{"Name":"James","Sex":"M","Age":12,"Height":57.3,"Weight":83},{"Name":"Jane","Sex":"F","Age":12,"Height":59.8,"Weight":84.5},{"Name":"Janet","Sex":"F","Age":15,"Height":62.5,"Weight":112.5},{"Name":"Jeffrey","Sex":"M","Age":13,"Height":62.5,"Weight":84},{"Name":"John","Sex":"M","Age":12,"Height":59,"Weight":99.5},{"Name":"Joyce","Sex":"F","Age":11,"Height":51.3,"Weight":50.5},{"Name":"Judy","Sex":"F","Age":14,"Height":64.3,"Weight":90},{"Name":"Louise","Sex":"F","Age":12,"Height":56.3,"Weight":77},{"Name":"Mary","Sex":"F","Age":15,"Height":66.5,"Weight":112},{"Name":"Philip","Sex":"M","Age":16,"Height":72,"Weight":150},{"Name":"Robert","Sex":"M","Age":12,"Height":64.8,"Weight":128},{"Name":"Ronald","Sex":"M","Age":15,"Height":67,"Weight":133},{"Name":"Thomas","Sex":"M","Age":11,"Height":57.5,"Weight":85},{"Name":"William","Sex":"M","Age":15,"Height":66.5,"Weight":112}] ... View more

Re: coalesce function

by Barite | Level 11 in SAS Enterprise Guide
‎04-04-2023 11:47 AM
‎04-04-2023 11:47 AM
no ... View more

Re: coalesce function

by Barite | Level 11 in SAS Enterprise Guide
‎04-04-2023 11:31 AM
‎04-04-2023 11:31 AM
data test; infile DATALINES MISSOVER; input client $ cf_client; DATALINES; 235987 236663 236900 237009 125 237720 237744 ; data test2; set test; cf2_client=put(cf_client,8.); extRef=coalescec(cf2_client,client); run; data test3; set test; if not missing(cf_client) then cf2_client=put(cf_client,8.); extRef=coalescec(cf2_client,client); run; Now, I believe that cf_client contains missing data and when cf_client is missing, it can't convert it to an empty string. Is it the case.  put(empty var, 8.) is equal to what ?  ... View more

Re: coalesce function

by Barite | Level 11 in SAS Enterprise Guide
‎04-04-2023 11:14 AM
‎04-04-2023 11:14 AM
Please note that the second variable cf_client, is numerical, that this variable is empty, except in one place where the value equal 125.  Then I convert this variable into a new one cf2_client as string variable.  Then I wish to use the coalescec function by comparing two string variable.  When the first value is empty it takes the second one and assign it to extRef.   Will it change something in your script ? Why the coalesce function seems to see something in cf2_client when it is empty ?     ... View more

coalesce function

by Barite | Level 11 in SAS Enterprise Guide
‎04-04-2023 10:47 AM
‎04-04-2023 10:47 AM
Hello,   When there is a value for cf_client, I would like extRef to be equal to that value otherwise, it should be equal to the value client.   What's wrong in the script below ?   data test; input client $ cf_client; datalines; 235987 . 236663 . 236900 . 237009 125 237720 . 237744 . ; Data test2; set test; cf2_client=put(cf_client,8.); extRef=coalescec(cf2_client,client); run; ... View more

%tslit is not recognized on Unix Server

by Barite | Level 11 in SAS Enterprise Guide
‎03-30-2023 08:36 AM
‎03-30-2023 08:36 AM
Hello,   The %tslit function is working properly using SAS EG either when we use the development server or the production server.  But when comes the time to use that piece of code below, I am getting this error:   MPRINT(TXNCNCTIMPTFRMORA): filename jsonf "/dwh_actuariat/sasdata/current/OneCx_Qualitrics/BOnline_S2023032912000000.json"; MPRINT(TXNCNCTIMPTFRMORA): data _null_; MPRINT(TXNCNCTIMPTFRMORA): infile dest1 end=eof; 22: LINE and COLUMN cannot be determined. NOTE 242-205: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred. ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, arrayname, #, (, +, /, //, ;, @, @@, OVERPRINT, _ALL_, _BLANKPAGE_, _ODS_, _PAGE_. 200: LINE and COLUMN cannot be determined. NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred. ERROR 200-322: The symbol is not recognized and will be ignored. MPRINT(TXNCNCTIMPTFRMORA): file jsonf; WARNING: Apparent invocation of macro TSLIT not resolved. MPRINT(TXNCNCTIMPTFRMORA): if _n_=1 then put %tslit({"contacts":); MPRINT(TXNCNCTIMPTFRMORA): input; MPRINT(TXNCNCTIMPTFRMORA): put _infile_; MPRINT(TXNCNCTIMPTFRMORA): if eof then put '}'; MPRINT(TXNCNCTIMPTFRMORA): run; NOTE: The SAS System stopped processing this step because of errors. NOTE: DATA statement used (Total process time):   The code:   /* Making a copy of the json file on the server */ filename &dest. %sysfunc(quote(%sysfunc(pathname(&dest.))/&JsonFName&orderdate.&ordertime..json)); data _null_; infile dest1 end=eof; file &dest.; if _n_=1 then put %tslit({"transactionMeta":{"batchId":"&batchid."%str(,) "fields":[&vars.]}%str(,)"contacts":[); input; put _infile_; if eof then put ']}'; run; Any suggestion or work aroung solution?     ... View more

working with json files

by Barite | Level 11 in SAS Enterprise Guide
‎03-29-2023 11:01 AM
‎03-29-2023 11:01 AM
filename mydata2 "/finsys/bicoe/users/rpnna322/Original.json"; data _null_; file mydata2; input; put _infile_; datalines; {"contacts":[ {"firstName": "Gustave","lastName" : "Someone","extRef":"AAAAAAAAAAA","email": "Gustave.Someone@hotmail2.com","embeddedData": {"Brand": "Beneva"}, "ConsentDate":"2023-03-28T00:00:00", "unsubscribed": true}, {"firstName": "Gustave","lastName" : "Someone","extRef":"AAAAASSSSSS","email": "Gustave.Someone@hotmail2.com","embeddedData": {"Brand": "Beneva"}, "ConsentDate":"2023-03-28T00:00:00", "unsubscribed": false}, {"firstName": "Gustave","lastName" : "Someone","extRef":"AAAAAAADDDD","email": "Gustave.Someone@hotmail2.com","embeddedData": {"Brand": "Beneva"}, "ConsentDate":"2023-03-28T00:00:00", "unsubscribed": true}, {"firstName": "Gustave","lastName" : "Someone","extRef":"EEEEEEEEEEE","email": "Gustave.Someone@hotmail2.com","embeddedData": {"Brand":"Beneva"}, "ConsentDate":"2023-03-28T00:00:00", "unsubscribed": false} ]} ; run; libname myjson json fileref=mydata2; proc datasets lib=myjson; quit; data alldata; set myjson.alldata; run; data contacts; set myjson.contacts; run; data contacts_embeddeddata; set myjson.contacts_embeddeddata; run; /**** From that point, how to we get the good sas dataset that we can use to obtain the original json file at the top ? */ proc transpose data=myjson.alldata out=have1 (drop=_name_ p1 rename=(p3=Brand)); where v>0; by p1 p3 notsorted; id p2; var value; run; Data have1; retain firstName lastName extRef email embeddedData Brand ConsentDate; set have1; run; /* Using Proc SQL approach */ proc sql; create table have2 as select a.*,b.brand from myjson.contacts as a inner join contacts_embeddeddata as b on a.ordinal_contacts = b.ordinal_contacts ; quit; /**** The final Step ? ***/ proc json out="/finsys/bicoe/users/rpnna322/Original1.json" pretty; export have1 / nosastags; run; proc json out="/finsys/bicoe/users/rpnna322/Original2.json" pretty; export have2 / nosastags; run; Hello,    I would like to import the original json file, change few records then regenerate that file from the updated sas dataset but up to now, I notice differences from the original json file in term of structure.   Could someone help me with that.   ... View more

Re: how to create automatically the json file header with sas

by Barite | Level 11 in SAS Enterprise Guide
‎03-15-2023 04:17 PM
‎03-15-2023 04:17 PM
filename myjson temp; data _null_; file myjson; infile datalines; input; put _infile_; datalines; {"firstName":"Gustave1","lastName":"Karma1","email":"someone@hotmail.com","extRef":"12345678-1234-MNOP-1234-ABCDEFGHIJKL","language":"FR","embeddedData":{"appLoginInd":"N","ubiStatus":"NO UBI","postalCode":"H0H 0H0","provinceCode":"QC"},"transactionData":{"distributor":"BEL","transactionDate":"2023-01-19","transactionType":"QUOAUTO","customerTenure":0,"policyNumber":"10000001","policyType":"AUP","cntrct_ref_nbr":11111101,"dim_pl_cntrct_ver_key":10000001,"productHolding":"AUP","agentId":"RRRRRR01","agentEmployeeNbr":"777701","agentName":"mr1 unknow1","agentEmail":"someone@hotmail.com","agentManager":"Mg1 Audi","managerEmail":"someone@hotmail.com","agentTeamCd":"AAAA1","agentHireDt":"2021-10-18"}}, {"firstName":"Gustave2","lastName":"Karma2","email":"someone@hotmail.com","extRef":"12345678-1234-MNOP-1234-ABCDEFGHIJKL","language":"EN","embeddedData":{"appLoginInd":"Y","ubiStatus":"ACTIVE","postalCode":"H0H 0H0","provinceCode":"ON"},"transactionData":{"distributor":"BEL","transactionDate":"2023-01-18","transactionType":"HOMEMOD","customerTenure":12,"policyNumber":"10000002","policyType":"RE","cntrct_ref_nbr":11111102,"dim_pl_cntrct_ver_key":10000002,"productHolding":"ALL","agentId":"RRRRRR02","agentEmployeeNbr":"777702","agentName":"mr2 unknow2","agentEmail":"someone@hotmail.com","agentManager":"Mg2 Audi","managerEmail":"someone@hotmail.com","agentTeamCd":"AAAA2","agentHireDt":"2021-10-22"}}, {"firstName":"Gustave3","lastName":"Karma3","email":"someone@hotmail.com","extRef":"12345678-1234-MNOP-1234-ABCDEFGHIJKL","language":"FR","embeddedData":{"appLoginInd":"Y","ubiStatus":"REGISTERED_APP","postalCode":"H0H 0H0","provinceCode":"QC"},"transactionData":{"distributor":"BEL","transactionDate":"2023-01-09","transactionType":"NEWHOME","customerTenure":0,"policyNumber":"10000003","policyType":"RE","cntrct_ref_nbr":11111103,"dim_pl_cntrct_ver_key":10000003,"productHolding":"ALL","agentId":"RRRRRR03","agentEmployeeNbr":"777703","agentName":"mr3 unknow3","agentEmail":"someone@hotmail.com","agentManager":"Mg3 Audi","managerEmail":"someone@hotmail.com","agentTeamCd":"AAAA3","agentHireDt":"2022-09-26"}}, {"firstName":"Gustave4","lastName":"Karma4","email":"someone@hotmail.com","extRef":"12345678-1234-MNOP-1234-ABCDEFGHIJKL","language":"FR","embeddedData":{"appLoginInd":"N","ubiStatus":"NO UBI","postalCode":"H0H 0H0","provinceCode":"QC"},"transactionData":{"distributor":"BEL","transactionDate":"2023-01-19","transactionType":"QUOAUTO","customerTenure":0,"policyNumber":"10000004","policyType":"AUP","cntrct_ref_nbr":11111104,"dim_pl_cntrct_ver_key":10000004,"productHolding":"AUP","agentId":"RRRRRR04","agentEmployeeNbr":"777704","agentName":"mr4 unknow4","agentEmail":"someone@hotmail.com","agentManager":"Mg4 Audi","managerEmail":"someone@hotmail.com","agentTeamCd":"AAA4","agentHireDt":"2022-06-13"}}, {"firstName":"Gustave5","lastName":"Marma5","email":"someone@hotmail.com","extRef":"12345678-1234-MNOP-1234-ABCDEFGHIJKL","language":"EN","embeddedData":{"appLoginInd":"Y","ubiStatus":"ENROLLED PROGRAM","postalCode":"H0H 0H0","provinceCode":"QC"},"transactionData":{"distributor":"BEL","transactionDate":"2023-01-12","transactionType":"AUTOMOD","customerTenure":1,"policyNumber":"10000005","policyType":"AUP","cntrct_ref_nbr":11111105,"dim_pl_cntrct_ver_key":10000005,"productHolding":"AUP","agentId":"RRRRRR05","agentEmployeeNbr":"777705","agentName":"mr5 unknow5","agentEmail":"someone@hotmail.com","agentManager":"Unknown","managerEmail":"someone@hotmail.com","agentTeamCd":"AAAA5","agentHireDt":"2022-09-26"}}, {"firstName":"Gustave6","lastName":"Karma6","email":"someone@hotmail.com","extRef":"12345678-1234-MNOP-1234-ABCDEFGHIJKL","language":"EN","embeddedData":{"appLoginInd":"Y","ubiStatus":"NO UBI","postalCode":"H0H 0H0","provinceCode":"ON"},"transactionData":{"distributor":"BEL","transactionDate":"2023-01-19","transactionType":"AUTOMOD","customerTenure":123,"policyNumber":"10000006","policyType":"AUP","cntrct_ref_nbr":11111106,"dim_pl_cntrct_ver_key":10000006,"productHolding":"ALL","agentId":"RRRRRR06","agentEmployeeNbr":"777706","agentName":"mr6 unknow6","agentEmail":"someone@hotmail.com","agentManager":"Mg6 Audi","managerEmail":"someone@hotmail.com","agentTeamCd":"AAAA6","agentHireDt":"2022-05-27"}}, {"firstName":"Gustave7","lastName":"Karma7","email":"someone@hotmail.com","extRef":"12345678-1234-MNOP-1234-ABCDEFGHIJKL","language":"EN","embeddedData":{"appLoginInd":"N","ubiStatus":"NO UBI","postalCode":"H0H 0H0","provinceCode":"QC"},"transactionData":{"distributor":"BEL","transactionDate":"2023-01-19","transactionType":"NEWDUO","customerTenure":0,"policyNumber":"10000007","policyType":"RE","cntrct_ref_nbr":11111107,"dim_pl_cntrct_ver_key":10000007,"productHolding":"ALL","agentId":"RRRRRR07","agentEmployeeNbr":"777707","agentName":"mr7 unknow7","agentEmail":"someone@hotmail.com","agentManager":"Mg7 Audi","managerEmail":"someone@hotmail.com","agentTeamCd":"AAAA7","agentHireDt":"2019-01-14"}}, {"firstName":"Gustave8","lastName":"Karma8","email":"someone@hotmail.com","extRef":"12345678-1234-MNOP-1234-ABCDEFGHIJKL","language":"EN","embeddedData":{"appLoginInd":"N","ubiStatus":"NO UBI","postalCode":"H0H 0H0","provinceCode":"AB"},"transactionData":{"distributor":"BEL","transactionDate":"2023-01-20","transactionType":"QUOAUTO","customerTenure":0,"policyNumber":"10000008","policyType":"AUP","cntrct_ref_nbr":11111108,"dim_pl_cntrct_ver_key":10000008,"productHolding":"AUP","agentId":"RRRRRR08","agentEmployeeNbr":"777708","agentName":"mr8 unknow8","agentEmail":"someone@hotmail.com","agentManager":"Unknown","managerEmail":"someone@hotmail.com","agentTeamCd":"AAAA8","agentHireDt":"2020-03-02"}}, {"firstName":"Gustave9","lastName":"Karma9","email":"someone@hotmail.com","extRef":"12345678-1234-MNOP-1234-ABCDEFGHIJKL","language":"EN","embeddedData":{"appLoginInd":"N","ubiStatus":"NO UBI","postalCode":"H0H 0H0","provinceCode":"QC"},"transactionData":{"distributor":"BEL","transactionDate":"2023-01-19","transactionType":"QUOAUTO","customerTenure":0,"policyNumber":"10000009","policyType":"AUP","cntrct_ref_nbr":11111109,"dim_pl_cntrct_ver_key":10000009,"productHolding":"AUP","agentId":"RRRRRR09","agentEmployeeNbr":"777709","agentName":"mr9 unknow9","agentEmail":"someone@hotmail.com","agentManager":"Mg9 Audi","managerEmail":"someone@hotmail.com","agentTeamCd":"AAAA9","agentHireDt":"2021-04-12"}}, {"firstName":"Gustave10","lastName":"Karma10","email":"someone@hotmail.com","extRef":"12345678-1234-MNOP-1234-ABCDEFGHIJKL","language":"EN","embeddedData":{"appLoginInd":"Y","ubiStatus":"FORMER UBI","postalCode":"H0H 0H0","provinceCode":"QC"},"transactionData":{"distributor":"BEL","transactionDate":"2023-01-18","transactionType":"AUTOMOD","customerTenure":11,"policyNumber":"10000010","policyType":"AUP","cntrct_ref_nbr":11111110,"dim_pl_cntrct_ver_key":10000010,"productHolding":"AUP","agentId":"RRRRRR10","agentEmployeeNbr":"777710","agentName":"mr10 unknow10","agentEmail":"someone@hotmail.com","agentManager":"Mg10 Audi","managerEmail":"someone@hotmail.com","agentTeamCd":"AAAA10","agentHireDt":"2022-06-13"}} ; run; libname dest1 JSON fileref=myjson; proc copy inlib=dest1 outlib=work; run; What we read from the oracle table is what you see into the datalines and it seems that it does not like the comma at the first line, column 705. ... View more

Re: how to create automatically the json file header with sas

by Barite | Level 11 in SAS Enterprise Guide
‎03-15-2023 03:36 PM
‎03-15-2023 03:36 PM
data have (drop= group:); infile '/myfolder/have_2.json' recfm=n dsd dlm='[]{},:'; input temp : $4000. @@; if missing(temp) then group+1; if findw(temp,'headers') or find(temp,'"rows"') or prxmatch('/^\s/',temp) then delete; if find(temp,"transactionData",'i') ge 1 then group2 + 1; if find(temp,"transactionData",'i') ge 1 and group2=1 then call symputx('group',group + 1,'g'); if group = &group. and mod(_n_,2) <> 0 then output; run; proc sql; create table have1 as select monotonic() as rownum,* from have; quit; proc sql; select distinct (quote(strip(temp))), rownum into :fields separated by ',',:rownum from have1 order by rownum; quit; %put &=fields; %let batchid=BT_10VriPO92D6e9NF; %let header1={"transactionMeta":{"batchId":"&Batchid.", "fields":[; %let header2=]},"contacts":[; %let jsonheader=&header1&fields&header2.; %put &=jsonheader; ... View more

Re: how to create automatically the json file header with sas

by Barite | Level 11 in SAS Enterprise Guide
‎03-15-2023 11:15 AM
‎03-15-2023 11:15 AM
As I have mentionned previously, I am reading a json file from an oracle table.   the original json file look like that (show only the two las records)   9 {"firstName":"Gustave9","lastName":"Karma9","email":"someone@hotmail.com","extRef":"12345678-1234-MNOP-1234-ABCDEFGHIJKL","language":"EN","embeddedData":{"appLoginInd":"N","ubiStatus":"NO UBI","postalCode":"H0H 0H0","provinceCode":"QC"},"transactionData":{"distributor":"BEL","transactionDate":"2023-01-19","transactionType":"QUOAUTO","customerTenure":0,"policyNumber":"10000009","policyType":"AUP","cntrct_ref_nbr":11111109,"dim_pl_cntrct_ver_key":10000009,"productHolding":"AUP","agentId":"RRRRRR09","agentEmployeeNbr":"777709","agentName":"mr9 unknow9","agentEmail":"someone@hotmail.com","agentManager":"Mg9 Audi","managerEmail":"someone@hotmail.com","agentTeamCd":"AAAA9","agentHireDt":"2021-04-12"}}, 10 {"firstName":"Gustave10","lastName":"Karma10","email":"someone@hotmail.com","extRef":"12345678-1234-MNOP-1234-ABCDEFGHIJKL","language":"EN","embeddedData":{"appLoginInd":"Y","ubiStatus":"FORMER UBI","postalCode":"H0H 0H0","provinceCode":"QC"},"transactionData":{"distributor":"BEL","transactionDate":"2023-01-18","transactionType":"AUTOMOD","customerTenure":11,"policyNumber":"10000010","policyType":"AUP","cntrct_ref_nbr":11111110,"dim_pl_cntrct_ver_key":10000010,"productHolding":"AUP","agentId":"RRRRRR10","agentEmployeeNbr":"777710","agentName":"mr10 unknow10","agentEmail":"someone@hotmail.com","agentManager":"Mg10 Audi","managerEmail":"someone@hotmail.com","agentTeamCd":"AAAA10","agentHireDt":"2022-06-13"}}]}   If you look at the transactionsData, you see distributor, transactionDate, TransactionType,CustomerTenure, policyNumber,policyType,cntrct_ref_nbr,dim_plcntrct_ver_key, productHolding,AgentId,AgentEmployeeNbr, agentName, AgentEmail, agentManager, ManagerEmail,agentTeamcd and agenthiredt.   So I am looking an automatic way to pull the above field name from the original json file in order to generate this header automatically   {"transactionMeta":{"batchId":"BT_10VriPO92D6e9NF", "fields":[ "distributor", "transactionDate", "transactionType", "customerTenure", "policyNumber", "policyType", "cntrct_ref_nbr", "dim_pl_cntrct_ver_key", "productHolding", "agentId", "agentEmployeeNbr", "agentName", "agentEmail", "agentManager", "managerEmail", "agentTeamCd", "agentHireDt" ]},"contacts":[   Then this header is added to the original json file and will be uploaded using a proc Http procedure.   So if we go back to this header, {"transactionMeta":{"batchId":"BT_10VriPO92D6e9NF", the batchid is obtained via a proc http call and is put in a macro variable. Then come the fields portion:  "fields":[ "distributor", "transactionDate", "transactionType", "customerTenure", "policyNumber", "policyType", "cntrct_ref_nbr", "dim_pl_cntrct_ver_key", "productHolding", "agentId", "agentEmployeeNbr", "agentName", "agentEmail", "agentManager", "managerEmail", "agentTeamCd", "agentHireDt" ]}, followed by "contacts":[   Is there a way to generate this header automatically and put its content into a macro variable to add this one into the original json file and save it under another name.         ... View more

Re: how to create automatically the json file header with sas

by Barite | Level 11 in SAS Enterprise Guide
‎03-15-2023 10:47 AM
‎03-15-2023 10:47 AM
and I need to generate the fields information related to the transactionsdata section ... View more

Re: how to create automatically the json file header with sas

by Barite | Level 11 in SAS Enterprise Guide
‎03-15-2023 10:46 AM
‎03-15-2023 10:46 AM
I read the json file from an oracle table ... View more
Contact Me
Online Status
Offline
Date Last Visited
Wednesday
Likes given to
Likes from
Quick links