About amyk

amyk · ‎01-02-2020

Thats the thing is that i have over 1200 variables to loop through and set the zero. However I am trying to find away instead of hard coding all the variables

amyk · ‎01-02-2020

Hi Ed Thanks for the quick response. After Transposing the variables don't have the same prefix. Below is what I had started to do. the code blow intention was to have an array to contain all the variables and set them a value of zero the variables that don;t have a value. data CheckboxFinal ; set CheckBoxCount ; array varlist{*} TotalCheckBox; do i = 1 to dim(varlist) ; if varlist{i} = . then varlist{i} = 0 ; end ; drop _NAME_ i ; run ;

amyk · ‎01-02-2020

Hi, I am having a bit of an issue trying to figure out how can I set a zero value to the data after transposing. After I transposed the data I have over 1200 variables that blank and I want to set them as zero with out having to write out all variables. I attempted using an array however that failed on me. Please Help Me!!!

amyk · ‎02-27-2019

Create Table OptionSet as select a, b, c if a.V_W = "" or C.V_AWZ = "Y" then a.V_W = b.V_W end; if a.V_X = "" or C.V_BWZ = "Y" then a.V_X = b.V_X end; if a.V_Y = "" or C.V_CWZ = "Y" then a.V_Y = b.V_Y end; if a.V_Z = "" or C.V_DWZ = "Y" then a.V_Z = b.V_Z end; quit.

amyk · ‎02-27-2019

That is the thing I don't know where to start to join things together. I will try to mock up something that maybe helps better to explain what I am trying to do. say in database1 if have V_W = "Hello" and if File1 has Var1 = "PPO" then in database2 where Var1=PPO update database1 with value in database2. I am struggling with how would I do that.

amyk · ‎02-27-2019

Hi All, I hope you can help me. I am trying to create a database depending on varies criteria and I am trying to find a way to pull it all together. I have, say database1 with values and depending on if a variable received from another source (File1) exists then use values from databases2 that have the variable if exists from File1 . I have identified if the variable exists and now I am trying to set that value from database2 to replace value from database1.

amyk · ‎01-11-2019

thank you that was very help ful!!!!!!!!!!!!!!!!!

amyk · ‎01-11-2019

I would like to assign the iteration based on the date range from the start date to the end date to a database that has all Dec dates. Iteration, Start_Date, End_Dates 1, 1-Dec-18, 7-Dec-18 2, 8-Dec-18, 14-Dec-18 3, 15-Dec-18, 22-Dec-18 4, 23-Dec-18, 31-Dec-18 So when I join the tables together all the Dec dates are assigned with all the iterations.

amyk · ‎01-11-2019

I am trying to assign a value to a database from a database that has dates and based on the dates are assigned an iteration. I want to assign the iteration to another database with the dates within that range and I keep getting one too many records. so I have original 104 records after I assign the iteration I end up with 416 records with all the iterations assigned to them. Is there a way to assign based on the range of dates without getting a one to many. If so can you give me an example of how?

amyk · ‎12-10-2018

Thanks that helped. I ended up using it as follows: build_mn le intnx('month', build_mn, -4, 'e') It gave me exactly what I was looking for. Again thank you so much!! 🙂

amyk · ‎12-10-2018

I want to set a flag if the build month is 4 months less then the sold month then set flags.

amyk · ‎12-10-2018

I am trying to set a filter using dates: if build_mn < sold_mn - 3 then do ; ... ... end ; It is grabbing all the records and not filtering. I think I am using the sold_mn - 3 wrong. Can someone help me with this?

amyk · ‎12-06-2018

I am importing multiple files in a database and I received a file with only headers and zero records. How can I bypass the file if it is empty?

amyk · ‎11-16-2018

sorry but I am trying to understand what you mean by writing my own data step, Do you mean for me to use infile statement instead because I was trying to avoid that because I will be using the process multiple times and I wanted to make it somewhat static.

amyk · ‎11-16-2018

I have multiple CSV files I am importing, however, a few variables have different data types and I am trying to set them the same way. I am having a difficult time in how to change the formats using a proc import so I don't have redundant input logic for each file which has different file names. Can someone help with what would be the best way?

Online Status	Offline
Date Last Visited	‎05-26-2021 06:07 PM

Re: How to set value of 0 after transposing

Re: How to set value of 0 after transposing

How to set value of 0 after transposing

Re: Assigning value depending on varies filters from a different sourc...

Re: Assigning value depending on varies filters from a different sourc...

Assigning value depending on varies filters from a different sources

Re: Assigning based on range however I am getting one to many records

Re: Assigning based on range however I am getting one to many records

Assigning based on range however I am getting one to many records

Re: setting filters using dates

Re: setting filters using dates

Re: How to set value of 0 after transposing

Re: How to set value of 0 after transposing

How to set value of 0 after transposing

Re: Assigning value depending on varies filters from a different sourc...

Re: Assigning value depending on varies filters from a different sourc...

Assigning value depending on varies filters from a different sources

Re: Assigning based on range however I am getting one to many records

Re: Assigning based on range however I am getting one to many records

Assigning based on range however I am getting one to many records

Re: setting filters using dates

Re: setting filters using dates

setting filters using dates

Bypass an empty file when Importing multiple files into a dataset

Re: Importing CSV file with different format of data type

Importing CSV file with different format of data type