About VDD

VDD · ‎10-19-2019

@valarievil you can use SampleID you just have to have it in the SAS dataset. So your first error in the process was at your proc means because the incoming dataset did not have SampleID in it.

VDD · ‎10-19-2019

because you proc means fails. this by SampleID; you have to have the by variable in the dataset being evaluated.

VDD · ‎10-19-2019

try it by removing the semicolon from this else; to this else we dont use semicolons after the else only at the end of the else statement

VDD · ‎10-18-2019

because &CR macro is called outside of data step and is global.

VDD · ‎10-18-2019

One big issue I run into is when I don't have modify or update permission to the files I can create on shared networks/servers. SAS creates a temp file than it renames the file after the process completes, and if you don't have modify permissions you can not even delete the locked version of the file. While it seems that the file would be in your temp or work folder when it is being created the file may be getting created across the network.

VDD · ‎10-18-2019

this simple question (road block) @Devindra is what we all have to deal with. It is part of the requirements and development process that takes somewhere around 90-95% of our time before we start coding. You did not explain what you fully needed with all of the details about the time series nor the comparing of data results over time. please be as specific as possible in your needs, so that those replying have the details they need to understand the problem you are facing.

VDD · ‎10-18-2019

create either a table, an array or something that can be IDed for the lookup and loop through your importing process.

VDD · ‎10-18-2019

you might need to have the DB2 client installed on your work-station

VDD · ‎10-18-2019

basic way to read a text file is filename text "\\&path.\&file."; data read_text; infile text; *dlm="09"x; input var1 var2 var3; run;

VDD · ‎10-16-2019

@muskagap you have a comma rather than a dot. try this data xyz.Capit; amount = 5000; i=1; do while (i <= 5); i + 1; option1 = amount*(1.04/1); end; run;

VDD · ‎10-16-2019

https://stats.idre.ucla.edu/sas/modules/how-to-reshape-data-long-to-wide-using-proc-transpose/

VDD · ‎10-11-2019

@DivyaGadde you need to have a variable in both datasets that share something in common like an ID, date or something.

VDD · ‎10-10-2019

have you tried the week function? https://support.sas.com/documentation/cdl/en/lefunctionsref/63354/HTML/default/viewer.htm#n1ka2ulrvrjlasn0z7beco2yrgas.htm you should be-able to at least create a new variable containing the week value and do the forecasting.

VDD · ‎10-08-2019

@abdulla you could get your answers by trying to look at examples that meet your needs on the community. If you have work to do then why not learn how to do the work rather than commanding other to give you code for your needed results. I don't believe anyone here earns wages for assisting you in obtaining results so that you can learn besides SAS employees.

VDD · ‎10-07-2019

@wernie more information is needed... do we reject age_group 4--10? do you have sample data for geo_id 1 where the age_group is in 1, 2 or 3 that support the results for that sample Pop value that you have of 5004? Please provide sample data that match's your expected results and include all data columns that are relevant to the determination.

Re: Holidays

Re: Holidays

Holidays

Re: valid varnames

valid varnames

SAS on Demand

Re: if you have NA in all character variables then you should delete ...

Re: available options to create dummy ID??

Re: Issue using MOD incorrectly and holding data records for correct d...

Re: Need assistance with SAS array’s summing within the by group only

Re: How to run different groups of data steps based on distinct criter...

Re: Lopping for categorize the variable

Re: mixing up data

Re: Append a string to a macro variable for name of output data set.

Re: How to take hour and minutes of the current time into macro variab...

Re: Reading multiple .sas7bdat files from folder and select only requi...

Re: Reading multiple .sas7bdat files from folder and select only requi...

Re: Filepath not found?

Re: How to speed up a program ?

Re: Difference between NODUPKEY and NODUPRECS?

Re: Probability that the sample means are between 2 and 3? uniform dis...

Re: Probability that the sample means are between 2 and 3? uniform dis...

Re: Map data with Proc gmap

Re: Macro variable resolved but says variable not initialiesd in next ...

Re: Error Message out of no where!

Re: How to import unique SAS files from a directory?

Re: How to import unique SAS files from a directory?

Re: connect to DB2 database error

Re: Use of PROC CONTENTS for Quality Control

Re: How to do math in a loop body?

Re: How to change many columns to two columns

Re: Merging Datasets with unequal observations and no common variable

Re: Forecasting by Weeks

Re: Convert date format yymmddn8 and informat yymmdd6 to format Best12...

Re: How to sum values in a column and recode the values?