OrderID1 and OrderDate1 are for customer1 in other database, I want to set this specific customer information as macro variable, then I can pull information from other tables in different databases.   OrderID2 and OrderDate2 is for customer2.   The goal of ther whole big script is to find the relationship between these two customer , eg: whether they are in the same company/team and who is their reporting officer, who is the senior level over the other one. ... View more

But later I want to check whether the " orderdate1 " is empty, I did   data junk; orderdate1="4/30/2010"; number=1234; run; proc sql; select input(OrderDate1,mmddyy10.) into: OrderDate from junk; select case when OrderDate1 ne . then 1 else 0 end into: OrderDate_IND from junk; quit; %put Orderdate is:&orderdate; And I get error, 1 The SAS System 22:09 Friday, January 7, 2022 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 %LET _CLIENTTASKLABEL='write_two_line_JSON_File.sas'; 4 %LET _CLIENTPROCESSFLOWNAME='Standalone Not In Project'; 5 %LET _CLIENTPROJECTPATH=''; 6 %LET _CLIENTPROJECTPATHHOST=''; 7 %LET _CLIENTPROJECTNAME=''; 8 %LET _SASPROGRAMFILE='C:\Users\P1341095\Documents\00 MSF\write_two_line_JSON_File.sas'; 9 %LET _SASPROGRAMFILEHOST='NCS-5CG12517WL'; 10 11 ODS _ALL_ CLOSE; 12 OPTIONS DEV=PNG; 13 %macro HTML5AccessibleGraphSupported; 14 %if %_SAS_VERCOMP_FV(9,4,4, 0,0,0) >= 0 %then ACCESSIBLE_GRAPH; 15 %mend; 16 FILENAME EGSR TEMP; 17 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR 18 STYLE=HTMLBlue 19 NOGTITLE 20 NOGFOOTNOTE 21 GPATH=&sasworklocation SYMBOLGEN: Macro variable SASWORKLOCATION resolves to "/mnt/resource/SAS_work52C100005B5C_MSFCAV94/SAS_work19AF00005B5C_MSFCAV94/" 22 ENCODING=UTF8 23 options(rolap="on") 24 ; NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR 25 26 data junk; 27 orderdate1="4/30/2010"; 28 number=1234; 29 run; NOTE: Compression was disabled for data set WORK.JUNK because compression overhead would increase the size of the data set. NOTE: The data set WORK.JUNK has 1 observations and 2 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 30 31 proc sql; 32 select input(OrderDate1,mmddyy10.) into: OrderDate from junk; 33 select 34 case when OrderDate1 ne . then 1 35 else 0 end into: OrderDate_IND from junk; ERROR: Expression using not equals (^=) has components that are of different data types. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 36 quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds SYMBOLGEN: Macro variable ORDERDATE resolves to 18382 37 38 %put Orderdate is:&orderdate; 2 The SAS System 22:09 Friday, January 7, 2022 Orderdate is: 18382 39 40 %LET _CLIENTTASKLABEL=; 41 %LET _CLIENTPROCESSFLOWNAME=; 42 %LET _CLIENTPROJECTPATH=; 43 %LET _CLIENTPROJECTPATHHOST=; 44 %LET _CLIENTPROJECTNAME=; 45 %LET _SASPROGRAMFILE=; 46 %LET _SASPROGRAMFILEHOST=; 47 48 ;*';*";*/;quit;run; 49 ODS _ALL_ CLOSE; 50 51 52 QUIT; RUN; 53 How do I fix it? Thanks! ... View more

Sorry, the first line is filename j temp; ... View more

This is the full code     lename j temp; %let input_string ='{"OrderID1": "A0000123", "OrderDate1": "4/30/2010","OrderID2": "A0000124", "OrderDate2": ""}'; data _null_; file j; put &input_string; run; libname my_data json fileref=j; data my_output; set my_data.root (drop=ordinal:); run; /*After run above code the output will be*/ /************************************************/ /*OrderID1 OrderDate1 OrderID2 OrderDate2*/ /*A0000123 4/30/2010 A0000124 */ proc print data=my_output; run; proc sql; select compress("'"||%nrquote(OrderID1)||"'") into: OrderID from my_output; select OrderDate1 informat=yymmddd10. into: OrderDate from my_output; run; proc sql; create table member1 as select OrderID1 from output; quit; And the full log, 1 The SAS System 22:09 Friday, January 7, 2022 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 %LET _CLIENTTASKLABEL='write_two_line_JSON_File.sas'; 4 %LET _CLIENTPROCESSFLOWNAME='Standalone Not In Project'; 5 %LET _CLIENTPROJECTPATH=''; 6 %LET _CLIENTPROJECTPATHHOST=''; 7 %LET _CLIENTPROJECTNAME=''; 8 %LET _SASPROGRAMFILE='C:\Users\P1341095\Documents\00 MSF\write_two_line_JSON_File.sas'; 9 %LET _SASPROGRAMFILEHOST='NCS-5CG12517WL'; 10 11 ODS _ALL_ CLOSE; 12 OPTIONS DEV=PNG; 13 %macro HTML5AccessibleGraphSupported; 14 %if %_SAS_VERCOMP_FV(9,4,4, 0,0,0) >= 0 %then ACCESSIBLE_GRAPH; 15 %mend; 16 FILENAME EGSR TEMP; 17 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR 18 STYLE=HTMLBlue 19 NOGTITLE 20 NOGFOOTNOTE 21 GPATH=&sasworklocation SYMBOLGEN: Macro variable SASWORKLOCATION resolves to "/mnt/resource/SAS_work52C100005B5C_MSFCAV94/SAS_work19AF00005B5C_MSFCAV94/" 22 ENCODING=UTF8 23 options(rolap="on") 24 ; NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR 25 26 proc sql; 27 select compress("'"||%nrquote(OrderID1)||"'") into: OrderID from my_output; 27 ! 28 29 select OrderDate1 informat=yymmddd10. into: OrderDate from my_output; ERROR: Character expression requires a character format. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 30 run; NOTE: PROC SQL statements are executed immediately; The RUN statement has no effect. 31 32 %LET _CLIENTTASKLABEL=; 33 %LET _CLIENTPROCESSFLOWNAME=; 34 %LET _CLIENTPROJECTPATH=; 35 %LET _CLIENTPROJECTPATHHOST=; 36 %LET _CLIENTPROJECTNAME=; 37 %LET _SASPROGRAMFILE=; 38 %LET _SASPROGRAMFILEHOST=; 39 40 ;*';*";*/;quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 40 ! run; 41 ODS _ALL_ CLOSE; 42 43 44 QUIT; RUN; 45   ... View more

I think I found solution here   https://communities.sas.com/t5/SAS-Enterprise-Guide/Turning-off-goptions-in-SAS-EG-code-node/td-p/139509   Thanks 🙂 I solved ... View more

Thanks! ... View more