About arodriguez

arodriguez · ‎07-04-2016

Hi, The gap could be increased with columgutter. If you don't want to increase this gap to avoid lose space. Also you could try to add the option TICKVALUEFITPOLICY= ROTATEALWAYS to try to force to rotate. I think that only can be used in versions 9.4.

arodriguez · ‎07-04-2016

You could edit your dataset to delete n content when timepoint is not in your list.

arodriguez · ‎07-04-2016

If they start with the same sequence of characters you could say something like _US_:. If they are all together in the dataset you could say "all variables between X and Y" with X--Y.

arodriguez · ‎07-01-2016

You have two infile statements. I think that only the fist should be used

arodriguez · ‎07-01-2016

Hi, When you execute a proc import in the log is generated a data step that create your table. If all the tables have the same structure you could copy your data step and force certain formats changing the format and informat statement. In the log must appear something like data WORK.MYDATA ; %let _EFIERR_ = 0; infile 'C:\My Documents\myfiles\delimiter.txt' delimiter = '&' MISSOVER DSD lrecl=32767 firstobs=2 ; informat Region $8. ; informat State $2. ; informat Month MONYY7. ; informat Expenses best32. ; informat Revenue best32. ; format Region $8. ; format State $2. ; format Month MONYY7. ; format Expenses best12. ; format Revenue best12. ; input Region $ State $ Month Expenses Revenue ; if _ERROR_ then call symputx('_EFIERR_',1); run;

arodriguez · ‎06-29-2016

Hi, I have spoke with support and seems to be an error with SAS 9.4. TS1M3, the same importation in M2 don't give any error. They say that may be solved on next version.

arodriguez · ‎06-29-2016

Ok, thanks for the information. I will create a issue in SAS support and try to upgrade to data step the imports that give problems in SAS 9.4 and not in 9.3

arodriguez · ‎06-28-2016

Hi everyone, I'm testing some programs that we have to check if we can upgrade sas without many troubles. In a check that I was doing I notice that SAS 9.4 import different that SAS 9.3 with proc import. I have attatched the file (notice that it's in txt because communitie don't allow csv). The code that I use to import in that case is proc import datafile="XXXXXXX\example.csv" out=example dbms=csv replace; getnames=yes; run; In fact, with SAS 9.4 I get an error because sas try to put a date format into the data _NULL_. Anyone know how to solve it without change importation to data _NULL_? Thanks!

arodriguez · ‎06-16-2016

Hi kimdukes77, You could specify multiple table names in the DATA statement, for example DATA table1 table2; set table; if _N_<=80 then output table1; else if _N_<=160 then output table2; run; If you know the number of observations you could create a step like the previous one. If the number of observations is going to be dynamic, counting the number of rows and apply ceil(nobs/80) can give you the number of data sets that you need

arodriguez · ‎06-16-2016

Hi subtrat1, If your data always have all quarters, the easiest way to do it is sorting your data and then using the order on that data. proc sort data=Have; by year Quarter; run; Then you could create a sequence and multiply by 3 data want; set have; by year quarter; retain count 0; if first.quarter then count=count+1; Quarter_ID=count*3; drop count; run; If you don't have all quarters, I guess that the easiest way to do it is comparing from your origen data want; set have; retain first_Year first_quarter; if _N_=1 then do; first_YEAR=Year; first_quarter=quarter; end; Quarter_ID=(Year-first_Year)*12+Quarter*3; run;

arodriguez · ‎06-16-2016

Hi mhamlett, Have you tried to use the intck function? data test; days=intck('day','10jan16'd,'01jul16'd); put days; run; With this function you can specify days, months, weeks... Using this function should be easy identify the dates comparing with actual day. I usually take the actual day with %let today = %qsysfunc(date(),yymmdd10.);

arodriguez · ‎06-15-2016

You have different alternative that work fine data one; input AESER $ @2 AESDTH $ @4 AESLIFE $ @6 AESHOSP $ @8 AESCONG $ @10 AESDISAB $ @12 AESMIE $ @14 INFECDIS $; datalines; N N N N N N N N Y N N N N N N N Y Y N N N N Y N Y Y Y N N N N N ; run; data one; input AESER $ AESDTH $ AESLIFE $ AESHOSP $ AESCONG $ AESDISAB $ AESMIE $ INFECDIS $; datalines; N N N N N N N N Y N N N N N N N Y Y N N N N Y N Y Y Y N N N N N ; run; You don't need the +1 that mean skip it a column.

arodriguez · ‎06-10-2016

Hi Saranya, Your problem could be solved with a proper sorting and using first. statment. The first think that you need to do is sort data proc sort data=have; by EMPID EFFDT EFFSEQ; run; After that, you data will be sorted. Now you are able to use the statement FIRST. in a data step, that identificate the first element in a group. In that case you want to identify first EFFDT. Depending on if it is the first EFFDT or not, you must operate. You could do something like data Want; Set have; By EMPID EFFDT EFFSEQ; retain count; if first.EFFDT and EFFSEQ=5 then EFFSEQ=count; else if first.EFFDT and EFFSEQ ne 5 then count=0; else if not first.EFFDT then count=count+1; run; This is going to generate the variable that you need.

arodriguez · ‎06-08-2016

Hi everyone, In a macro I concatenate multiple levels. Seems that one of thats levels have a "%", as a separator i use "#" character and I get differents outputs depending on if I put or not " ". Here an example %let var=Test; %let array=%; %put &array.#&var.; %#Test#Test %put &array.# &var.; %# Test %put &array. #&var.; % #Test #Test Someone know Why this odd performance? It seems a strange performance that is not presented when there is not the "%" Thanks

arodriguez · ‎05-27-2016

Hi, I'm not sure, but I think that is the exponential of the estimate. You could calculate it exporting the estimations or with the option expb in the model. ods output ParameterEstimates=_PEst; proc logistic data=sashelp.class; class sex; model sex(ref="F") = Age Weight Height / expb ; run;

Online Status	Offline
Date Last Visited	‎04-09-2018 08:55 AM

Re: Can I report a private message as spam?

Can I report a private message as spam?

Open excel with SAS in Read only mode

Re: sorting of alpha_numeric like contents of book

Re: DATA STEP

Re: Proc Report ordering

Re: How to define a dynamical path for FILE command

Re: Compare statement

Re: Adding Background Color to Graph

Re: Adding Background Color to Graph

Re: Open excel with SAS in Read only mode

Re: default values for DYNAMIC variables?

Re: default values for DYNAMIC variables?

Re: Open excel with SAS in Read only mode

Re: sorting of alpha_numeric like contents of book

Re: reading a csv file starting from 4th row using proc import

Re: anybody helps to explain what %let means here and the scan functio...

Re: proc import problem with column length

Re: Filtering columns

Re: PROC SGPLOT

Re: How could I change the X axis tickvalues direction in Layout LATTI...

Re: PROC SGPLOT

Re: Filtering columns

Re: Text File Import force the correct Informat and format

Re: Text File Import force the correct Informat and format

Re: proc Import: SAS 9.3 vs. SAS 9.4

Re: proc Import: SAS 9.3 vs. SAS 9.4

proc Import: SAS 9.3 vs. SAS 9.4

Re: Output groups of observations to multiple datasets

Re: Creating a sequence

Re: derived types for measures for diff in yesterdays sales - 2 days a...

Re: Reading dataset using input - incorrect results

Re: Increment by 1

Someone know why SAS do that?

Re: Oddratio statement in in PROC logistic