Hi All, I want to create a dummy data set in that data set I want coloumn names as number, date(20042020 this format) and performance. I want rows in performance initially populate as 0. example: Number  Date           Performance 1A            30042020  0 2B             31032015  0 After that there is another dataset which is already created in which there is Number coloumn, Date coloumn and  Performace coloumn are already there Example: Number Date            Performace 1A           30042020    5.254 1A           31032020    7.458 2B           31032015    7.569 2A           30042015    9.546 In already created dataset the date coloumn have 200 rows but with identical number rows. so I have to distinct only 100 rows to handle the duplicate rows and there should be 61 rows in my dummy dataset which I have to create starting from 31 march 2015 to 30 april 2020 last date of every month and there is 61 month only from today. I want to match  both datasets number and date which can be same in both the dataset. If its match then the performace coloumn from dummy dataset change from the performace value which already created dataset contains. edited ... View more

Hi community, I am using this code to find out today's file and read that file into a dataset: data _null_; length dsnname $100; today=put(today(),yymmdd7.); dsnname = compress('c:\temp\'||today||'.txt'); file phold filevar=dsnname notitles; put today; run;   but getting this error: Insufficient authorization to access /sas/config/Lev1/SASApp/c:\temp\200416.txt how to  solve this I also want to add '/folders/myfolders/sales.pdf' but don't know where to add this. my file format is OnlineUser20200416 but in the error it is showing 200416, please correct the date time format in this code too. I am using windows(EG sas) Thanks in advance Edited ... View more