About mrdlau

mrdlau · ‎04-26-2019

Thanks! I think this worked perfectly..... Can you explain what 'cm' is? The code worked perfectly but i still want to know what cm is? I'm a bit new to SAS

mrdlau · ‎04-26-2019

suppose I have 5 columns in my output: c1 c2 c3 c4 c5 1 2 3 4 5 how do I output my result so that it displays a cumulative sum from left to right c1 c2 c3 c4 c5 1 3 6 10 15 In this example, I have c1-c5, but in reality, that may not be the case. i may be c1-c50, or c1-c60

mrdlau · ‎06-17-2018

I'm generating a simple vbar chart with the Y axis being counts, and x axis being ranges that I created as text (i.e "0 to 5%", "5.01 to 10%" etc). When I plot the chart, my X axis is out of order. it'll go "0 to 5%", "10 to 15%", "5 to 10%". How do I set the order in this scenario where the x axis is text? Proc sgplot data=gridwork.data; vbar dist/ response=counts; xaxis label=distribution; yaxis label='counts; run; quit;

mrdlau · ‎06-15-2018

I'm on 7.1

mrdlau · ‎06-15-2018

I can move the file to the citrix location............. how do I use the built in file transfer task?

mrdlau · ‎06-11-2018

I'm using SAS EG on a VM through citrix and I want to "move an excel file to the server." how do I do that exactly? I want to manipulate it using proc import, but it wont read the file because of the location.

mrdlau · ‎06-11-2018

thanks when I do this, I get a 'physical file not found'. does the path need to be in a specific format? I read that if I'm running SAS on a virtual machine, it has to be done differently?

mrdlau · ‎06-11-2018

I'm trying to do a natural join but it seems that the tables aren't joining as I want. proc sql; select (case WHEN t1.condition = 'YES', THEN input(t2.number, 8.2) else 0 end ) as column1 FROM t1 NATURAL LEFT OUTER JOIN t2 t2; quit; both my t1 and t2 tables have a 'condition' column with the same data type, so I expected them to pair together. however, when I run both tables side by side, t2.column is all empty as if it is not joining.

mrdlau · ‎05-22-2018

In my workspace, i have a shortcut to an excel workbook with multiple sheets. If i right click > import, im able to export my worksheets out. However, if i ever need to change workbooks that ends up having a different number of columns, i need to ‘modify import’ in order to make sure all the appropriate columns are accounted for. Im working with many different sheets that may or may not have differring columns. Is there a way to run the process flow where it will always just re-import?

mrdlau · ‎05-18-2018

Hi. I’m actually using EG

mrdlau · ‎05-18-2018

In SAS EG, I know you can right click and change the background color of the main interface (the view with the grid lines). In the SAS program where you write code, You can go to tools > options > appearance (or something to that effect) and you can pick various items and change colors (i.e, change color of comments, colors of certain syntax etc, font type etc). However, can I change the background color of the SAS program? I haven't found a way to do that yet?

mrdlau · ‎05-15-2018

Thank you. Im' still new to SAS and macros, and still need help understanding. Would appreciate some assistance if possible. Here's an example full code that I have. proc sql; select * from work.table1 t1 left join work.table2 t2 on t1.ID = t2.ID and t1.name = t2.name; quit; In my tables, t2 does not have a 'name' column, so running the query like this, it'll error out. I want my query to be able to ignore the name joins so it'll run as if there wasn't a name join I understand the first part of you code where it's filtering the dictionary columns to the 'Name' column. However, I dont understand the rest of it. proc sql; select * from dictionary.columns where LIBNAME = 'WORK' AND memname = 'TABLE2' AND name = 'Name'; quit; is &sqlobs a predefined macro? and is this already referencing the above script? I'm actually still very new to sas and macros, so I'm still unsure how to apply what you gave me to my code above. my extent to macros at the moment is %let = variable, and then referencing it throughout the code

mrdlau · ‎05-14-2018

These tables would still need to be joined by ID, so I would just want the ‘name’ join to be ignored, since that table doesn’t have a name column.

mrdlau · ‎05-14-2018

I have to upload various tables(xlsx files) and join them together via a query. I,e upload table A1, and join it with A2, A3.....etc. Can I make it such that my query is dynamic enough to ignore join statements if my table does not have certain columns. For example, uploading table A1, A2, A3, I might join them with primary Key "ID" and 'name'. However, if I upload table B1, B2, B3, it might not have Primary Key "name." So I want to have a query that has all the join staements for name and ID, but be able to ignore the 'name' join if these columns aren't available.

mrdlau · ‎05-07-2018

thank you so much! I ran this in SAS studio and it gave me what I needed. Can you clarify what these syntax are doing? %let L=%sysfunc(catt(%sysfunc(int(%eval(&k./100))),dot, %eval(&k.-%sysfunc(int(%eval(&k./100)*100))))); there seems to be a lot going and I dont understand the negative sign, division etc. Also, why are my tabe name "1dot0" "1dot25" etc?

Online Status	Offline
Date Last Visited	‎04-26-2019 08:33 PM

Re: Display cumulative sum from one column to the next.

Display cumulative sum from one column to the next.

proc SGplot. X axis out of order.

Re: moving a file from local to server

Re: moving a file from local to server

moving a file from local to server

Re: How to easily import when excel workbook changes

help with a natural join

How to easily import when excel workbook changes

Re: Is it possible to change the background color in the SAS program?

help with a natural join

confused about input/put, format/informat

PROC sql: how to join to nearest year

Re: Display cumulative sum from one column to the next.

Display cumulative sum from one column to the next.

proc SGplot. X axis out of order.

Re: moving a file from local to server

Re: moving a file from local to server

moving a file from local to server

Re: How to easily import when excel workbook changes

help with a natural join

How to easily import when excel workbook changes

Re: Is it possible to change the background color in the SAS program?

Is it possible to change the background color in the SAS program?

Re: can I make my query dynamically ignore join codes?

Re: can I make my query dynamically ignore join codes?

can I make my query dynamically ignore join codes?

Re: how to do an iterative loop in proc sql;