There is no output dataset because there is no "create table". Only results are available. It is necessary that learning basic sql syntax before using proc sql.   ... View more

Look up the document and read it. https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/sqlproc/n1tupenuhmu1j0n19d3curl9igt4.htm   ... View more

Again, if your question has been answered, please mark the answer as "Accepted Solution" for the benefit of later viewers.   Please review the following guidelines. https://communities.sas.com/t5/Getting-Started/Community-etiquette-The-do-s-and-don-ts-of-the-SAS-Support/ta-p/224384     ... View more

The out= is not required for the output statement in the data step. output test; ... View more

Are you sure you are not using the label display? Try switching to variable name display by doing the following.   Or try using proc contents to display a list of variable names. ... View more

Why don't you just submit it before googling it anyway? Since it is described in the length statement, it is a space-separated declaration of a variable, or variables and lengths.   code: data a; length region $10. segment $40. long_run real_bad c cv_95 cv_99 8. cv_accuracy $6.; run; proc contents;run; results:   ... View more

17 is including decimal and anything after. ... View more

if first.product then do; cum_active=0; cum_default=0; end; This is Initializing variables to be used for the sum statement.   cum_active+active; cum_default+Default; Thereafter, the total is calculated.   For more information on the sum statement,  https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/lestmtsref/n1dfiqj146yi2cn1maeju9wo7ijs.htm   First data step variables are described here https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/lrcon/n01a08zkzy5igbn173zjz82zsi1s.htm   Also, I have a few requests. Please do not post the text mixed in with the code block as it makes it difficult to see. Also, if necessary, please make questions that you have already posted resolved.   ... View more

If it's the same drug on the same day, would you leave it? I don't know if this two ways are correct since the results you want are not shown, but you can try.     /* one step */ proc sql; create table want1 as select a.* from have as a left join have as b on a.id=b.id and a.converted_date=b.converted_date and a.drug_name^=b.drug_name where b.drug_name='' ; quit; /* two steps: sort and sql */ proc sort data=have out=dup UNIQUEOUT=uniq NOUNIQUEKEY; by id converted_date; run; proc sql; create table want2 as select * from uniq union all select a.* from dup as a left join dup as b on a.id=b.id and a.converted_date=b.converted_date and a.drug_name^=b.drug_name where b.drug_name='' ; quit;         ... View more

One way would be to treat the xlsx file as a zip archive and get the value of the dimension ref element in book\xl\worksheets\sheet1.xml. ... View more

If it is sure of 4 digits, I think you can use the substr function to get the second and subsequent characters.   filename txt temp; data _null_; file txt; put '1234'; put '5678'; put '9012'; run; data want; infile txt dsd; length num 8 lastdgt $3; input num; lastdgt=substr(strip(put(num,best.)),2); run; ... View more

you can use compress option. - compress= dataset option https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/ledsoptsref/n014hy7167t2asn1j7qo99qv16wa.htm   - compress= system option https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/lesysoptsref/n0uhpz2l79vy0qn12x3ifcvjzsyt.htm   options compress=yes;/* this apply all datasets */ data test; set sashelp.class(compress=yes);/* this apply this dataset only */ run;   ... View more