I have to read a csv file and produce sas dataset When I am trying to read it ,single quote is behaving similar to double quote and all the data in other fields  after single quote is read as one value. How can I fix it? Please dont ask me why data in a field  has only single quote. It is some encrypted field. I cannot alter source data in any way   Sample code and data: data test; infile inf delimiter = '|' missover dsd lrecl=32767 firstobs=2; followed by informat format and input statements ;   Input csv file has data like this |'|2023-12-12|30|40||||||DENG| Now output dataset is taking all the above values in single field "crys_id_local" instead of multiple fields. sample output crys_id_local ============ |2023-12-12|30|40||||||DENG|       ... View more

I am working on a large data  where I am creating 150+ columns using case statements in proc sql create table with multiple join conditions. One of the columns which I am creating using case statement is not getting created properly. Values in this column which I am getting from source are getting truncated even post applying enough format and length.I am left joining main table with the same ref table multiple times but with different joining conditions.I am providing an example for more understanding.It is not the actual code I am using. Why are the values in the new column truncated?   Example : Proc sql; create table out as case when source.col1 is not null then ref.class           when source.col2 is not null then ref1.class end as category format $100 length = 100 from source left join table_ref ref on source.col3=ref.col3 left join table_ref ref1 on source.col4=ref.col4 ; quit;     ... View more

I am working on a large data  where I am creating 150+ columns using case statements in proc sql create table with multiple join conditions When I try to run the code and create output it is giving me error for few tables where the record count is around 20 millions in source table .It is running fine for other tables where record count is less in source tables. I am not creating any sas view. I am creating tables in hive using proc sql sas code. I have done some research over the net about this error and my code is not falling into any categories where this error can occur as per sas support portal Can someone pls help resolve this.Below is the error   ERROR:  An exception has been encountered. Please contact technical support and provide them with the following traceback information: The SAS task name is [SQL     ] Segmentation Violation Traceback of the Exception: /home/sas/sas94m6/SASFoundation/9.4/sasexe/sas(+0x16844e) [0x7f68ffaf444e] /home/sas/sas94m6/SASFoundation/9.4/sasexe/sas(+0x4ee1f) [0x7f68ff9dae1f] /home/sas/sas94m6/SASFoundation/9.4/sasexe/tkmk.so(bkt_signal_handler+0x144) [0x7f68fddcdac4] /lib64/libpthread.so.0(+0x3d36c0f790) [0x7f68ff33e790] /home/sas/sas94m6/SASFoundation/9.4/sasexe/sassqlu(+0x23eff) [0x7f68c6175eff] /home/sas/sas94m6/SASFoundation/9.4/sasexe/sassqlu(+0x22ac3) [0x7f68c6174ac3] /home/sas/sas94m6/SASFoundation/9.4/sasexe/sassqlu(+0x2f9d8) [0x7f68c61819d8] /home/sas/sas94m6/SASFoundation/9.4/sasexe/sassqlu(+0x391a1) [0x7f68c618b1a1] /home/sas/sas94m6/SASFoundation/9.4/sasexe/sassqlu(sqltxt2+0x51e) [0x7f68c616711e] /home/sas/sas94m6/SASFoundation/9.4/sasexe/sassqlp(+0x5089d) [0x7f68c640d89d] /home/sas/sas94m6/SASFoundation/9.4/sasexe/sassqlp(sqlpsel+0xfb6) [0x7f68c640c5f6] /home/sas/sas94m6/SASFoundation/9.4/sasexe/sassqlp(sqlplan+0x219) [0x7f68c63f8de9] /home/sas/sas94m6/SASFoundation/9.4/sasexe/sassqlp(sqlprep+0x3ee) [0x7f68c642a89e] /home/sas/sas94m6/SASFoundation/9.4/sasexe/sassqx(+0x3be91) [0x7f68c6dc4e91] /home/sas/sas94m6/SASFoundation/9.4/sasexe/sassqx(sqlloop+0x417) [0x7f68c6dc4617] /home/sas/sas94m6/SASFoundation/9.4/sasexe/sassql(sassql+0x362) [0x7f68c7416402] /home/sas/sas94m6/SASFoundation/9.4/sasexe/sas(vvtentr+0x18a) [0x7f68ff9da97a] /lib64/libpthread.so.0(+0x3d36c07a51) [0x7f68ff336a51] /lib64/libc.so.6(clone+0x6d) [0x7f68fe9c496d]   ... View more

Can someone please explain difference between bquote and str in sas with a working example.I am aware of theoretical difference between them. But ,I want to understand with example which shows why str can't be used in place of bquote ... View more

data two; input name $ qtr amount; datalines; adam 1 10 adam 2 20 adam 3 30 adam 4 40 ; run;     Need a code to produce below output using array and not proc transpose output must be : name qtr1 qtr2 qtr3 qtr4 adam 10    20   30    40 ... View more

Hi ,   I am creating a csv file from sas dataset using ds2csv utility. I want the column names of this csv file to be lower case. I have given a sample code as well Can someone please help me with this data temp; input NAME $ AGE; datalines; ram 21 ravi 34 ; run; %ds2csv(data=temp,labels=N,runmode=b,csvfile=/out/temp.csv) ... View more

%let out=/sas/output/file_name.csv; filename dest hadoop "&out"; %ds2csv(data=input_table,labels=N,runmode=b,csvfile=out);   I have to create a csv file from dataset by only using ds2csv log shows csv successfully generated but I am not able to find it in specified hadoop destination folder. macro variable out is getting resolved correctly   should i not give csvfile=libref in ds2csv utility. What is the issue?  ... View more