Home

vijnad

Hi, I am trying to disable procedure title 'The SG Render Procedure' by using ODS NO PROCTITLE ; while generating .svg graph, this is not working, not sure where this is going wrong. can you please help. Thanks! Here is the output image and code: ods _all_ close; ods NOPROCTITLE ; ods html gpath="&figout" style=groupstyle image_dpi=300 ; filename image1 "&figout/%sysfunc(tranwrd(&tlfname,-,_)).svg" ; ods graphics on/ reset = index imagename="%sysfunc(tranwrd(&tlfname,-,_))" imagefmt=svg ; proc sgrender data=final template=swimmer; dynamic bartype="&bartype"; run; ods html close;

lichee

Hi all, I'm trying to use PROC HPGENSELECT with METHOD=LASSO to select covariates. I have about 370,000 observations. When I tested the code with only 8 covariates, it finished running in less than twenty minutes. When I included over 300 binary covariates (&add300cov.), it ran overnight but still did not finish. Can anyone see anything to modify in the my code below? Thanks a lot! proc hpgenselect data=population; class female(ref='0') race_ethncty(ref='1') &add300cov_ref.; model success(event="1") = age female race_ethncty var4 var5 var6 var7 var8 &add300cov./ dist=binary include=(age female race_ethncty var4 var5 var6 var7 var8); selection method=lasso; run;

VA1

Hello everyone, I am looking for some help on how to hyperlink between excel sheet 1 cell data to excel sheet 2 cell data – both excel sheets can have values in random cells (of column A & D), I want to Match the values & hyperlink between those matched cells. Ex: as given below, this data can vary from report to report so I want to keep this match & link dynamic. Can this be achieved with sas code? Right now I am just able to hyperlink to certain cell in Sheet 2 in proc report, not by values. compute r_id; urlstring= "#'"||strip('Rules')||"'!A2"; call define(_col_,'URL',urlstring); call define(_col_,'style','style={textdecoration=underline color=blue}'); endcomp;

Sharonking10

Why do I always get series of errors while running a SAS Program a second time. For instance, if I run a program containing datasets for the first time, it successfully opens up all the tables. If I lost connection to server and come back after re-connecting or probably the next time, I will get series of errors. E.g library is not assigned. Dataset not found. Table doesn’t exist A long lists of errors.

Robin_moon

I saw a loop code the other day. And it generate files of output_&i (i.e. output_1, output_2,..., output_n). At the end, it row bind all the files as: data all_results; set output_:; run; It seems that we could list files output_1, output_2, ... , output_n in a simple way by using ":" as output_:, so I tried to row bind my files that all end up with "_output" (i.e. 1_output, 2_output, 3_output) in a similar way: data all_results; set :_output; run; But it failed. I'd like to know how to write the code in the right way. Thanks!