About nishSAS

nishSAS · ‎02-13-2019

Thanks Kurt for your reply. I wanted to edit the fill_number column where column value start with 1 it should become 0, if value is 2 it should become 1 and so on. When i am running below code my all fill_numver values are becoming 20. Which i don't want.

nishSAS · ‎02-13-2019

Hello, I am trying to create edit existing variable values with the help of DO LOOP in SAS Data Step. Below is the code i have written for the same. But when i am running this code I am not getting the expected result. What is going wrong in my code can you please suggest the corrections data IN; set IN; do x = 1 to 20;/*Update the Range if fill Number Value goes beyond 20*/ y = x - 1; if fill_Number = x then fill_Number = y; else fill_Number = x; end; run; Please correct me if my code is wrong. Thanks

nishSAS · ‎08-30-2018

yes right

nishSAS · ‎08-30-2018

sorry for confusion but you are right i want the value in WEDATE variable in MM/DD/YYYY format

nishSAS · ‎08-30-2018

@novinosrin the given solutions is correct but i required the WEDATE in "mm/dd/yyyy" format. So for that i am using numeric value.

nishSAS · ‎08-30-2018

I have a multi variable data set. From that data set I am creating new data set with some specific variables and one new Date variable at the end. The newly created Date Variable should contain week ending date. Below is the code i am writing to enter week ending date value, but when i open the data set the week ending date shows the "01/01/1960". Can someone guide me on this. data test; set existing (keep = list of variables i which WEDATE varibale is created); if missing(wedate) then wedate = "08/17/2018"; else if wedate = "08/17/2018"; run;

nishSAS · ‎08-17-2018

We are receiving data in "Received File layout" (Refer attachment). And we need to provide the data file for further process in "Shipment file" layout format (Refer Attachment). In the received file layout there are few attributes are common which are having different name in "Shipment file" those are "Product Code = ITEM_NUMBER", "Quantity Sold (units) = QUANTITY_SOLD" & "Quantiry Returned (units) = RTURN". So my main challenge is to create the variables which are not present in "Received File Layout" and merging the "Data Point" with "Field Name". Another challenge is in "Field Name = ID_TYPE" which ever data appears in "Attribute 6-9" out of that on priority basis if "Attribute 6" contains any data then that data should come under field name "ELIGIBLE_CUSTOMER_D_N_OR_H_OR_NC" and the attribute name should come under field name "ID_TYPE" and so on. Numbers mentioned under "Availability" column denotes the priority of the attributes should come under "ID_TYPE" & "ELIGIBLE_CUSTOMER_D_N_OR_H_OR_NC" "Layout" file contains sample data for your reference.

nishSAS · ‎08-16-2018

Hello, I need to creat a data set with two different layout data with different data lables. Can somebody help me out how can i get this done by Proc SQL. In attached file there is a data layout for two different data sets. I want the final data set in "Shipment file" layout form. And the file which i am receiving is in "Received File Layout" layout. With the help of this can somebody help me to solve my problem. Thanks, nishSAS

nishSAS · ‎08-09-2018

Thanks Vince, I am using SAS9.4 version on 32bit OS In your attached file i did not find three tables. there are only two tables showing which i provided.

nishSAS · ‎08-08-2018

Yes my data is in excel format and whatever data i have provided in the example file is as it is what i have

nishSAS · ‎08-08-2018

Hello Everyone, Kindly help me to import the tabular type report into SAS data set. Once that report gets import into SAS then i want to transpose that data set with regular data form. I have attached excel file for your reference as i have "Table 1" data which i want to convert into "Table 2" form in SAS. Hope this description helps you to understand my issue. Thanks, Nishant Paranjpe

nishSAS · ‎08-03-2018

Thanks ChrisNZ, But I have used proc Report and i got what i was expecting. Below is the syntax for review proc report data = tab; column NDC Date, QTY; define NDC / display Group; define Date / order order=internal; define QTY / sum; define Date / across; run; Thanks again. Looking forward for more assistance in future 🙂

nishSAS · ‎08-02-2018

Hello Sir/Madam, My data set having three variable two variables are numeric and third is date variable which is in MONYY. format. I wanted to write a code for Proc freq data = ; format Date MONYY.; tables (NUM QTY) * Date/NOCUM NOFREQ nocol norow; run; When i am running this code output is generating but that output is giving me frequency and i wanted actual volume for each NUM variable against Date. Could you please correct my code or any additional step i wanted to add in it. THanks, Nishant

Online Status	Offline
Date Last Visited	‎02-13-2019 09:27 AM

Re: DO Loop

DO Loop

Re: Want to enter date value in the created date variable

Re: Want to enter date value in the created date variable

Re: Want to enter date value in the created date variable

Want to enter date value in the created date variable

Re: Preparing Data Set with Two Diff layout

Preparing Data Set with Two Diff layout

Re: Need to import tabular type report in SAS

Re: Need to import tabular type report in SAS

Re: Preparing Data Set with Two Diff layout

Re: DO Loop

DO Loop

Re: Want to enter date value in the created date variable

Re: Want to enter date value in the created date variable

Re: Want to enter date value in the created date variable

Want to enter date value in the created date variable

Re: Preparing Data Set with Two Diff layout

Preparing Data Set with Two Diff layout

Re: Need to import tabular type report in SAS

Re: Need to import tabular type report in SAS

Need to import tabular type report in SAS

Re: Wanted Crosstab between three variables

Wanted Crosstab between three variables